Re: Oracle TNS error

From: <sambavan_at_motown.cc.utexas.edu>
Date: Wed, 27 Sep 2000 15:21:06 -0500
Message-ID: <Pine.GSO.4.21.0009271515100.28488-100000@grapevine.cc.utexas.edu>

here is the explanation for ORA-12500

12500, 00000, "TNS:listener failed to start a dedicated server process"

// *Cause:  The process of starting up a dedicated server process failed.
// The executable could not be found or the environment may be set up
// incorrectly.
// *Action: Turn on tracing at the ADMIN level and reexecute the

operation.

// Verify that the ORACLE Server executable is present and has execute
// 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.
// If error persists, contact Oracle Customer Support.

One possibility is that you might not have a dedicated service set on oracle listener and you are trying to make a shared service name to a dedicated one. Suggestion would be ask your DBA about the dedicated listener service name and put it in your tnsnames.ora file on the client side and try executing your script. On the other hand if you are using odbc (don't know much about) then use the dedicated service name to connect to your database.

Good luck
Sam

On Wed, 27 Sep 2000, Sudip Chakraborty wrote:

> Hi,
>
> I am running with Oracle 8i Standard Edition and periodically come up with
> this error message when my application tries to open a connection.
>
> SQL state:S1000Error Code:12500Message:[Oracle][ODBC][Ora]ORA-12500:
> TNS:listener failed to start a dedicated server process
>
> I am able to login using sqlplus but cannot use DBA Studio.
>
> I tried looking up the error code on the Oracle Technet website but they
> only have numbers from ORA-12400 to ORA-12495 and then from ORA-12700 to
> ORA-18010.
>
> Any ideas on how I can resolve this will be greatly appreciated.
> Thanks.
> Sudip
>
>
>
>
  Received on Wed Sep 27 2000 - 15:21:06 CDT