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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-27101 "Shared Memory Realm Does Not Exist"

RE: ORA-27101 "Shared Memory Realm Does Not Exist"

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Tue, 30 Apr 2002 08:31:27 -0800
Message-ID: <F001.004537D1.20020430083127@fatcity.com>


Check memory on your server, you need to have enough physical RAM to hold your SGA and the Oracle processes.

The services applet lies, sometimes it will say that a database NT service is running when in fact it is in a half-opened state. An easy way to test is to connect from the command line using sqlplus or (gasp!) svrmgrl. connect as internal or as sysdba.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique 
Maritimes Region, DFO      | Région des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca

-----Original Message-----
Sent: Monday, April 29, 2002 5:43 PM
To: Multiple recipients of list ORACLE-L

I just installed Oracle 9i on a WinNT 4 server. It already had 8.1.6. I installed Oracle 9 into a different home. The service/instance starts. When I try to connect via sqlplus / to create a database I get ORA-27101 "Shared Memory Realm Does Not Exist" . I have the oracle_sid set correctly. Any ideas as I have tried all I know but still get the same error.

Thanks
Rick

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: Rick_Cale_at_teamhealth.com

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: ListGuru_at_fatcity.com (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: Boivin, Patrice J
  INET: BoivinP_at_mar.dfo-mpo.gc.ca
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: ListGuru_at_fatcity.com (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). Received on Tue Apr 30 2002 - 11:31:27 CDT

Original text of this message

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