Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ORA-12500 error

ORA-12500 error

From: Gary Fox <GaryF_at_VertexSystems.com>
Date: Wed, 24 May 2000 10:59:06 -0700
Message-Id: <10507.106563@fatcity.com>


Hi,
Get ORA-12500 "TNS:listener failed to start a dedicated server process" trying to connect
I'm using 8.1.5 on NT
I can connect locally to my 8.1.5 database using svrmgrl and exp, but not with us/pw_at_orcl. Connect a/b works, connect a/b_at_orcl gives ORA-12500.

It was working fine the past year until I recently shutdown and started the database.

I checked possible problems found in Metalink notes, all with no success: I stopped all extra programs (Web Server, discoverer...) to clear up resources
I changed init.ora to have the instance use less memory I increased processes in init.ora
There are no warnings in NT Event Viewer Doesn't matter if I start the listener with either NT services or lsnrctl NT listener service is running as system - no change

Is this fixable through SQL*Net or the database? My next thought is to uninstall and reinstall SQL*Net. Might that help?

Gary Fox
Vertex Systems, Inc.
310-571-2222
garyf_at_vertexsystems.com
www.vertexsystems.com Received on Wed May 24 2000 - 12:59:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US