DATE :-- 1st Sep 2014
|
Error at time of listener startup Linux Error: 111: Connection refused
Error :--
LSNRCTL>reload
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.161)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Issue :--
Incorrect Entry in /etc/hosts files
The Entry in the /etc/hosts was
[oracle@PR11G ~]$ cat /etc/hosts
127.0.0.1 localhost.localdomain
192.168.56.161 PR11G.localdomain PR11G
Resolution :--
I edited the /etc/hosts and put localhost at the last of 127.0.0.1
The new entry
[oracle@PR11G ~]$ cat /etc/hosts
127.0.0.1 localhost.localdomain localhost
192.168.56.161 PR11G.localdomain PR11G
LSNRCTL> reload
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.161)(PORT=1521)))
The command completed successfully
LSNRCTL> LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.161)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 31-AUG-2014 22:49:24
Uptime 0 days 0 hr. 1 min. 52 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/PR11G/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.161)(PORT=1521)))
Services Summary...
Service "DBPR11G" has 1 instance(s).
Instance "DBPR11G", status READY, has 1 handler(s) for this service...
Service "DBPR11GXDB" has 1 instance(s).
Instance "DBPR11G", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> [oracle@PR11G admin]$
No comments:
Post a Comment