RE: ORA-12500 error

Hi Gary,
I faced similar problem. You correct it in the following way.

1. Check in the TNSNAMES.ora file ($ORACLE_HOME/network/admin).
2. Modify the name of your service as -- ORCL.WORLD (This is the culprit mostly. Your service handler may not be having the name appended as .WORLD).
3. In sqlnet.ora, change the default name as WORLD.

Now, issue the command -- sqlplus us/pwd_at_ORCL

It should work.

Maheshwara Rao, L., Teki
E Mail : teki01_at_mediaone.net

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Gary Fox Sent: Wednesday, May 24, 2000 3:02 PM
To: Multiple recipients of list ORACLE-L Subject: ORA-12500 error

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

--
Author: Gary Fox
  INET: GaryF_at_VertexSystems.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).