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