oracle包状态经常丢失,listener.ora丢失，但监听状态正常，求解
很明显 你这个监听器是在listener.ora文件丢失后重启的.如果在listener.ora丢失前启动的执行listener status 会包含Listener Parameter File信息例如 :有listener.ora[oracle@neworacle oracle]$ lsnrctl statusLSNRCTL for Linux: Version 10.2.0.4.0 - Pr
很明显 你这个监听器是在listener.ora文件丢失后重启的.
如果在listener.ora丢失前启动的
执行listener status 会包含Listener Parameter File信息
例如 :
有listener.ora
[oracle@neworacle oracle]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 09-SEP-2010 15:53:40
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.203.196)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date 09-SEP-2010 12:44:52
Uptime 0 days 3 hr. 8 min. 48 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0.4/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0.4/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.203.196)(PORT=1521)))
Services Summary...
Service "idctest" has 2 instance(s).
Instance "idctest", status UNKNOWN, has 1 handler(s) for this service...
Instance "idctest", status READY, has 1 handler(s) for this service...
Service "idctest.ique" has 1 instance(s).
Instance "idctest", status READY, has 1 handler(s) for this service...
Service "idctest_XPT" has 1 instance(s).
Instance "idctest", status READY, has 1 handler(s) for this service...
The command completed successfully
无listener.ora 自动注册
[oracle@neworacle admin]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 09-SEP-2010 15:55:09
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date 09-SEP-2010 15:54:21
Uptime 0 days 0 hr. 0 min. 47 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /u01/app/oracle/product/10.2.0.4/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=neworacle.ique.com)(PORT=1521)))
Services Summary...
Service "idctest" has 1 instance(s).
Instance "idctest", status READY, has 1 handler(s) for this service...
Service "idctest.ique" has 1 instance(s).
Instance "idctest", status READY, has 1 handler(s) for this service...
Service "idctest_XPT" has 1 instance(s).
Instance "idctest", status READY, has 1 handler(s) for this service...
The command completed successfully
魔乐社区（Modelers.cn) 是一个中立、公益的人工智能社区，提供人工智能工具、模型、数据的托管、展示与应用协同服务，为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作，由全产业链共同建设、共同运营、共同享有，推动国产AI生态繁荣发展。
更多推荐
0
0- 0
已为社区贡献9条内容
所有评论(0)