The listener supports no services

27 Feb

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: