Shared Server: "ORA-12523: TNS:listener could not find instance appropriate for the client"
Shared Server: "ORA-12523: TNS:listener could not find instance appropriate for the client"
Titleimage
Posted by Patrick Hamou on 2016:04:20 01:45:00
Applies to
Oracle Server - Enterprise Edition - Version: 10.2.0.1 and later [Release: 10.2 and later ]
Information in this document applies to any platform.
Symptoms
When trying to connect the Oracle RDBMS Instance using Shared Server, the following error message may occur:
ERROR:
ORA-12523: TNS:listener could not find instance appropriate for the client connection
Changes
Setting up Shared Server
Cause
Check for your init.ora shared server settings. One possible solution to this error is that the "service_names" parameter is incorrect or missing.
Solution
Add into init.ora the "service_names" parameter.
Example:
dispatchers="(protocol=tcp)"
local_listener="(address=(protocol=TCP)(host=lnx18.it.oracle.com)(port=13132))"
service_names=EMB121W3.lnx18
Posted by Patrick Hamou on 2016:04:20 01:45:00