My Oracle Support Banner

TNS Listener Hang Every 49.X Days (Doc ID 1357676.1)

Last updated on MARCH 31, 2019

Applies to:

Oracle Net Services - Version 10.2.0.4 to 11.2.0.1 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

TNS listener hangs every 49.7 days. Parameter RATE_LIMIT is set in the listener.ora file.
Level 16 listener trace for the hang shows the following functions:

[000001 17-MAY-2011 23:30:42:953] nstoSetupTimeout: entry
[000001 17-MAY-2011 23:30:42:953] nstoSetupTimeout: MTO enabled for ctx=0x1002bcaf0, val=-47967511(millisecs)
[000001 17-MAY-2011 23:30:42:953] nstoUpdateActive: entry
[000001 17-MAY-2011 23:30:42:953] nstoUpdateActive: Active timeout is 5 (see nstotyp)
[000001 17-MAY-2011 23:30:42:953] nstoControlMTO: MTO enabled for ctx=0x1002bcaf0, val=-47967511(millisecs)
[000001 17-MAY-2011 23:30:42:953] nstoControlMTO: exit (0)
[000001 17-MAY-2011 23:30:42:954] nsglhc: At Connection Rate Limit. Muted Request.
[000001 17-MAY-2011 23:30:42:954] nsglhe: exit
[000001 17-MAY-2011 23:30:42:954] nsevwait: entry
[000001 17-MAY-2011 23:30:42:954] nsevwait: 4 registered connection(s)
[000001 17-MAY-2011 23:30:42:954] nsevwait: 0 pre-posted event(s)
[000001 17-MAY-2011 23:30:42:954] nsevwait: waiting for transport event (1 thru 5)...


When the listener is hung, client reports error code ORA-12537

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.