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上查到的資訊如下:
該bug可能會出現在所有的10g版本和11.2.0.0版本上,具體原因上面紅色部分說的已經很明確了,方法就是在listener.ora檔案中新增引數,來遮蔽這個警告,當然也會防止監聽間歇性夯住的現象,不過有一點要注意的是,官方只建議在非rac環境下新增該引數,rac環境會禁掉一些必須的功能(待後續仔細查證)。
記錄一下~~
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 監聽異常處理Oracle
- Java GUI之事件監聽與處理JavaGUI事件
- Android的事件處理——監聽介面方式Android事件
- Netty事件監聽和處理(上)【有福利】Netty事件
- Netty事件監聽和處理(下)【有福利】Netty事件
- oracle監聽器日誌過大-處理辦法Oracle
- Netty中自定義事件處理程式和監聽器Netty事件
- 處理生產bug
- 處理rac資料庫一個節點監聽異常資料庫
- start_udev導致監聽自動停止問題處理dev
- oracle crs監聽狀態為offline處理過程Oracle
- oracle listener 監聽啟動不起來處理案例一則Oracle
- 資料庫監聽不定期出現異常故障處理資料庫
- 啟動監聽報TNS-01150錯誤處理
- Java GUI之事件監聽與處理的匿名類實現方法JavaGUI事件
- 一次oracle rac 監聽不定時offline處理過程Oracle
- bug及異常處理1
- [BI專案記]-BUG處理
- 批處理LOG_NDEBUG
- spring boot 實現監聽器、過濾器、全域性異常處理Spring Boot過濾器
- linux平臺,監聽日誌大於1G,處理指令碼Linux指令碼
- 【監聽】手工配置tnsnames.ora檔案注意事項——謹慎處理空格
- oracle rac 其中第一個節點監聽偶爾中斷處理案例Oracle
- 監聽 watch props物件屬性監聽 或深度監聽物件
- html5+的plus 監聽掃描槍廣播 處理掃描結果HTML
- mysqlconnect bug 處理一例。MySql
- 動態監聽與靜態監聽
- 動態監聽和靜態監聽
- JS監聽手機物理返回鍵(及IOS微信端的bug)JSiOS
- 一次Oracle監聽無法動態註冊處理過程排查分析Oracle
- 記筆記:C# Socket客戶端監聽伺服器端處理方案【同步】筆記C#客戶端伺服器
- 網路問題導致10g CRS監聽服務offline 處理
- Oracle10g RAC 兩個監聽狀態為offline 問題處理Oracle
- java springboot監聽事件和處理事件JavaSpring Boot事件
- 【監聽】兩庫互配靜態監聽
- ORACLE動態監聽與靜態監聽Oracle
- oracle靜態監聽和動態監聽Oracle
- 【oracle】動態監聽與靜態監聽Oracle