TNS-12560: TNS:protocol adapter error
Posted by Kamran Agayev A. on July 31st, 2012
Today, after installing Critical Security Patches, the listeners didn’t start up and I got the following error:
-bash-3.2$ lsnrctl status
LSNRCTL for HPUX: Version 10.2.0.4.0 – Production on 31-JUL-2012 14:24:51
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
HPUX Error: 239: Connection refused
When I tried to start it, I got the following error:
-bash-3.2$ lsnrctl start LISTENER
LSNRCTL for HPUX: Version 10.2.0.4.0 – Production on 31-JUL-2012 14:25:01
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /home/oracle/product/10gR2/bin/tnslsnr: please wait…
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
HPUX Error: 32: Broken pipe
Actually I hate these type of unknown and unexplainable errors. After checking metalink notes, I didn’t get any useful information.
As I got the error after patch installation, I tried to relink tns again:
-bash-3.2$ cd $ORACLE_HOME/network/lib
-bash-3.2$ make -f ins_net_server.mk.32 install
Then I started the listener and succeeded
July 31st, 2012 at 12:42 pm
hi all
that errors comes when you are connecting from client without giving
service name and so listner is not reloaded so stop listener reload
and start listener problem is resolved
ramkumar
August 2nd, 2012 at 7:16 am
There’re many reasons which can cause the error. In my situation the listener was working before applying patch, I stopped and reloaded it and didn’t succeeded. And I wasn’t connecting with client, I was just trying to start the listener.