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/