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]$
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]$