11201监听BUG处理

    开发那边最近反馈一些消息说程序连接数据库的时候经常会间歇性的出现间断或者连接不上的情况，查看产品库的监听日志发现，短时间内出现很多的告警信息：

04-MAR-2014 08:55:43 * ping * 0
WARNING: Subscription for node down event still pending
04-MAR-2014 08:55:43 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=test)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))(VERSION=186646784)) * status * 0
Tue Mar 04 08:56:06 2014
04-MAR-2014 08:56:06 * service_update * orcl * 0
04-MAR-2014 08:56:11 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=perl@test)(HOST=test)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.0.11)(PORT=36488)) * establish * orcl * 0
Tue Mar 04 08:56:36 2014
04-MAR-2014 08:56:36 * service_update * orcl * 0
Tue Mar 04 08:57:06 2014
04-MAR-2014 08:57:06 * service_update * orcl * 0
04-MAR-2014 08:57:09 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=orcl)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.0.11)(PORT=36518)) * establish * orcl * 0
04-MAR-2014 08:57:12 * service_update * orcl * 0
Tue Mar 04 08:57:42 2014
04-MAR-2014 08:57:42 * service_update * orcl * 0
Tue Mar 04 08:58:06 2014
04-MAR-2014 08:58:06 * service_update * orcl * 0
Tue Mar 04 08:58:42 2014
04-MAR-2014 08:58:42 * service_update * orcl * 0
04-MAR-2014 08:58:48 * service_update * orcl * 0
Tue Mar 04 08:59:06 2014
04-MAR-2014 08:59:06 * service_update * orcl * 0
Tue Mar 04 08:59:36 2014
04-MAR-2014 08:59:36 * service_update * orcl * 0
Tue Mar 04 09:00:06 2014
04-MAR-2014 09:00:06 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=perl@test)(HOST=test)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.0.11)(PORT=36609)) * establish * orcl * 0
04-MAR-2014 09:00:06 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=perl@test)(HOST=test)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.0.11)(PORT=36610)) * establish * orcl * 0
Tue Mar 04 09:00:44 2014
04-MAR-2014 09:00:44 * ping * 0
WARNING: Subscription for node down event still pending

我这边数据库版本如下：

oracle@test:~> sqlplus  / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 4 13:42:01 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show rel
release 1102000100

安装好后没打过什么补丁！

MOS上查到的信息如下：

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. 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可能会出现在所有的10g版本和11.2.0.0版本上，具体原因上面红色部分说的已经很明确了，方法就是在listener.ora文件中添加参数，来屏蔽这个警告，当然也会防止监听间歇性夯住的现象，不过有一点要注意的是，官方只建议在非rac环境下添加该参数，rac环境会禁掉一些必须的功能（待后续仔细查证）。

记录一下~~

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

转载于:http://blog.itpub.net/25618347/viewspace-1101008/