Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003

    Unanswered: Size of rootdbs and physdbs should always same


    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.


  2. #2
    Join Date
    Aug 2002
    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.

  3. #3
    Join Date
    Feb 2003

    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