Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-27101: shared memory realm does not exist

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


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US