靜態監聽的狀態是UNKNOWN。當數據庫狀態是OPEN時，動態監聽是READY；當數據庫狀態是NOMOUNT時，動態監聽狀態是BLOCKED。

LSNRCTL> status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.65)(PORT=1521)))

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production

Start Date 02-DEC-2019 00:35:47

Uptime 0 days 6 hr. 20 min. 52 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

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

Listener Log File /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.65)(PORT=1521)))

Services Summary...

Service "his" has 2 instance(s).

Instance "his", status UNKNOWN, has 1 handler(s) for this service...

Instance "his", status BLOCKED, has 1 handler(s) for this service...

Service "hisdb" has 1 instance(s).

Instance "his", status BLOCKED, has 1 handler(s) for this service...

The command completed successfully

總結

以上是生活随笔為你收集整理的oracle判断侦听状态,oracle 监听状态为BLOCKED的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。