OraFAQ Forum: Networking and Gateways » ORA-27101: shared memory realm does not exist

Home » RDBMS Server » Networking and Gateways » ORA-27101: shared memory realm does not exist

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-27101: shared memory realm does not exist [message #182286]

Fri, 14 July 2006 02:47

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.

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #182331 is a reply to message #182286]

Fri, 14 July 2006 06:49

Frank Naude
Messages: 4596
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)?

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #182335 is a reply to message #182331]

Fri, 14 July 2006 07:05

gregrlb
Messages: 5
Registered: July 2006
Location: Belgium

Junior Member

1.
> lsnrctl status

Code: [Select all] [Show/ hide]

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

Code: [Select all] [Show/ hide]

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

3.
> tnsping DB_NAME

Code: [Select all] [Show/ hide]

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

Code: [Select all] [Show/ hide]

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.

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #182339 is a reply to message #182286]

Fri, 14 July 2006 07:20

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':

Code: [Select all] [Show/ hide]

  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

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #182376 is a reply to message #182335]

Fri, 14 July 2006 08:34

Frank Naude
Messages: 4596
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?

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #182387 is a reply to message #182376]

Fri, 14 July 2006 09:04

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:

Code: [Select all] [Show/ hide]

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:

Code: [Select all] [Show/ hide]

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

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #182408 is a reply to message #182387]

Fri, 14 July 2006 11:15

Frank Naude
Messages: 4596
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.

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #182417 is a reply to message #182408]

Fri, 14 July 2006 12:58

gregrlb
Messages: 5
Registered: July 2006
Location: Belgium

Junior Member

Here it comes:

1.
> lsnrctl status LISTENER1

Code: [Select all] [Show/ hide]

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

Code: [Select all] [Show/ hide]

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.

Report message to a moderator