Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Location
    HYD-INDIA
    Posts
    3

    Unanswered: Size of rootdbs and physdbs should always same

    Hi..

    After creating the new instance, when i try to initilised the shared memory i got the below message

    For disk space initialization, the value specified in the ONCONFIG file for
    PHYSDBS (physlog) should be equal to that of ROOTDBS (rootdbs).
    oninit: Fatal error in shared memory initialization



    do we need to keep always both the values are of equal size.

    ChanduP

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Absolutely not!

    The physical log is at initialization time a part of the rootdbs.
    So the size should be at least smaller than the rootdbs. After initialization, you should change the location of your physical log from the rootdbs to another dbspace, like the physdbs.
    Set the correct parameters in the onconfig too.
    rws

  3. #3
    Join Date
    Feb 2003
    Posts
    24

    Smile Re: Size of rootdbs and physdbs should always same

    The ROOTDBS should greater than the physical log by atleast 30MB (to be safe) if your physical log is to be placed in the ROOTDBS. If you try to place the physical log to a separate space such as PHYSICALDBS, the total physical log size should be the size of your PHYSICALDBS. For best practices it should be separated, separted by disk is much better.

    I hope I have answered your question well.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •