ORA-27101: shared memory realm does not exist

[sumit]

Hello,

I just installed 10.2.0.4 ASM and DBMS instance on AIX 5.3. Both instances are running. I can connect to to the sid

Greece/home/dbora>sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Aug 23 08:12:17 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.


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

SQL> conn system/manager
Connected.
SQL>

But while connecting as system/manager@testdt, getting following errors

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
IBM AIX RISC System/6000 Error: 2: No such file or directory


Instance Status

10204/network/admin>ps -ef|grep smon
dbora 160060 1 0 06:22:57 - 0:00 asm_smon_+ASM
dbora 181024 115202 0 08:19:30 pts/2 0:00 grep smon
dbora 82998 1 0 06:23:31 - 0:00 ora_smon_testdt


TNSENTRY

testdt =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = fl1.greece.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = testdt)
)
)


Listener
10204/network/admin>lsnrctl status

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 23-AUG-2010 08:15:24

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fl1.greece.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production
Start Date 23-AUG-2010 06:47:15
Uptime 0 days 1 hr. 28 min. 9 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /fldb1/RDBMS/oracle/product/10204/network/admin/listener.ora
Listener Log File /fldb1/RDBMS/oracle/product/10204/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.12.10.165)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "testdt" has 1 instance(s).
Instance "testdt", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

LISTENER File


LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = fl1.greece.com)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = extproc))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = testdt)
(ORACLE_HOME = /fldb1/RDBMS/oracle/product/10204/)
)
)

DIRECT_HANDOFF_TTC_LISTENER=OFF
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF


what am I missing?

Rgds

[davey23uk]

did you run root.sh correctly to set the permissions, what is $ORACLE_HOME/bin/oracle set to?

[sumit]

yup, I did.

anyway, we can close this thread as the problem got resolved ... How?


in listener file ... 1 additional / (in red below) caused the problem

(ORACLE_HOME = /fldb1/RDBMS/oracle/product/10204/)

Grrrr......

Regards