Oracle Database Discussions

Hi,

Database version is- 10.1.0.5.0 on Veritas Cluster, We are able to connect without giving connect string. but when we provide connect string as orcl it gives

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

when we do tnsping it works
$ tnsping orcl

TNS Ping Utility for Linux: Version 10.1.0.5.0 - Production on 08-MAY-2013 15:00:40

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

Used parameter files:
/D01/OIDTEST/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = cluster_hostname)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.test.com)))
OK (0 msec)

tnsnames.ora entry :-
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = cluster_hostname)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.test.com)
)
)

listener.ora entry:-

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl.test.com)
(ORACLE_HOME = /D01/OID)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = cluster_hostname)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
)

listener log contains

08-MAY-2013 14:47:03 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl.test.com)(CID=(PROGRAM=sqlplus)(HOST=physical_hostname)(USER=oraprod))) * (ADDRESS=(PROTOCOL=tcp)(HOST=xx.yy.zz.xx)(PORT=63969)) * establish * orcl.test.com * 0
08-MAY-2013 14:50:49 * ping * 0
08-MAY-2013 14:51:21 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
WARNING: Subscription for node down event still pending
08-MAY-2013 14:51:33 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=physical_hostname)(USER=oraprod))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=168822016)) * status * 0

can you please advice.

Thanks

Edited by: user10702579 on May 8, 2013 11:09 AM