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 to [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 1-MAY-2017***


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

               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.


No changes to the system.


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