Oracle Database Listener Status - READY - UNKNOWN - RESTRICTED - BLOCKED

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)
)
)
mallik034.blog...
#listener #tnsnames #Ready #Blocked #Unknown #Restricted #RAC #Tutorial #FreeCourse #Learning #Database #Administration #Exadata #oracle
Regards,
Mallikarjun Ramadurg
Mobile: [phone]
WhatsApp: [phone]

[@xgabana2299]

Fantastic clarification! 🙏🙏

[@alekhyaalli3333]

Very useful information.. thanks a lot for this video

[@anulegehfualefeh19]

Awesome! Very informational, thanks.

[@sushantmagdum4145]

Something New added in knowledge 😊🙌

[@rithikachella]

Useful info... Excellent explanation...

[@vikrantpatil311]

Very Very Usefull Information Thank you :)

[@ShubhamSoni-jb7lh]

Sir please make videos how SQL query like SELECT,UPDATE etc execution process in oracle DBA.

[@watcheryt9441]

Superb

[@arifansari42]

Excellent 👍

[@VismoTechnologies]

Thanks

[@geckoklaus]

Very Good! Can you please cover how to login to a database via tnsconnect when database is in restricted mode. I would like to do the following approach: shutdown database, restart restricted (all current user are disconnected), grant user demo restricted session and let him login, but with no luck.

[@VismoTechnologies]

Use static listeners for that

[@meghakaradi]

❤❤

[@bharathkumar-ds8cd]

good session sir.

[@Earth38274]

Hi Mallik I am getting an error as vendor code 12528