Re: ORA-12520 Error
Date: Thu, 09 Dec 2004 12:49:22 -0600
Message-ID: <ke7hr0h22j37mp6buookgbf6g32rfn0f9e_at_4ax.com>
"Raul Tuset" <rtuset_at_nc.rr.com> wrote:
>ORA-12520:
From the docs ( a good place to find stuff, try it):
ORA-12520: TNS:listener could not find available handler for requested type of server
Cause: The type of service handler requested by the client is incorrect or not registered for the requested SERVICE_NAME/INSTANCE_NAME, or the database instance is not registered with the listener.
Action: If you suspect the problem is the wrong type of service handler, perform these steps:
If (server=value) is set is in the connect descriptor, ensure that the value is set to the appropriate service handler type for the database, that is, dedicated for dedicated server or shared for dispatchers. You can use the Listener Control utility SERVICES command to see what service handlers are currently registered with the listener.
If USE_DEDICATED_SERVER is set to ON in the sqlnet.ora file, then ensure the database is configured to use dedicated servers. If it is not, set this parameter to off. Ensure that the database instance is running. If the instance not running, start it so that it can register with the listener.
Received on Thu Dec 09 2004 - 19:49:22 CET