If you are on windows, use oradim to drop and recreate the instance

Type oradim /? For syntax.

This will create the services and run them as local/system. However,
you might want to change that to run as a windows admin account, or
domain admin... for instance to duplex archive logs to a network share.

-----Original Message-----
From: Shergill Gurmohan
[mailto:oracledba-ezmlmshield-x60674309.[Email address protected]
Sent: Monday, August 01, 2005 9:43 AM
To: LazyDBA Discussion
Subject: RE: ORA-27101: shared memory realm does not exist

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


--------
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