listener.log中报Warning: Subscription For Node Down Event Still Pending问题的解决方法-优快云博客

针对Oracle10.2.0.1forAIX环境下监听日志出现大量“Warning:SubscriptionForNodeDownEventStillPending”警告的问题，本文介绍了这一已知Bug及其解决方法。建议升级到10.2.0.3或更高版本，或者通过修改listener.ora文件和重命名ons.config文件来规避此问题。

一套Oracle 10.2.0.1 for aix的数据库环境，在监听日志（$ORACLE_HOME/network/log/listener.log）中报出大量的“Warning: Subscription For Node Down Event Still Pending"提示。

metalink上查询(doc id:340091.1)中，确认这个一个bug。

影响的版本为：

Oracle Net Services - Version: 10.1.0.3.0 to 10.2.0.2.0
在oracle 10.2.0.3中已经解决

文档中给出如下的解决方案

[@more@]Issue is fixed in 10.2.0.3 Patch Set
Oracle Support recommends patching to 10.2.0.4 as this the lastest release

- OR -

Apply Patch 4518443 for the problem (if a patch is available)

- OR -

As a workaround, two steps should be done:

1. The following parameter can be added to listener.ora

SUBSCRIBE_FOR_NODE_DOWN_EVENT_=OFF

Where should be replaced with the actual listener name configured in the LISTENER.ORA file. This parameter is to be placed by itself on an empty line / at the end of file.

For example, if the listener name is LISTENER (default), the parameter would be:

SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF

2. Locate the ons.config file in the 10g(rdbms) home and rename it to something else.
For example:

cd $ORACLE_HOME/opmn/conf
mv ons.config ons.config.orig

The listener needs to be restarted after these changes.

--end--

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22049049/viewspace-1029960/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22049049/viewspace-1029960/