listener.log中報Warning: Subscription For Node Down Event Still Pending問題的解決方法

cnhtm發表於2009-12-25

一套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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章