This means you don't have an instance started (equivalent of starting a database in nomount stage or equivalent of the first of three stages of database starting) with the sid name in your session memory now. Please check that the sid is set to what you are trying to connect as. If your sid is set to something other than the name of the database you are trying to connect to, you are likely to get this message.
Gurmohan
www.freemath.info
-----Original Message-----
From: Kalpana R.
[mailto:oracledba-ezmlmshield-x54220341.[Email address protected]
Sent: Sunday, July 31, 2005 11:41 PM
To: LazyDBA Discussion
Subject: ORA-27101: shared memory realm does not exist
Hi DBAs,
I am confronted with the following error.
The database is not starting up.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Please help me immediately.
I am hoping there is a solution to get out of this, since I do not have
back ups for a few schemas in the database.
Regards,
Kalpana.
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page