WARNING: Subscription for node down event still pending

来源：互联网发布：魔乐科技java课堂笔记编辑：程序博客网时间：2024/06/05 02:11

环境：rhel 5.3 oracle 11.2.0.1 单实例ASM

在$oracle_home/diag/tnslsnr/szmlserver12_32/listener/trace/listener.log 中发现大量的WARNING：

Wed Jul 18 12:28:03 2012
WARNING: Subscription for node down event still pending
18-JUL-2012 12:28:03 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=szmlserver12_32.xxx.com)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0
Wed Jul 18 12:29:03 2012
WARNING: Subscription for node down event still pending
18-JUL-2012 12:29:03 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=szmlserver12_32.xxx.com)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0
Wed Jul 18 12:29:17 2012
WARNING: Subscription for node down event still pending
18-JUL-2012 12:29:17 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=szmlserver12_32.xxx.com)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0

有规律的每分钟产生一条信息，查询相关资料：

See the following MOS document :’Warning: Subscription For Node Down Event Still Pending’ In Listener Log [ID 372959.1]

“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. “

This recommendation was news to me, so this is why I put in a blog post because someone else will come across the same problem…the fix is to add to the listener.ora

SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener_name>=OFF

and then reload or restart the listener. Using the Reload command in lsnrctl will be less disruptive than restarting.

所以根据以上信息在$ORACLE_HOME/network/admin/listener.ora中添加以下信息：

SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF

重新载入监听配置即可不出现警告，但依然会每分钟出现一条日志信息

$lsnrctl reload