DG监听日志中出现:WARNING: Subscription for node down event still pending

在DG的Primary DB 的监听日志中出现如下信息:


WARNING: Subscription for node down event still pending

metalink的解释如下:

Applies to:

Oracle Net Services - Version 10.1.0.2.0 to 11.2.0.0 [Release 10.1 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 29-Aug-2012
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 itself 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. 

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.  

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

转载于:http://blog.itpub.net/26867989/viewspace-761980/

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值