Pages

Showing posts with label cloned. Show all posts
Showing posts with label cloned. Show all posts

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;