My Oracle Support Banner

ORA-12519 With Shared Server and Dispatcher (Doc ID 565462.1)

Last updated on NOVEMBER 21, 2019

Applies to:

Oracle Net Services - Version 9.2.0.1.0 to 11.1.0.7.0 [Release 9.2 to 11.1]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

When configuring Shared Server (formerly, MultiThreaded Server or MTS), you set the correct Shared Server parameters such as the examples below:
dispatchers = (PROTOCOL=TCP)(DISPATCHERS=5)
shared_servers = 10
max_dispatchers = 10
max_shared_servers = 20

However, when you try to connect with a Shared Server process from the client or locally, you get the following message displayed:

TNS-12519: TNS:no appropriate service handler found

The listener log will display this error.


Also, if you run "lsnrctl services" on the listener, you might only see dedicated connections as follows:
LSNRCTL> services LISTENER_TEST
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhostname)(PORT=1522)))
Services Summary...
Service "orcl10" has 1 instance(s).
   Instance "orcl10", status UNKNOWN, has 1 handler(s) for this service...
      Handler(s):
         "DEDICATED" established:0 refused:0
            LOCAL SERVER
The command completed successfully


Changes

You are not running a default listener address (or port).

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.