DBA Tips Archive for Oracle
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 18.104.22.168.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 pipeYou 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.
Copyright (c) 1998-2017 Jeffrey M. Hunter. All rights reserved.
All articles, scripts and material located at the Internet address of http://www.idevelopment.info is the copyright of Jeffrey M. Hunter and is protected under copyright laws of the United States. This document may not be hosted on any other site without my express, prior, written permission. Application to host any of the material elsewhere can be made by contacting me at firstname.lastname@example.org.
I have made every effort and taken great care in making sure that the material included on my web site is technically accurate, but I disclaim any and all responsibility for any loss, damage or destruction of data or any other property which may arise from relying on it. I will in no case be liable for any monetary damages arising from such loss, damage or destruction.