监听僵死

很久以前的：

 

故障：
用户反映无法连接到数据库；但检查数据库状态之类的都是好的，小型机不报错，应用服务器也没问题（不知道应用的错误日志是什么，估计是和无法连接数据库有关。）

检查数据库，没有出现任何alert日志。
查看监听日志，发现有段时间没有写入日志，只出现了
WARNING: Subscription for node down event still pending

检查WARNING: Subscription for node down event still pending的metalink日志。发现有以下内容。

10G LSNR: 'Warning: Subscription For Node Down Event Still Pending' In Listener Log [ID 372959.1]  

--------------------------------------------------------------------------------
 
  修改时间 03-JUN-2009     类型 PROBLEM     状态 PUBLISHED  

In this Document
  Symptoms
  Changes
  Cause
  Solution
  References

 

--------------------------------------------------------------------------------

 

Applies to:
Oracle Net Services - Version: 10.1.0.2.0 to 11.1.0.7.0
This problem can occur on any platform.
Checked for relevance on 08-JAN-2009.
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_=OFF

Where should be replaced with the actual listener name configured in the
LISTENER.ORA file.

SUBSCRIBE_FOR_NODE_DOWN_EVENT_ parameter is to be placed by istelf 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_ 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.

 

该bug可能导致监听僵死，而且会出现一个子进程。

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

转载于:http://blog.itpub.net/288166/viewspace-705059/