Intermittent listener start failure : TNS-12547 , Intermittent Listener status check failure : TNS:12535
(Doc ID 2294384.1)
Last updated on MARCH 31, 2022
Applies to:
Oracle Net Services - Version 11.2.0.1 and laterInformation in this document applies to any platform.
Able to start the listener intermitently,sometimes starting the listener also fails and Unable to view listener status even if listener starts.
Symptoms
Actual Symptom :
Unable to start listener intermittently : failure message : TNS-12547
If listener started successfully Unable to check listener status : failure message : TNS-12535
Symptom Show Case :
lsnrctl start LISTENER => Intermittent
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production on 06-AUG-2017 22:23:05
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Starting $ORACLE_HOME/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
System parameter file is $ORACLE_HOME/network/admin/listener.ora
Log messages written to $ORACLE_BASE/diag/tnslsnr/<hostname>/LISTENER/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=<hostname>)(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
Sometimes the listener starts but lsnrctl status LISTENER fails
lsnrctl status LISTENER
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production on 06-AUG-2017 22:18:10
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=<hostname>)(Port=1521))
TNS-12535: TNS:operation timed out
TNS-12560: TNS:protocol adapter error
TNS-00505: Operation timed out
Listener.ora ;
LISTENER =
(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(Host =<hostname>)(Port = 1521))))
/etc/hosts :
127.0.0.1 loopback localhost #loopback (lo0) name/address
10.xx.xx.xx <hostname> <hostname>.<domain>
ifconfig -a :
eth0:inet 10.xx.xx.xx netmask 0xffffff00 broadcast 10.xx.xx.xx
lo0 :inet 127.0.0.1 netmask 0xff000000 broadcast 127.255.yyy.zzz
Changes
Changes in the OS level environment, product version , OS account and OS hardware.
AIX Server (IBM AIX on POWER Systems (64-bit) - Platform 6 ) was restarted and hostname ip-address link was broken on the OS.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |