部署11.2.0.1.0版本数据库的时候,开启监听的问题。
[oracle@www ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 06-MAR-2013 14:51:40 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=www.hg.com)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused
根据MOS
In this Document Symptoms Changes Cause Solution References -------------------------------------------------------------------------------- Applies to: Oracle Net Services - Version 9.2.0.1.0 to 11.2.0.3 [Release 9.2 to 11.2] Information in this document applies to any platform. Any Oracle 9i, 10g, or 11g listener version can display these problems. Checked for relevance on 30-SEP-2011. Symptoms Lsnrctl start yields the following information. Attempting to start the Oracle10g R2 (10.2.0.1.0) TNS Listener on Linux SuSE SLES9 x86_64: LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 02-DEC-2005 13:48:21 Copyright (c) 1991, 2005, Oracle. All rights reserved. Starting /u01/oracle/product/10gdb/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 10.2.0.1.0 - Production System parameter file is /u01/oracle/product/10gdb/network/admin/listener.ora Log messages written to /u01/oracle/product/10gdb/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prod1.us.oracle.com)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=prod1.us.oracle.com)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL =IPC)(KEY=EXTPROC0))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production Start Date 02-DEC-2005 13:48:22 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/oracle/product/10gdb/network/admin/listener.ora Listener Log File /u01/oracle/product/10gdb/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prod1.us.oracle.com)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "10gdb1" has 1 instance(s). Instance "10gdb1", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully Any of the following listener error stacks might be thrown: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=prod1.us.oracle.com)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) TNS-12537: TNS:connection closed TNS-12560: TNS:protocol adapter error TNS-00507: Connection closed Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=prod1.us.oracle.com)(PORT=1521))) TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact Linux Error: 104: Connection reset by peer Changes This is likely a new installation. Cause 1. There is possibly an incorrect IP Address specified for the host in the /etc/hosts file. For example: 192.168.101.101 prod1.us.oracle.com prod1 Whereas the actual ip address for the host "prod1.us.oracle.com" is 192.168.101.110 2. Also, the localhost reference may be incorrect or missing from the /etc/hosts file. 3. Oracle may not have read access to /etc/nsswitch.conf file. Solution To implement the solution, please execute the following steps: 1. Correct the mapping in the /etc/hosts file by adding/correcting the IP address and/or hostname reference for the Unix/Linux Server (both long and short host names). For example: # Add or edit the /etc/hosts file to include a valid entry for the Server: 192.168.101.110 prod1.us.oracle.com prod1 2. Check that the localhost loopback name and address are correct (both long and short host names). An example of a correct localhost entry would be as follows: 127.0.0.1 localhost.localdomain localhost 3. Remember to save the /etc/hosts file and then start the listener. 4. Check permissions on /etc/nsswitch.conf file to ensure group and other have read access. - If necessary change permisions on /etc/nsswitch.conf as follows: chmod 644 /etc/nsswitch.conf References @ BUG:4018733 - LISTENER FAILD WHEN USING SUSE LDAP @NOTE:162676.1 - UNDERSTANDING TRANSPORT LAYER ERROR CODES IN NET TRACE FILE 最终解决后的状态: [oracle@www ~]$ cat /etc/hosts # Do not remove the following line, or various programs # that require network functionality will fail. 127.0.0.1 localhost.localdomain localhost #::1 localhost6.localdomain6 localhost6 192.168.88.200 www.hg.com hg [root@www ~]# ll /etc/nsswitch.conf -rw-r--r-- 1 root root 1696 2004-09-23 /etc/nsswitch.conf [root@www ~]# chmod 644 /etc/nsswitch.conf [root@www ~]# ll /etc/nsswitch.conf -rw-r--r-- 1 root root 1696 2004-09-23 /etc/nsswitch.conf [root@www ~]# su - oracle [oracle@www ~]$ lsnrctl start LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 06-MAR-2013 15:23:22 Copyright (c) 1991, 2009, Oracle. All rights reserved. Starting /u01/oracle/product/11.0.2/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.1.0 - Production System parameter file is /u01/oracle/product/11.0.2/network/admin/listener.ora Log messages written to /u01/oracle/diag/tnslsnr/www/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=www.hg.com)(PORT=1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=www.hg.com)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 06-MAR-2013 15:23:22 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/oracle/product/11.0.2/network/admin/listener.ora Listener Log File /u01/oracle/diag/tnslsnr/www/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=www.hg.com)(PORT=1521))) The listener supports no services The command completed successfully [oracle@www ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 06-MAR-2013 15:24:06 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=www.hg.com)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 06-MAR-2013 15:23:22 Uptime 0 days 0 hr. 0 min. 43 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/oracle/product/11.0.2/network/admin/listener.ora Listener Log File /u01/oracle/diag/tnslsnr/www/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=www.hg.com)(PORT=1521))) The listener supports no services The command completed successfully