11201監聽BUG處理

skuary發表於2014-03-04
    開發那邊最近反饋一些訊息說程式連線資料庫的時候經常會間歇性的出現間斷或者連線不上的情況,檢視產品庫的監聽日誌發現,短時間內出現很多的告警資訊:

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

相關文章