Intermittent TNS Listener Hang, New Child Listener Process Forked [ID 340091.1]
In this Document
Description
Likelihood of Occurrence
Possible Symptoms
Workaround or Resolution
Patches
Modification History
References
Applies to:
Oracle Net Services - Version: 10.1.0.3.0 to 10.2.0.2.0 - Release: 10.1 to 10.2Information in this document applies to any platform.
All new connections via TNS listener hang, no errors reported
Checked for relevance on 05-FEB-2010.
Description
Intermittently the TNS listener hangs and new connections to the database are not possible.
Likelihood of Occurrence
The issue is that the TNS listener can hang under load if a second spawned listener process is not closed (remains persistent). Secondary listener processes are not unusual, depending on traffic as well as when the OS grep snapshot is taken. However, a persistent secondary process (longer than say 5 second) is not normal and may be a result of this referenced problem.
TNS listener can hang at any time and effect standalone or RAC systems
Possible Symptoms
Listener process can also consume high amount of CPU
Child TNS listener process is seen when doing a ps on the listener process, eg.:
ora10g 8909 1 0 Sep 15 ? 902:44 /u05/10GHOME/DBHOME/bin/tnslsnr sales -inherit
ora10g 22685 8909 0 14:19:23 ? 0:00 /u05/10GHOME/DBHOME/bin/tnslsnr sales -inherit
Killing the child process allows new connections to work until the problem reoccurs
Workaround or Resolution
Issue is fixed in 10.2.0.3 Patch Set
Oracle Support recommends patching to 10.2.0.5 as this the lastest release
- OR -
Apply Patch 4518443 for the problem (if a patch is available)
- OR -
As a workaround, two steps should be done:
1. The following parameter can be added to listener.ora
Where
For example, if the listener name is LISTENER (default), the parameter would be:
2. Locate the ons.config file in the 10g(rdbms) home and rename it to something else.
For example:
cd $ORACLE_HOME/opmn/conf
mv ons.config ons.config.orig
The listener needs to be restarted after these changes.
This will both prevent the listener from registering against ONS (Oracle Notification Services), which is the area affected by bug:4518443, as well as disable ONS itself. For more information on ONS, please refer to the specific Oracle documentation, for example, for 10.2, see the Oracle10g Release 2 Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide.
Please note, that adding the SUBSCRIBE_FOR_NODE_DOWN_EVENT_
Also, please note that this might happen with ANY 10g installation, whether it is RAC related or not, and whether there is an Oracle Application installation or not.
Patches
Apply Patch 4518443 for the problem (if a patch is available)Modification History
References
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-744640/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- TNS Listener Hang, New Child Listener Process Forked
- ORA-12500: TNS:listener failed to start a dedicated server processAIServer
- ORA-12500 TNS : listener failed to start a dedicated server processAIServer
- Listener refused the connection with the following error:ORA-12514, TNS:listenerError
- TNS-12541: TNS:no listener錯誤處理
- ORA-12528: TNS:listener: all appropriate instances are blocking new connectionsAPPBloC
- new Child();new Child(1);
- TNS-12518: TNS:listener could not hand off client connectionclient
- TNS-12518 TNS listener could not hand off client connectionclient
- 關於local_listener、remote_listener、current_listenerREM
- remote_listener和listener passwordREM
- grid control Error in getting data for creating new listenerError
- Oracle Database Server 'TNS Listener'遠端資料投毒漏洞OracleDatabaseServer
- Connecting to ASM through the TNS Listener from a Client DesktopASMclient
- ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach) (轉)ErrorServer
- remote_listener和local_listenerREM
- local_listener ,remote_listener 的配置REM
- 狀態: 失敗 -測試失敗: Listener refused the connection with the following error: ORA-12505, TNS:listener doesError
- Listener & FilterFilter
- Oracle ListenerOracle
- listener start fail TNS-12555 利用trace找到問題AI
- local_listener與remote_listener詳述REM
- ORA-12518: TNS:listener could not hand off client connectionclient
- ORA - 12502 TNS:listener received no CONNECT_DATA from clientclient
- ORA-12518, TNS:listener could not hand off client connectionclient
- JavaWeb-ListenerJavaWeb
- Filter&ListenerFilter
- An error from listenerError
- Unable to preventDefault inside passive event listenerIDE
- local_listener 與 remote_listener 引數說明REM
- 記一次解決:TNS-12518: TNS:listener could not hand off client connectionclient
- 【LISTENER】Oracle監聽TNS-12545及TNS-00515錯誤處理一例Oracle
- TNS-12518: TNS:listener could not hand off client connection For ORACLE 10G (AIX6.1)clientOracle 10gAI
- DB2 listenerDB2
- How to Run and View a Listener Trace. [ID 147446.1]View
- listener_scan1.log、listener.log監聽日誌清理
- LOCAL_LISTENER 和 REMOTE_LISTENER說明 ——轉自chinaunixREM
- oracle_sid與netmgr listener的sidOracle