WARNING: Subscription for node down event still pending

标题：WARNING: Subscription for node down event still pending

监听日志中出现很多”WARNING: Subscription for node down event still pending”警告

--监听日志中内容
……
26-NOV-2012 09:35:48 * ping * 0
WARNING: Subscription for node down event still pending
……
26-NOV-2012 09:45:49 * ping * 0
WARNING: Subscription for node down event still pending
……
--监听日志大小
$ ls -l /oracle/product/10g/network/log/listener.log
-rw-r-----    1 oracle   dba       229526148 Nov 26 14:20 /oracle/product/10g/network/log/listener.log
--总计条数
$ grep "Subscription for node down event still pending" \
> /oracle/product/10g/network/log/listener.log|wc -l
   77306

数据库版本和平台

SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE    10.2.0.5.0      Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.5.0 - Productio
NLSRTL Version 10.2.0.5.0 - Production

监听日志配置

$ more /oracle/product/10g/network/admin/listener.ora
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /oracle/product/10g)
      (PROGRAM = extproc)
    )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xifenfei)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )

解决方法

--监听文件中增加
SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener_name>=OFF
--reload监听
lsnrctl reload

补充说明

SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener_name>=OFF will prevent the messages
from being written to the log file and may also prevent the TNS Listener from hanging periodically.
Setting SUBSCRIBE_FOR_NODE_DOWN_<listener_name> to OFF disables
a necessary RAC functionality(Oracle Notification Service[ONS],fast application notification[FAN]).
The above workaround is recommended only for non-RAC environments.
The issue may be present in all 10g and newer installations.

具体参考:372959.1和340091.1

One thought on “WARNING: Subscription for node down event still pending”

Applies to:
Oracle Net Services - Version 10.1.0.2.0 to 11.2.0.0 [Release 10.1 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 29-Aug-2012
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_&lt;listener_name&gt;=OFF
Where &lt;listener_name&gt; should be replaced with the actual listener name configured in the
LISTENER.ORA file.
SUBSCRIBE_FOR_NODE_DOWN_EVENT_&lt;listener_name&gt; 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
Please Note: Setting SUBSCRIBE_FOR_NODE_DOWN_&lt;listener_name&gt; 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.

博主你好，请问id 号的错误在所有的非rac oracle版本上都会遇到吗？什么情况下才能产生监听僵死，我遇到这个错误后，就没有办法模拟出来

alex,
数据库版本在Version 10.1.0.2.0 to 11.2.0.0中都有可能出现该问题
至于怎么模拟，我不太清楚

WARNING: Subscription for node down event still pending

One thought on “WARNING: Subscription for node down event still pending”

发表评论 取消回复

发表评论取消回复