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

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 1 Nov 2006 09:00:11 -0800
Message-ID: <1162400410.969065.85460@e3g2000cwe.googlegroups.com>

Mathijs wrote:
> Hi,
>
> I installed OracleExpress on a windows 2003 server. Right after the
> installation, I was able to create and use a database. Then, after the
> first reboot, the database didn't start automatically, but after
> SQL> connect /
> SQL> startup
> things worked fine again. Now, after a third reboot, this trick doesn't
> work anymore:
> SQL> connect /
> ERROR:
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
>
> Q: How can I fix this? (there is already data in my database that I
> really would like to use) And that Oracle behaves differently after the
> second and the third reboot?
>
> Thanks in advance for your help. Below is the result of a few obvious
> things that I checked before posting this message.
>
> M.
>
>
> I've checked the ORACLE_SID in the environment and it is set to XE.
> >set
> ...
> ORACLE_SID=XE
> ...
>
> The listener is running:
> >lsnrctl status XE
> STATUS of the LISTENER
> ------------------------
> Alias LISTENER
> Version TNSLSNR for 32-bit W..: Ver.. 10.2.0.1.0 - Production
> Start Date 01-NOV-2006 10:29:36
> Uptime 0 days 0 hr. 1 min. 22 sec
> Trace Level off
> Security ON: Local OS Authentication
> SNMP OFF
> Default Service XE
>
> and tnsping works:
> >tnsping xe
> ...
> OK (30 msec)

I compared your LSNRCTL STATUS SID output with that of my server. This is what my output looks like:

Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version
10.2.0.2.0 - Production
Start Date                28-OCT-2006 09:35:22
Uptime                    4 days 3 hr. 4 min. 13 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF

Listener Parameter File
D:\oracle\product\10.2.0\db_1\network\admin\listener.ora Listener Log File
D:\oracle\product\10.2.0\db_1\network\log\listener.log Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myservername)(PORT=1521))) Services Summary...
Service "DB1" has 1 instance(s).
  Instance "DB1", status UNKNOWN, has 1 handler(s) for this service... Service "DB1.world" has 1 instance(s).
  Instance "DB1", status READY, has 1 handler(s) for this service... Service "DB1_XPT.world" has 1 instance(s).   Instance "DB1", status READY, has 1 handler(s) for this service... Service "DB2" has 1 instance(s).
  Instance "DB2", status UNKNOWN, has 1 handler(s) for this service... Service "DB2.world" has 1 instance(s).
  Instance "DB2", status READY, has 1 handler(s) for this service... Service "DB2_XPT.world" has 1 instance(s). The command completed successfully

It looks like your system is set to automatically register databases, while I hand edited the listener.ora file to add the connections.

Also, I noticed that your spfile specifies 20 sessions, while the alert log shows 49 on the last startup, but I am not sure if this has any impact.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Wed Nov 01 2006 - 11:00:11 CST