[ORACLE]리스너 프로세스 2개 기동(Intermittent TNS listener hang, new child listener process forked.) [출처] 리스너 프로세스 2개 기동(Intermittent TNS listener hang, new child listener process forked.)

퍼온글입니다.

원문 : http://blog.naver.com/anova91/50013053785

Subject:	Intermittent TNS listener hang, new child listener process forked.
	Doc ID:	Note:340091.1	Type:	PROBLEM
	Last Revision Date:	11-JAN-2007	Status:	PUBLISHED

In this Document
  Symptoms
  Cause
  Solution
  References

---

Applies to:

Oracle Net Services - Version: 10.1.0.2.0 to 10.2.0.3.0
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_<listener_name>=OFF

Where <listener_name> 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_<listener_name> 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

'INTERMITTENTLY'   'RAC'   'NOTIFICATION~SERVICES'   'HIGH~CPU~USAGE'   'LISTENER~HANGS'   'HANGING'   'TNSLSNR'  

---

Help us improve our service. Please email us your comments for this document. .

[출처] 리스너 프로세스 2개 기동(Intermittent TNS listener hang, new child listener process forked.)|작성자 오토맨