LISTENER Status:

Ready --- When Instance started in open mode with dynamic registration
Unknown --- When Instance started in open mode with static registration
Blocked --- When Instance in in nomount
Restricted --- When Instance is started with restricted session

Dynamic Listener:
=================
LISTENER_DEVDB =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclelab1.localdomain.com)(PORT = 1521))
)
)

Static Listener:
================
LISTENER_DEVDB =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclelab1.localdomain.com)(PORT = 1521))
)
)

SID_LIST_LISTENER_DEVDB=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=DEVDB)
(SID_NAME=DEVDB)
(ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1)
)
)

tnsnames:
=========
DEVDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclelab1.localdomain.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DEVDB)
)
)

https://mallik034.blogspot.com/2021/10/oracle-database-listener-status-ready.html

#listener #tnsnames #Ready #Blocked #Unknown #Restricted #RAC #Tutorial #FreeCourse #Learning #Database #Administration #Exadata #oracle

Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848