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"

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

Return to Blog