Re: Oracle TNS error

In article <8qtg49$gjds5$1_at_ID-45409.news.cis.dfn.de>,   "Sudip Chakraborty" <sudip_at_inductis.com> 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.
>

Grabbing from the Oracle8i Error Messages Release 2 (8.1.6) document... though I'm not sure this is terribly helpful.

ORA-12500 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 re-execute 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. Check that the correct Protocol Adapter are successfully linked. If the error persists, contact Oracle Customer Support.

Assuming that TNS starts a server process for each connection, which I believe to be the case, my gut tells me that you're maxing out the number of processes your server can support. Do you see this failure most often when the server is getting the most traffic?

Justin Cave
Oracle ODBC Development

Opinions expressed herein are my own and may not reflect those of Oracle Corporation.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Sep 27 2000 - 18:29:36 CDT