ORA-12519 With Shared Server and Dispatcher
(Doc ID 565462.1)
Last updated on NOVEMBER 21, 2019
Applies to:Oracle Net Services - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 9.2 to 11.1]
Information in this document applies to any platform.
This problem can occur on any platform.
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)))
Service "orcl10" has 1 instance(s).
Instance "orcl10", status UNKNOWN, has 1 handler(s) for this service...
"DEDICATED" established:0 refused:0
The command completed successfully
You are not running a default listener address (or port).
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