Re: ORA-27101: shared memory realm does not exist

From: JimmyN1 <jimmyn1_at_aol.com>
Date: 26 Mar 2001 00:46:05 GMT
Message-ID: <20010325194605.20251.00001305@ng-mq1.aol.com>

Hi, i got this off metalink for you:

Problem Description

You are attempting a client connection to an 8i database via sqlplus and receive the following errors:

   ERROR:
   ORA-01034: ORACLE not available
   ORA-27101: shared memory realm does not exist    SVR4 Error: 2: No such file or directory

You have installed 8.1.7 on the same server in a seperate ORACLE_HOME. Solution Description

For local (BEQ) connections:

      Verify that ORACLE_SID is set and points to a valid 8.1.7
      database which is up and running.



       % echo $ORACLE_SID

       junk



       % ps -ef |grep smon

       oracle 24603     1  0 15:22:51 ?        0:02 ora_smon_JUNK

     In this scenario, as ORACLE_SID is case-sensitive on the Unix
     platform, a database called 'junk' isn't running.  The fix would
     be to set ORACLE_SID correctly or to the valid instance.



       % setenv ORACLE_SID JUNK

2) For remote (TCP/listener) connections:

     Review the listener.ora currently used to startup the listener
     and verify the ORACLE_HOME is correct for all listed 8i
     databases.

     If the ORACLE_HOME points to the 8.1.7 software yet the database
     was created with 8.1.6 or 8.1.5, then this error can occur.

Explanation

Previously when the ORACLE_HOME or ORACLE_SID was set incorrectly, in the 'oracle' or client user's environment, only ora-1034 was reported.

ORA-01034 "ORACLE not available"

With 8.1.7, the ora-27101 is reporting that the shared memory key generated by the client doesn't match any currently existing keys. This is to be expected if the ORACLE_HOME used by the client isn't the same as the one used to startup the database with or the ORACLE_SID is not correctly referencing the right instance. Received on Sun Mar 25 2001 - 18:46:05 CST