My Oracle Support Banner

Troubleshooting Guide for TNS-12518 TNS listener could not hand off client connection (Doc ID 550859.1)

Last updated on JULY 26, 2023

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2 to 12.2]
Oracle Net Services - Version to [Release 10.1 to 12.2]
Information in this document applies to any platform.


This article discusses  how to troubleshoot the ORA-12518/TNS-12518 listener errors.

Troubleshooting Steps

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
Troubleshooting Steps
 Section I: Steps to approach ORA-12518/TNS-12518 Error:
 Section II: Commonly Known Errors:
 Error: 32: Broken pipe
 Error: 11: Resource temporarily unavailable
 Error: Connection Pooling limit reached
 Error: 24: Too many open files
 Section III: Errors Specific to Windows
 Error: 2: No such file or directory 
 Error: 233: Unknown error
 Error: 54: Unknown error
 Error: 10022: Unknown error

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.