Contact Premier Online Trainings Today

Oracle DBA - The listener supports no services

Date Added: 23 Dec.2019 Date Updated: 23 Dec.2019 Oracle DBA Full Blog

The listener supports no services

 

When I checked the listener status, it was display as below and specified as no service are running

[oracle@oim admin]$ lsnrctl status OIMPRD
 
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 23-DEC-2019 22:12:12
 
Copyright (c) 1991, 2011, Oracle.  All rights reserved.
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oim.premier.com)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias                     OIMPRD
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                23-DEC-2019 22:11:40
Uptime                    0 days 0 hr. 0 min. 32 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/OIMPRD/oraoim/db/product/11.2.0/network/admin/listener.ora
Listener Log File         /u01/OIMPRD/oraoim/diag/tnslsnr/oim/oimprd/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oim.premier.com)(PORT=1522)))
The listener supports no services
The command completed successfully
[oracle@oim admin]$
 
I try to do “alter system register” and try multiple things. But nothing work out for me
Reason for no service are displayed in the listener status, No service are register with the listener. To register the service in the listener, we need to configure local_listener
 
SQL> alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=oim.premier.com)(PORT=1522))';
 
SQL> show parameter local_listener
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      (ADDRESS=(PROTOCOL=TCP)(HOST=o
                                                              im.premier.com)(PORT=1522))
SQL>
 
SQL> show parameter spfile
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u01/OIMPRD/oraoim/db/product/
                                                 11.2.0/dbs/spfileOIMPRD.ora
 
SQL>
SQL> ALTER SYSTEM REGISTER;
 
System altered.
 
 
SQL>
SQL> shut immediate
SQL> startup
 
 
[oracle@oim admin]$ lsnrctl status OIMPRD
 
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 23-DEC-2019 22:17:56
 
Copyright (c) 1991, 2011, Oracle.  All rights reserved.
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oim.premier.com)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias                     OIMPRD
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                23-DEC-2019 22:11:40
Uptime                    0 days 0 hr. 6 min. 16 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/OIMPRD/oraoim/db/product/11.2.0/network/admin/listener.ora
Listener Log File         /u01/OIMPRD/oraoim/diag/tnslsnr/oim/oimprd/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oim.premier.com)(PORT=1522)))
Services Summary...
Service "OIMPRD" has 1 instance(s).
  Instance "OIMPRD", status READY, has 1 handler(s) for this service...
Service "OIMPRDXDB" has 1 instance(s).
  Instance "OIMPRD", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@oim admin]$