Monday, April 2, 2012

Oracle listener failing to start (Broken pipe)

Have you faced this ?
Oracle listener broken pipe error as given below...


Starting /u01/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:

Go to $ORACLE_HOME/network/logs
Examine the size of the listener log and if it has reached 2GB, archive it and now try starting the listener. 

No comments:

Post a Comment