oracle状态blocked,oracle 监听状态为BLOCKED
静态监听的状态是UNKNOWN。当数据库状态是OPEN时,动态监听是READY;当数据库状态是NOMOUNT时,动态监听状态是BLOCKED。LSNRCTL> statusConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.65)(PORT=1521)))STATUS of the LISTENER------
静态监听的状态是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
来源:oschina
链接:https://my.oschina.net/u/4327970/blog/3337160
魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。
更多推荐



所有评论(0)