RE: ERROR:ORA-12500: TNS: listener failed to start dedicated

Hi,

I had the same problem last month with an Oracle 7 database in a Sun Solaris 2.6 server.
In this case the problem was that I had not enought space for swap memory.

This is another case:

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.

And this may be the solution

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.

Good luck

Mariana.

-----Mensaje original-----
De: James Howerton [mailto:jhowerton_at_uabmc.edu] Enviado el: Viernes 16 de Junio de 2000 17:29 Para: Multiple recipients of list ORACLE-L Asunto: ERROR:ORA-12500: TNS: listener failed to start dedicated

DBA's

I'm trying to set up Personal Oracle 8i on one of my co-worker's PC so he can train/play with Oracle. It appeared to load ok, the LISTENER is up, I can connect with svrmgrl and sqlplus from a DOS window. When I try to execute SQL*PLUS from the icon I get ERROR:ORA-12500: TNS: listener failed to start dedicated server process. I ran through all of the suggestions on METALINK. Any advise???
Windows 98 V-2
Personal Oracle 8i
128mb ram

TIA         ...JIM...
MS Illiterate DBA
Long live UNIX

-- 
Author: James Howerton
  INET: jhowerton_at_uabmc.edu

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).