Last updated on AUGUST 25, 2017
Applies to:Oracle Net Services - Version 18.104.22.168.0 to 22.214.171.124.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).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms