Listener-Broken pipe
I have successfully install Oracle on Linux, installed and configured my all Java and PHP application for a content Server and a SMS Gateway and everything is working fine. After several months later from an angry user saying that he cannot login to the application and the SMS getaway not working.
The error message indicates a problem connecting to the Oracle database. After some troubleshooting (lsntctl status) I have found the Oracle TNS listener is not running, I attempt to start it and get the following stack trace error:
[oracle@contentserver admin]$ lsnrctl start LSNRCTL for Linux: Version 9.2.0.1.0 - Production on 14-DEC-2009 08:44:43 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. Starting /u01/app/oracle/product/9.2.0.1.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
Then I have check with the SYS admin to only find out that nothing has changed with any of the network settings. Every this is ok.
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.
How to solve this problem:
Switch to the network log directory
[oracle@contentserver log]$ cd /u01/app/oracle/product/9.2.0.1.0/network/log
See the size of the listener.log, here I have found 2.1 GB
[oracle@contentserver log]$ du -h listener.log 2.1G listener.log
Copy the log file to the other directory if you need to backup this file for any kind of troubleshooting task.
[oracle@contentserver log]$ cp listener.log /home/oracle/
Then remove the file using OS command, to do this issue the following command.
[oracle@contentserver log]$ rm listener.log
Now start the listener service.
[oracle@contentserver log]$ lsnrctl start
Pages
My Calender
M | T | W | T | F | S | S |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | ||
6 | 7 | 8 | 9 | 10 | 11 | 12 |
13 | 14 | 15 | 16 | 17 | 18 | 19 |
20 | 21 | 22 | 23 | 24 | 25 | 26 |
27 | 28 | 29 | 30 | 31 |
Blog Stats
- 669,214 hits
Categories
- Database Script (6)
- Design (1)
- How To (41)
- Backup & Recovery (9)
- Backup-Restore Control File (1)
- Cancel-Based Recovery (1)
- Export And Import (1)
- Flashback Recovery (2)
- RECYCLE BIN (1)
- RMAN Backup (1)
- RMAN Configuration (1)
- RMAN Recover (1)
- Clear Buffer Cash and shared_pool (1)
- Create directory in Oracle (1)
- Customize Function and Procedure (3)
- Convert Number to Word (1)
- SPLIT Function (1)
- Wrapping PL/SQL (1)
- DBMS_PACKEGE (6)
- DBMS_JOB (1)
- DBMS_UTILITY (1)
- GATHER_SCHEMA_STAT (1)
- PL/SQL Lock Timer (1)
- UTL_MATCH (1)
- UTL_SMTP & UTL_MAIL (1)
- Error Solving (6)
- Managing Database Objects (2)
- Managing Index (1)
- Managing Tablespace (1)
- oradim in Linux (1)
- Partition Table In Oracle (1)
- Performace Tuning (4)
- Ref Cursor (1)
- Trick And Tips (4)
- Uninstall Oracle (1)
- Backup & Recovery (9)
- Linux And Unix (9)
- Oracle10g (19)
- AUDIT_TRAIL in Oracle (2)
- CONTROLFILE AUTO BACKUP (1)
- DBA_VIEWS (1)
- dbora Script for RHEL (1)
- Enabling Archive Log (1)
- Listener Commands (1)
- Monotoring Session And SQL (1)
- Oracle 10g Enterprise Manager (3)
- Parameterized View in Oracle (1)
- Proxy User in Oracle (1)
- RESTRICTED SESSION (1)
- Size Of SGA (2)
- SQL Tuning Advisor (1)
- Oracle11g (1)