My Oracle Support Banner

Intermittent listener start failure : TNS-12547 , Intermittent Listener status check failure : TNS:12535 (Doc ID 2294384.1)

Last updated on FEBRUARY 26, 2020

Applies to:

Oracle Net Services - Version 11.2.0.1 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.