Oracle – Linux – Network

Kegagalan listener start “The listener supports no services”

1. pada saat instance database sudah up dan listener juga start, kadang kita menemukan error “The listener supports no services”
[oracle@stby11g ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.1.0.6.0 – Production on 27-FEB-2009 20:19:31
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.20.22.21)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 – Production
Start Date 27-FEB-2009 20:19:22
Uptime 0 days 0 hr. 0 min. 9 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/stby11g/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.20.22.21)(PORT=1521)))
The listener supports no services
The command completed successfully

2. hal ini terjadi karena default install linux /etc/hosts-nya adalah
127.0.0.1 localhost.localdomain localhost stby11g  edit dan sesuaikan seperti di bawah ini :
127.0.0.1 localhost.localdomain localhost

atau lengkapnya seperti berikut :

[oracle@stby11g ~]$ su – root
Password:
[root@stby11g ~]# vi /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
# Public
172.20.22.21 stby11g.localdomain stby11g
[root@stby11g ~]# exit

3. reload listener
[oracle@stby11g ~]$ lsnrctl reload
LSNRCTL for Linux: Version 11.1.0.6.0 – Production on 27-FEB-2009 20:29:33
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.20.22.21)(PORT=1521)))
The command completed successfully

4. status listener sekarang
[oracle@stby11g ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.1.0.6.0 – Production on 27-FEB-2009 20:29:35
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.20.22.21)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 – Production
Start Date 27-FEB-2009 20:27:48
Uptime 0 days 0 hr. 1 min. 46 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/stby11g/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.20.22.21)(PORT=1521)))
Services Summary…
Service “stby11g” has 1 instance(s).
Instance “stby11g”, status READY, has 1 handler(s) for this service…
Service “stby11g_XPT” has 1 instance(s).
Instance “stby11g”, status READY, has 1 handler(s) for this service…
The command completed successfully