Saturday, July 18, 2009

Starting 10gr2 TNS Listener Yields TNS-12541, Linux Error: 111: Connection Refused

Lsnrctl start yields the following information. Attempting to start the Oracle10g R2 (10.2.0.1.0) TNS Listeneron Linux SuSE SLES9 x86_64:

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 02-DEC-2005 13:48:21Copyright (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 - ProductionSystem parameter file is /u01/oracle/product/10gdb/network/admin/listener.oraLog messages written to /u01/oracle/product/10gdb/network/log/listener.logListening 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 listenerTNS-12560: TNS:protocol adapter errorTNS-00511: No listenerLinux Error: 111: Connection refusedConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL =IPC)(KEY=EXTPROC0)))

STATUS of the LISTENER
------------------------
Alias LISTENERVersion TNSLSNR for Linux: Version 10.2.0.1.0 - ProductionStart Date 02-DEC-2005 13:48:22Uptime 0 days 0 hr. 0 min. 0 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/oracle/product/10gdb/network/admin/listener.oraListener Log File /u01/oracle/product/10gdb/network/log/listener.logListening 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 listenerTNS-12560: TNS:protocol adapter errorTNS-00511: No listenerLinux Error: 111: Connection refused

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))TNS-12537: TNS:connection closedTNS-12560: TNS:protocol adapter errorTNS-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 prod1Whereas 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.
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.

1 comment:

tikitodo said...

maybe the adobe reader repair tool better suits your needs? I have recently tested several data recovery applications and I think it is the easiest one