Sunday, January 17, 2010

Abnormal listener behaviour

Problem :


a ) Error message while stopping the listener

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=202.154.175.13)(PORT=1521)))

TNS-12547: TNS:lost contact

TNS-12560: TNS:protocol adapter error

TNS-00517: Lost contact

IBM/AIX RISC System/6000 Error: 73: Connection reset by peer


b ) Listener is running


c ) From the outside , when you're doing "tnsping " .you're getting .


TNS:lost contact OR TNS : Connection closed


d ) sqlnet.ora is also OK . No extra parameter except " NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME) "


Solution :


I searched a lot over net . But didn't found any solution . So I did the following ..


Step 1 : kill the listener

[csnetroiap:oraspx] /orahome/oracle/network/admin # ps -ef |grep lsn

oraspx 692234 762032 0 09:51:43 pts/3 0:00 grep lsn

oraspx 508176 1 0 Jan 07 - 218:56 /orahome/oracle/bin/tnslsnr LISTENER -inherit

[csnetroiap:oraspx] /orahome/oracle/network/admin # kill -9 508176


Step 2 : Restarted the listener

[csnetroiap:oraspx] /orahome/oracle/network/admin # lsnrctl start LISTENER

LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production on 16-JAN-2010 09:52:01

Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.

Starting /orahome/oracle/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production

System parameter file is /orahome/oracle/network/admin/listener.ora

Log messages written to /orahome/oracle/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=202.154.175.13)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=202.154.175.13)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production

Start Date 16-JAN-2010 09:52:01

Uptime 0 days 0 hr. 1 min. 15 sec

Trace Level off

Security OFF

SNMP OFF

Listener Parameter File /orahome/oracle/network/admin/listener.ora

Listener Log File /orahome/oracle/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=202.154.175.13)(PORT=1521)))

Services Summary...

Service "lgeil" has 1 instance(s).

Instance "lgeil", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully


And it worked for me .

1 comment:

Unknown said...

I also did the same and it worked. Thanks