ORA-12500 TNS-12500 TNS:listener failed to start a dedicated server process

This error appears when the process of starting up a dedicated server process failed and it could be either because the executable could not be found or the environment isn’t set up correctly.

Turn on tracing at the ADMIN level and re-execute the operation. Tracing can be set by adding following clause in listener.ora file and restarting the listener:-

TRACE_LEVEL_listener=admin

Verify that the ORACLE Server executable ($ORACLE_HOME/bin/oracle) is present and has execute (6751) permissions enabled. Ensure that the ORACLE environment is specified correctly in LISTENER.ORA. The Oracle Protocol Adapter that is being called may not be installed on the local hard drive. Please check that the correct Protocol Adapter are successfully linked.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.