11.2 : ORA-12518 Listener Hangs and Reports "Too Many Open Files"
(Doc ID 1527483.1)
Last updated on JANUARY 17, 2025
Applies to:
Oracle Net Services - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]Oracle Database - Enterprise Edition - Version 19.24.0.0.0 and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
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! |