Oracle Database Discussions

Hi, Oracle 10.2.0.4 on Redhat 4 U5 32 Bit.

this was previously a 9iR2 box and was upgraded to 10g, everything is working apart from srvctl for the database / instance.

i can start the database using sqlplus fine but using srvctl keeps erroring until it times out.

The only thing I have to go on is an error in the listener.log

TNS-12502: TNS:listener received no CONNECT_DATA from client

This appers every few seconds until the command times out.

My listener.ora is like this (and its started and registered with crs)

LISTENER_SERVER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY=ora_racg_lprd_server))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server-vip)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521)(IP = FIRST))
)
)
)

SID_LIST_LISTENER_SERVER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/ora10g/db1)
(PROGRAM = extproc)
)
(SID_DESC =
(ORACLE_HOME = /u01/app/oracle/product/ora10g/db1)
(SID_NAME = orcl1)
)
(SID_DESC =
(GLOBAL_DBNAME=orcl)
(ORACLE_HOME = /u01/app/oracle/product/ora10g/db1)
(SID_NAME = orcl1)
)

)

and tnsnames.ora

orcl1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server-vip)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl1)
)
)

orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server-vip)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl1)
)
)

Removing the database from the crs and re-adding it doesnt seem to help

Stuck as to where to look on this one.

Any ideas?

Thanks