Shared Server: SQL*Plus Connection Fails with TNS-12518

(Doc ID 1638595.1)

Last updated on APRIL 04, 2014

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

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 hundreds of Community platforms