Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2004
    Location
    London
    Posts
    76

    Unanswered: Shared memory realm does not exist

    This error keeps appearing on occasions on one of my servers, can anyone help in trying to find out the cause and a possible solution?

    System Details:
    Oracle 9i
    Windows Advanced Server

    PS. I relatively new in the world of Oracle 9i!!

    Thanks,

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Usually means the database is not up

  3. #3
    Join Date
    Feb 2004
    Posts
    45
    My experience is that this error occurs when the SID is misspelled (or not properly cased). Oracle uses the SID name to hash a memory address where the SGA (and other things) are loaded. If you misspell the SID, the computed hash address contains something that doesnt look liek what oracle expects, so it barfs.
    It was working just 5 minutes ago - I promise !

  4. #4
    Join Date
    Jan 2004
    Location
    Scottsdale, AZ
    Posts
    106
    With windows, you may need to set it in your dos session or as an environment variable.
    "Take Control!
    Make The Choice!
    Accept The Consequences!
    Deal With The Results! "

  5. #5
    Join Date
    Jan 2004
    Location
    India
    Posts
    113
    This is just becuase of failure of the intialization of memory structure and consequently that means ur instance is not running .
    To be on the safe side u delete the instance and create one using
    oradim utility .
    Do create the password file using orapwd utility if u donot mention it with the oradim utility.
    Then at ur command prompt or set it as an Environment variable as
    Set Oracle_SID=<newly created sid>.
    or
    Oracle_SID=<newly created sid>

    Good luck

  6. #6
    Join Date
    Feb 2004
    Location
    London
    Posts
    76

    Thanks

    Thank you for all your help...

Posting Permissions

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