同时发现有多个listener进程!!!

oracle版本为10.2.1

最近在linux和hp-ux(安腾)分别遇到过两次lisnter不响应的情况,当时的现象都是同一时间有多个listener进程在运行,把异常的进程杀掉了,listener就恢复正常了.

刚才查了下证实是oracle bug!Bug 4518443 is fixed in 10.2.0.3 !!

可以去下载相应平台的补丁!!!

Applies to: 
Oracle Net Services - Version: 10.1.0.2 to 10.2.0.2
This problem can occur on any platform.
All new connections via TNS listener hang, no errors reported 
Symptoms
Intermittently the TNS listener hangs and new connections to the database are not possible.
Listener process can also consume high amount of CPU 
Child TNS listener process is seen when doing a ps on the listener process, eg.:

$ ps -ef | grep tnslsnr
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 
Cause
This is a known problem addressed via non-published bug:4518443 (Abstract: Listener Gets Hung Up)
The issue is that the TNS listener can hang under load while spawning a process
Solution
Bug 4518443 is fixed in 10.2.0.3 
 - OR -
Apply Patch 4518443  for the problem (if a patch is available)
 - OR -
As a workaround, the following parameter can be added to listener.ora
SUBSCRIBE_FOR_NODE_DOWN_EVENT_=OFFWhere  should be replaced with the actual listener name configured in the LISTENER.ORA file.
For example, if the listener name is LISTENER (default), the parameter would be:
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF
This will prevent the listener from registering against ONS (Oracle Notification Services), which is the area affected by bug:4518443. For more information on ONS, please refer to eg. the Oracle10g Release 2 documentation ("Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide"). 

Please note, adding SUBSCRIBE_FOR_NODE_DOWN_EVENT_ to listener.ora file on RAC, will mean that FAN (fast application notification) will not be possible. See Note 220970.1 RAC: Frequently Asked Questions for further information on FAN

References
Keywords
'INTERMITTENT'   'LISTENER~HANGS'   'RAC'   'NOTIFICATION~SERVICES'   'HIGH~CPU~USAGE'   'TNSLSNR

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

转载于:http://blog.itpub.net/25702/viewspace-464281/