TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact



$ lsnrctl start

LSNRCTL for Linux: Version 9.2.0.6.0 - Production on 22-MAY-2011 08:35:43

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

Starting /apps/app/oracle/product/9.2.0/bin/tnslsnr: please wait...

TNS-12547: TNS:lost contact
 TNS-12560: TNS:protocol adapter error
  TNS-00517: Lost contact
   Linux Error: 32: Broken pipe


Solution

$cd $ORACLE_HOME/network/log

$ ls -lrt

total 2101620
-rw-r--r--  1 oracle oracle    2431052 May 21 12:29 sqlnet.log
-rw-r--r--  1 oracle oracle 2147483647 May 22 06:40 listener.log

Here listener.log has grown beyond 2Gb

To make it 0 size



$cat /dev/null>listener.log

Now start the listener.

 
 


Post a Comment

And that's all there is to it!

If anyone has any other questions or requests for future How To posts, you can either ask them in the comments or email me. Please don't feel shy at all!

I'm certainly not an expert, but I'll try my hardest to explain what I do know and research what I don't know.

Previous Post Next Post