Home » RDBMS Server » Networking and Gateways » ORA-27101: shared memory realm does not exist
ORA-27101: shared memory realm does not exist [message #182286] Fri, 14 July 2006 02:47 Go to next message
gregrlb
Messages: 5
Registered: July 2006
Location: Belgium
Junior Member
Hello,

I'm running an Oracle 10g DB on a Solaris 10. A few days ago, I got a full partition and it crashed. Since then:
1) sqlplus /nolog
connect / as sysdba
startup
ORACLE instance started.

Total System Global Area 612368384 bytes
Fixed Size 1303832 bytes
Variable Size 345774824 bytes
Database Buffers 264241152 bytes
Redo Buffers 1048576 bytes
Database mounted.
Database opened.

2) sqlplus
Enter user-name: USER
Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

3) sqlplus -L USER/PASSWORD@DB_NAME
SQL*Plus: Release 10.1.0.3.0 - Production on Fri Jul 14 09:42:09 2006

Copyright (c) 1982, 2004, Oracle. All rights reserved.

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


SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus

4) sqlplus -L USER/PASSWORD
SQL*Plus: Release 10.1.0.3.0 - Production on Fri Jul 14 09:42:48 2006

Copyright (c) 1982, 2004, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL>


$ORACLE_SID contains the correct SID. But I still get these error messages (point 3). I was working before the crash.

If I try to access the DB via DBA Studio, I can connect but it tells me Oracle not available or that the DB is off.

Thanks in advance,

Greg.
Re: ORA-27101: shared memory realm does not exist [message #182331 is a reply to message #182286] Fri, 14 July 2006 06:49 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Please check the following:

1. Is your listener started (lsnrctl status)?
2. Do you have a DB_NAME entry in your TNSNAMES.ORA file?
3. Can you successfully TNSPING DB_NAME?
4. Is your DB registered with the listener (lsnrctl services)?

Re: ORA-27101: shared memory realm does not exist [message #182335 is a reply to message #182331] Fri, 14 July 2006 07:05 Go to previous messageGo to next message
gregrlb
Messages: 5
Registered: July 2006
Location: Belgium
Junior Member
1.
> lsnrctl status

LSNRCTL for Solaris: Version 10.1.0.3.0 - Production on 14-JUL-2006 13:50:54

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=host-test)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 10.1.0.3.0 - Production
Start Date                14-JUL-2006 10:19:22
Uptime                    0 days 3 hr. 31 min. 32 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/network/admin/listener.ora
Listener Log File         /oracle/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host-test)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
Services Summary...
Service "DB_NAME.WORLD" has 1 instance(s).
  Instance "DB_NAME", status READY, has 1 handler(s) for this service...
The command completed successfully


2.

DB_NAME =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = tcp)(HOST = host-test)(PORT = 1541))
    (CONNECT_DATA =(SID=DB_NAME))
  )


3.
> tnsping DB_NAME
TNS Ping Utility for Solaris: Version 10.1.0.3.0 - Production on 14-JUL-2006 13:54:36

Copyright (c) 1997, 2003, Oracle.  All rights reserved.

Used parameter files:
/global/oracle/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp)(HOST = host-test)(PORT = 1541)) (CONNECT_DATA =(SID=DB_NAME)))
OK (0 msec)


4.
> lsnrctl services

LSNRCTL for Solaris: Version 10.1.0.3.0 - Production on 14-JUL-2006 13:55:32

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=host-test)(PORT=1521))
Services Summary...
Service "DB_NAME.WORLD" has 1 instance(s).
  Instance "DB_NAME", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
The command completed successfully


5. To summarize:
'shutdown' and 'startup' as sysdba work.
Login via 'sqlplus -L USER/PASSWORD' works if $ORACLE_SID is OK.
Login via 'sqlplus and the login/password prompts' works.
Login via 'sqlplus -L USER/PASSWORD@DB_NAME' doesn't work.
Working on the DB in DBA Studio doesn't work.

What's weird is that I start up the DB, it tells me that the DB is mounted and opened. Then 'sqlplus -L USER/PASSWORD@DB_NAME' tells me:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory

Thanks,

Greg.
Re: ORA-27101: shared memory realm does not exist [message #182339 is a reply to message #182286] Fri, 14 July 2006 07:20 Go to previous messageGo to next message
gregrlb
Messages: 5
Registered: July 2006
Location: Belgium
Junior Member
A complementary detail about this problem:
When I connect to the DB throught DBA Studio, if I choose 'login as normal', it tells me the DB is off, and if I 'log as sysdba' it works ... So, although I get mounted and opened DB messages in SQLPlus, the DB looks to be down ...
Here's a 'ps -ef | grep -i DB_NAME':
  oracle 16945     1  0 13:42:47 ?        0:00 ora_cjq0_DB_NAME
  oracle 16937     1  0 13:42:46 ?        0:00 ora_lgwr_DB_NAME
  oracle 18177     1  0 13:43:20 ?        0:01 ora_mmon_DB_NAME
  oracle 16931     1  0 13:42:46 ?        0:00 ora_pmon_DB_NAME
  oracle 21327     1  0 14:15:31 ?        0:01 ora_q000_DB_NAME
  oracle 18181     1  0 13:43:21 ?        0:02 ora_j000_DB_NAME
  oracle 18175     1  0 13:43:19 ?        0:00 ora_qmnc_DB_NAME
  oracle 18155     1  0 13:43:17 ?        0:00 ora_arc0_DB_NAME
  oracle 18179     1  0 13:43:20 ?        0:00 ora_mmnl_DB_NAME
  oracle 16941     1  0 13:42:46 ?        0:01 ora_smon_DB_NAME
  oracle 18171     1  0 13:43:17 ?        0:00 ora_arc1_DB_NAME
  oracle 16935     1  0 13:42:46 ?        0:01 ora_dbw0_DB_NAME
  oracle 16933     1  0 13:42:46 ?        0:00 ora_mman_DB_NAME
  oracle 15857     1  0 14:12:53 ?        0:00 oracleDB_NAME (LOCAL=NO)
  oracle 16943     1  0 13:42:47 ?        0:00 ora_reco_DB_NAME
Re: ORA-27101: shared memory realm does not exist [message #182376 is a reply to message #182335] Fri, 14 July 2006 08:34 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Something is wrong: your TNSNAMES.ORA file points to port 1541, but the listener listens on 1521. Do you have more than one listener?

Can you please post your listener.ora file here?
Re: ORA-27101: shared memory realm does not exist [message #182387 is a reply to message #182376] Fri, 14 July 2006 09:04 Go to previous messageGo to next message
gregrlb
Messages: 5
Registered: July 2006
Location: Belgium
Junior Member
Yep, there are other listeners but are you sure there is a problem with it?

The entry for this DB in listener.ora is:

LISTENER1 =
   (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=tcp)(HOST=host-test)(PORT=1541))
      (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY_DB))
   )

SID_LIST_LISTENER1=
   (SID_LIST=
      (SID_DESC=
         (GLOBAL_DBNAME=DB_NAME.WORLD)
         (SID_NAME=DB_NAME)
         (ORACLE_HOME=/global/oracle)
      )

   )
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER1=OFF

(I added this last line yesterday to avoid a warning in the log of the listener)

Here's what's in TNSNAMES.ORA:

DB_NAME =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = tcp)(HOST = host-test)(PORT = 1541))
    (CONNECT_DATA =(SID=DB_NAME))
  )

Re: ORA-27101: shared memory realm does not exist [message #182408 is a reply to message #182387] Fri, 14 July 2006 11:15 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
OK, the "lsnrctl status" and "lsnrctl services" you've posted was for a different listener. Please post the output of:

lsnrctl status LISTENER1
lsnrctl services LISTENER1

Also, please confirm that that your database's ORACLE_HOME is /global/oracle.
Re: ORA-27101: shared memory realm does not exist [message #182417 is a reply to message #182408] Fri, 14 July 2006 12:58 Go to previous messageGo to next message
gregrlb
Messages: 5
Registered: July 2006
Location: Belgium
Junior Member
Here it comes:

1.
> lsnrctl status LISTENER1

LSNRCTL for Solaris: Version 10.1.0.3.0 - Production on 14-JUL-2006 19:53:52

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=host-test)(PORT=1541))
STATUS of the LISTENER
------------------------
Alias                     listener1
Version                   TNSLSNR for Solaris: Version 10.1.0.3.0 - Production
Start Date                13-JUL-2006 20:02:43
Uptime                    0 days 23 hr. 51 min. 9 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /global/oracle/network/admin/listener.ora
Listener Log File         /global/oracle/network/log/listener_echo.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host-test)(PORT=1541)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY_DB)))
Services Summary...
Service "AUDDB.WORLD" has 1 instance(s).
  Instance "AUDDB", status UNKNOWN, has 1 handler(s) for this service...
Service "DB_NAME.WORLD" has 1 instance(s).
  Instance "DB_NAME", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


2.
> lsnrctl services LISTENER1

LSNRCTL for Solaris: Version 10.1.0.3.0 - Production on 14-JUL-2006 19:54:50

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=host-test)(PORT=1541))
Services Summary...
Service "AUDDB.WORLD" has 1 instance(s).
  Instance "AUDDB", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "DB_NAME.WORLD" has 1 instance(s).
  Instance "DB_NAME", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:74 refused:0
         LOCAL SERVER
The command completed successfully


Thanks,

Greg.
Re: ORA-27101: shared memory realm does not exist [message #182459 is a reply to message #182417] Sat, 15 July 2006 02:23 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Your listener already accepted 74 connections for DB_NAME ("DEDICATED" established:74 refused:0). So, it looks like the listener is OK.
Re: ORA-27101: shared memory realm does not exist [message #189726 is a reply to message #182286] Fri, 25 August 2006 22:33 Go to previous message
ora10g
Messages: 7
Registered: July 2006
Junior Member
Please check the following:

1. check ORACLE_HOME, ORACLE_SID . more details http://www.easywebtech.com/check_oracle_environment_variabl.html
2.check listener and tnsnames configuration. http://www.easywebtech.com/oracle/con_err.html
3. check init.ora processes parameter and shared pool.http://www.easywebtech.com/oracle/ORA-27101_SHARED_MEMORY_REALM.html
Previous Topic: Connecting to oracle by remote
Next Topic: Installation Problem
Goto Forum:
  


Current Time: Mon Dec 05 05:12:16 CST 2016

Total time taken to generate the page: 0.13654 seconds