Tom: I believe the problem is the same on Win as Unix. Here are some notes I made on this error. hope they help.
Barb > When you start the database, a key for the shared memory segment is > calculated based on the contents of ORACLE_SID and ORACLE_HOME. When you > try to connect to the database, your process needs to find the shared > memory > segment. It does so by matching your oracle_sid and oracle_home against > this hashed key. (In the case of a network connection, it does this by > using > the oracle_sid and oracle_home in the listener.) > > > Check to see how your environment was set when you started the database > versus how it is set when you're trying to connect. In particular, if the > oracle_home path or the oracle_sid is different in any way,you'll get the > messages > > ORA-01034: ORACLE not available > ORA-27101: shared memory realm does not exist > SVR4 Error: 2: No such file or directory > > In my case, I had the sid as lower case for the session that started the > database, and upper case in the listener.ora file. > > Good luck! > > Barb > > > ---------- > From: Tom Schruefer[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Sunday, June 30, 2002 9:53 AM > To: Multiple recipients of list ORACLE-L > Subject: ORA-27101 Error > > ORA-27101 = Shared Memory Realm is not available > > I have seen references to this error and how to repair it on UNIX systems, > but what is to be done on Win2000 when this thing rears its ugly head? > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Tom Schruefer > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
