Oracle does not exist and shared memory realm does not exist error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Blessy
    New Member
    • Aug 2008
    • 4

    Oracle does not exist and shared memory realm does not exist error

    Before restarting my server i was able to access my local database.When I restarted the server it is giving the following error.

    ORA- 01034 : ORACLE not available
    ORA-27101 : shared memory realm does not exist

    when i started the server by giving the command

    >startup <database>

    it is not working properly.My database is not getting started.It say control file is not present.But that is present there.

    What to do?
    Could you please help me on this.
  • r035198x
    MVP
    • Sep 2006
    • 13225

    #2
    Check whether your ORACLE_SID is set. If that doesn't work, post the exact error message you are getting when trying to start the database.

    Comment

    • Blessy
      New Member
      • Aug 2008
      • 4

      #3
      Originally posted by r035198x
      Check whether your ORACLE_SID is set. If that doesn't work, post the exact error message you are getting when trying to start the database.

      ya i gave that command set oracle_sid=<my database name>

      and after that only i gave that command 'startup <database_name> .

      After that i got an error saying 'could not find or load Controls files'.
      But all the control files are present.

      Comment

      • r035198x
        MVP
        • Sep 2006
        • 13225

        #4
        Originally posted by Blessy
        ya i gave that command set oracle_sid=<my database name>

        and after that only i gave that command 'startup <database_name> .

        After that i got an error saying 'could not find or load Controls files'.
        But all the control files are present.
        Well if the control file are missing/moved the error you would get is
        Code:
        ORA-00205: error in identifying control file, check alert log for more info
        Check all the other required environment variables just to be sure (ORACLE_HOME e.t.c)

        Comment

        • Blessy
          New Member
          • Aug 2008
          • 4

          #5
          Originally posted by r035198x
          Well if the control file are missing/moved the error you would get is
          Code:
          ORA-00205: error in identifying control file, check alert log for more info
          Check all the other required environment variables just to be sure (ORACLE_HOME e.t.c)

          Sorry i have not set ORACLE_HOME,pre viously also it was not set.
          if i need to set ORACLE_HOME:-D:\oracle\ora92 \bin

          is it sufficient for me to give this because i have installed oracle in d:\

          As you have given set ORACLE_HOME and etc..

          what else i have to set ...as you have given etc....

          Comment

          • r035198x
            MVP
            • Sep 2006
            • 13225

            #6
            Originally posted by Blessy
            Sorry i have not set ORACLE_HOME,pre viously also it was not set.
            if i need to set ORACLE_HOME:-D:\oracle\ora92 \bin

            is it sufficient for me to give this because i have installed oracle in d:\

            As you have given set ORACLE_HOME and etc..

            what else i have to set ...as you have given etc....
            Do not set those variables on the command line if you are using windows. Set them as environment variables.
            Which OS are you using and which installation method did you use?

            Comment

            Working...