OracleDB‎ > ‎

Listener

Oracle Listener

Start oracle listener. Note 'LISTENER' is the name of the listener.

$ lsnrctl start LISTENER

Set Listener Password
 lsnrctl

(the defautl old password might be listener)

 LSNRCTL> set password
 Password:
 The command completed successfully
 LSNRCTL> change_password
 Old password:
 New password:
 Reenter new password:
 Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ntl-alapatisam.netbsa.org
 )(PORT=1521)))
 Password changed for LISTENER
 The command completed successfully
 LSNRCTL> save_config
 Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ntl-alapatisam.netbsa.org
 )(PORT=1521)))
 Saved LISTENER configuration parameters.
 Listener Parameter File
 /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
 Old Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.bak



Listener Problem on Linux
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.

Comments