1 Reply Latest reply on Feb 8, 2002 5:37 AM by 428960

    TNS-12547:TNS:lost contact

    11155
      After attempting to start the listener it is giving following errors
      TNS-12547:TNS:lost contact
      TNS-12560:TNS:protocol adapter error
      TNS-00517:lost contact
      Intel SVR4 UNIX Error: 32: Broken pipe


      Any help highly appreciated
      Thanks in advance
      Email:wlc321@sina.com
        • 1. Re: TNS-12547:TNS:lost contact
          428960
          Starting TNS Listener gives "Linux Error: 32: Broken pipe"

          by Jeff Hunter, Sr. Database Administrator

          You have successfully install Oracle on Linux, installed and configured your application and everything is working fine. You get a call several months later from an angry user saying that he cannot login to the application. The error message indicates a problem connecting to the Oracle database. After noticing the Oracle TNS listener is not running, you attempt to start it and get the following stack trace error:

          % lsnrctl start

          LSNRCTL for Linux: Version 8.1.7.4.0 - Production on 18-JUL-2003 10:54:01

          (c) Copyright 1998 Oracle Corporation. All rights reserved.

          Starting /u01/app/oracle/product/8.1.7/bin/tnslsnr: please wait...

          TNS-12547: TNS:lost contact
          TNS-12560: TNS:protocol adapter error
          TNS-00517: Lost contact
          Linux Error: 32: Broken pipe
          You then check with the SYS admin to only find out that nothing has changed with any of the network settings!
          This is one of those troubleshooting issues that can take several hours to track done. But as it turns out, the most common reason for this stack trace when attempting to start the listener is the log file for the listener ($ORACLE_HOME/network/log/listener.log) has reached its 2GB file size limit on Linux. To alleviate the problem, simply archive or delete the file and restart the listener.