Thursday, August 9, 2012

TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused

While starting listener I got the following error
 lsnrctl start VIS

LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 09-AUG-2012 16:16:03

Copyright (c) 1991, 2008, Oracle.  All rights reserved.

Starting /apps/oracle/VIS/db/tech_st/11.1.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.1.0.7.0 - Production
System parameter file is /apps/oracle/VIS/db/tech_st/11.1.0/network/admin/VIS_starworld/listener.ora
Log messages written to /apps/oracle/VIS/db/tech_st/11.1.0/log/diag/tnslsnr/starworld/vis/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=starworld.appstek.ca)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=starworld.appstek.ca)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused


After investigating I noticed that the /etc/hosts had a different ip assigned for the server
cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.1.66    starworld.appstek.ca starworld

ifconfig -a
lo        Link encap:Local Loopback 
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:16 errors:0 dropped:0 overruns:0 frame:0
          TX packets:16 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:960 (960.0 b)  TX bytes:960 (960.0 b)

pan0      Link encap:Ethernet  HWaddr FA:0F:D0:E4:A5:B3 
          BROADCAST MULTICAST  MTU:1500  Metric:1
          RX packets:0 errors:0 dropped:0 overruns:0 frame:0
          TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:0 (0.0 b)  TX bytes:0 (0.0 b)

wlan0     Link encap:Ethernet  HWaddr 8C:A9:82:AD:17:9A 
          inet addr:192.168.1.80  Bcast:192.168.1.255  Mask:255.255.255.0
          inet6 addr: fe80::8ea9:82ff:fead:179a/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:12798 errors:0 dropped:0 overruns:0 frame:0
          TX packets:7146 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000
          RX bytes:11929017 (11.3 MiB)  TX bytes:1324436 (1.2 MiB)

I changed the ip to point to the correct ip address.
[root@starworld Desktop]# vi /etc/hosts
[root@starworld Desktop]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.1.80    starworld.appstek.ca starworld


 and then started the listener again and Voila it worked.
 lsnrctl start VIS

LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 09-AUG-2012 16:18:34

Copyright (c) 1991, 2008, Oracle.  All rights reserved.

Starting /apps/oracle/VIS/db/tech_st/11.1.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.1.0.7.0 - Production
System parameter file is /apps/oracle/VIS/db/tech_st/11.1.0/network/admin/VIS_starworld/listener.ora
Log messages written to /apps/oracle/VIS/db/tech_st/11.1.0/log/diag/tnslsnr/starworld/vis/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=starworld.appstek.ca)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=starworld.appstek.ca)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     VIS
Version                   TNSLSNR for Linux: Version 11.1.0.7.0 - Production
Start Date                09-AUG-2012 16:18:34
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /apps/oracle/VIS/db/tech_st/11.1.0/network/admin/VIS_starworld/listener.ora
Listener Log File         /apps/oracle/VIS/db/tech_st/11.1.0/log/diag/tnslsnr/starworld/vis/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=starworld.appstek.ca)(PORT=1521)))
Services Summary...
Service "VIS" has 1 instance(s).
  Instance "VIS", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oravis@starworld VIS_starworld]$