11.2 : ORA-12518 Listener Hangs and Reports "Too Many Open Files" (Doc ID 1527483.1)

Last updated on MAY 01, 2017

Applies to:

Oracle Net Services - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 1-MAY-2017***

Symptoms

In a RAC environment VIP listener report:
    WARNING: Subscription for node down event still pending
in listener.log even so ONS service is running:

 crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
...............

ora.ons
               ONLINE  ONLINE       rorac1
               ONLINE  ONLINE       rorac2

These WARNINGS appear every minute or so, showing that the listener cannot connect to ONS server.

Additionally incoming connections start to fail and the following messages would be reported in the listener.log:

 

 

The number of sockets opened by listener process is increasing in time.

Listener is leaking sockets and these file descriptors will increase in number exhausting the server resource.

Changes

No changes to the system.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms