My Oracle Support Banner

Shared Server: SQL*Plus Connection Fails with TNS-12518 (Doc ID 1638595.1)

Last updated on MARCH 31, 2022

Applies to:

Oracle Net Services - Version and later
Information in this document applies to any platform.


Remote clients that attempt to connect via Shared Server fail with the following message:

TNS-12518: TNS:listener could not hand off client connection

The Lsnrctl Services output shows several DISPATCHERS. Most are configured to use TCP however one is configured to spawn using the TCPS (SSL) protocol.




 This is likely a new installation of the Oracle database or a new implementation of Shared server.


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

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