TNS-12541 TNS-12560 TNS-00511 Linux Error: 111: Connection refused

部署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

Starting 10gr2 TNS Listener Yields TNS-12541, Linux Error: 111: Connection Refused [ID 343295.1]

 

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