Oracle Listener Start oracle listener. Note 'LISTENER' is the name of the 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. |
OracleDB >