Warning: Subscription For Node Down Event Still Pending
监听老是起不来,进入log文件一看,发现出现一大堆的Warning: Subscription For Node Down Event Still Pending。
于是去metalink所寻下,发现如下一片文章,其中方法可以解决本机环境遇到的问题
Warning: Subscription For Node Down Event Still Pending' In Listener Log (Doc ID 372959.1)
Oracle Net Services - Version 10.2.0.1 to 11.2.0.4 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 29-JAN-2014***
This issue affects only 10g and newer listeners.
Symptoms
You are receiving the following warning messages in the listener.log file constantly:
'WARNING: Subscription for node down event still pending'
Changes
This may be a new installation or a recent upgrade to 10g or newer.
Cause
These messages are related to the Oracle TNS Listener's default subscription to the Oracle Notification Service (ONS). In a non-RAC environment it is recommended to disable this subscription. This feature was introduced in Oracle 10g.
Solution
Set the following parameter in the listener.ora:
SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener_name>=OFF
Where <listener_name> should be replaced with the actual listener name configured in the
LISTENER.ORA file.
SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener_name> parameter is to be placed by itself on an empty line.
It will be necessary to restart or reload the listener following the addition of this parameter.
This will prevent the messages from being written to the log file and may also prevent the TNS
Listener from hanging periodically. See NOTE 340091.1 Intermittent TNS Listener Hang, New Child Listener Process Forked
Please Note: Setting SUBSCRIBE_FOR_NODE_DOWN_<listener_name> to OFF disables a necessary RAC functionality. The above workaround is recommended only for non-RAC environments.
The issue may be present in all 10g and newer installations.
Note: The use of this undocumented parameter may cause problems with the use of the Net Manager (NetMgr) configuration utility. See Note 437598.1 NetMGR May Error When Listener.ora File Contains:SUBSCRIBE_FOR_NODE_DOWN_EVENT
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识(上)
· 浏览器原生「磁吸」效果!Anchor Positioning 锚点定位神器解析
· 没有源码,如何修改代码逻辑?
· 分享4款.NET开源、免费、实用的商城系统
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了