My Oracle Support Banner

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

Last updated on FEBRUARY 15, 2019

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.

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

To view full details, 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 a vibrant support community of peers and Oracle experts.