Pages

Saturday, January 2, 2021

The listener supports no services


New listener or new database cloned, listener not registered.


LSNRCTL> status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.20.27.134)(PORT=1526)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER11

Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production

Start Date                02-JAN-2021 21:43:33

Uptime                    0 days 0 hr. 0 min. 33 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /app/oracle/product/11.2.0.2/dbhome_1/network/admin/listener.ora

Listener Log File         /app/oracle/diag/tnslsnr/prjutyu01/listener11/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.20.27.134)(PORT=1526)))

The listener supports no services

The command completed successfully

LSNRCTL> 




Solution:

    (To register the listener with database)

SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.20.27.134)(PORT=1526)))' scope=both;


SQL> alter system register;