My Oracle Support Banner

11gR2 Grid Infrastructure Listener Goes Offline as it Has Huge Number of Socket Open (Doc ID 1482498.1)

Last updated on MARCH 05, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

11gR2 Grid Infrastructure, listener goes offline intermittently:

 

ps -ef |grep tnslsnr
oracle    9239     1  0 Oct08 ?        00:00:12  /ocw/grid/bin/tnslsnr LISTENER -inherit

srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is not running

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12547: TNS:lost contact
 TNS-12560: TNS:protocol adapter error
  TNS-00517: Lost contact
   Linux Error: 32: Broken pipe
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<nodename1>.<domain>)(PORT=1521)))

TNS-12537: TNS:connection closed
 TNS-12560: TNS:protocol adapter error
  TNS-00507: Connection closed

 

TNS-12518: TNS:listener could not hand off client connection
 TNS-12560: TNS:protocol adapter error
  TNS-530: Protocol adapter error
   Linux Error: 24: Too many open files
..
..
WARNING: Subscription for node down event still pending

 

 

Changes

 

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
Changes
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.