ORA-12520 Error

[Raul Tuset]

Installed 9i Database as shared server and 9i Developer Suite on my XP Pro
computer.

I can login to database via SQL*Plus and the Repository Administration
Utility, but not OEM.

I get this error when I try to connect with OEM.

ORA-12520: TNS:listener could not find available handler for requested type
of server

Any ideas?

Raul

[Turkbear]

"Raul Tuset" <rtuset@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.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------