Listener port number
KSGApr 16 2010 — edited Apr 18 2010Hi,
Oracle 11.1.0.6.0 on IBM-AIX
When I try to connect database, I get the below error
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
When I check listerner.log...
16-APR-2010 12:59:49 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=integ)(USER=oracle))(COMMAND=reload)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=185599488)) * reload * 0
16-APR-2010 12:59:57 * service_register * orcl * 0
WARNING: Subscription for node down event still pending
16-APR-2010 13:00:02 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=integ)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=185599488)) * status * 0
Fri Apr 16 13:00:56 2010
16-APR-2010 13:00:56 * (CONNECT_DATA=(SERVICE_NAME=testdb)(CID=(PROGRAM=sqlplus@integ)(HOST=integ)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.92.5.37)*(PORT=34487))* * establish * testdb * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
Fri Apr 16 13:01:58 2010
16-APR-2010 13:01:58 * (CONNECT_DATA=(SERVICE_NAME=testdb)(CID=(PROGRAM=sqlplus@integ)(HOST=integ)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.92.5.37)*(PORT=34507))* * establish * testdb * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
WARNING: Subscription for node down event still pending
16-APR-2010 13:02:04 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=integ)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=185599488)) * status * 0
Fri Apr 16 13:02:36 2010
16-APR-2010 12:59:49 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=integ)(USER=oracle))(COMMAND=reload)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=185599488)) * reload * 0
16-APR-2010 12:59:57 * service_register * orcl * 0
WARNING: Subscription for node down event still pending
16-APR-2010 13:00:02 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=integ)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=185599488)) * status * 0
Fri Apr 16 13:00:56 2010
16-APR-2010 13:00:56 * (CONNECT_DATA=(SERVICE_NAME=testdb)(CID=(PROGRAM=sqlplus@integ)(HOST=integ)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.92.5.37)(PORT=34487)) * establish * testdb * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
Fri Apr 16 13:01:58 2010
16-APR-2010 13:01:58 * (CONNECT_DATA=(SERVICE_NAME=testdb)(CID=(PROGRAM=sqlplus@integ)(HOST=integ)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.92.5.37)(PORT=34507)) * establish * testdb * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
WARNING: Subscription for node down event still pending
16-APR-2010 13:02:04 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=integ)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=185599488)) * status * 0
Fri Apr 16 13:02:36 2010
Kindly note my port number is keep on increasing...
Thanks in advance
KSG