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
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
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
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
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:
I also did the same and it worked. Thanks
Post a Comment