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 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

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.

 



 

Changes

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

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!


In this Document
Symptoms
Changes
Cause
Solution


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