一套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 |