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

Last updated on AUGUST 25, 2017

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

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