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

Make sure you have ORACLE_SID & ORACLE_HOME properly set for your Client connections. Confirm that listener.ora has correct entries for it. If on UNIX, remember that ORACLE_SID is case sensitive. Please search Metalink for this error number. There is a note related to this error.

HTH.

• Kirti Deshpande Verizon Information Services http://www.superpages.com

> -----Original Message-----
> From: Haskins, Ed [SMTP:Ed.Haskins_at_VerizonWireless.com]
> Sent: Monday, March 26, 2001 10:36 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: ORA-27101: shared memory realm does not exist
>
> Abiy,
>
> I'm not positive, but it appears that the server's Shared Memory may not
> be configured. Is the database started and open? I'm assuming not...if
> in fact Oracle can't allocate the SGA in Shared Memory. You may need to
> reconfigure your Shared Memory settings and recompile the UNIX Kernel.
> Check to see if these shared memory settings exist first.
>
> Ed Haskins]
> Oracle DBA
> Verizon Wireless
>
> -----Original Message-----
> From: ALEMU Abiy [mailto:abiy.alemu_at_criltechnology.com]
> Sent: Monday, March 26, 2001 10:41 AM
> To: Multiple recipients of list ORACLE-L
> Subject: ORA-27101: shared memory realm does not exist
>
>
> I have this error when I try to connect to a 8.1.7 database
> instance. I don't really know what's happening. To give just an
> information, on the server machine I've 2 database engines (7.3.4 and
> 8.1.7) and on both engines there are 2 or more instances running. I've
> only one listener.ora file for both engines, with the correct ORACLE_HOMES
>
> Thank you folks ...
>
> --------------------------------------------------------------------------
> ----------
> @biy @lemu
> abiy.alemu_at_criltelecom.com <mailto:abiy.alemu_at_criltelecom.com>
> Cril Telecom Software
> France
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.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).