Re: ORA-12500:TNS:Listener failed to start a dedicated server process

hello andy,

i assume you have an oracle 8.x environment. if yes then you need to be careful that you use the right utilities to make your entries into the file like tnsnames.ora and listener.ora. using SQL Net Easy sounds for oracle version 7 and so would write the entries into the file tnsnames etc. correctly bud under a different directory. as you write the failure message is about the listener process. did you configure a correct listener process and start it ? check with lsnrctl80 status from the DOS command box (if under OS NT, under UNIX just lsnrctl status) there are some more steps to check and to do, better you first check this.

best regards

burkhard schneider

Andy Geraerts schrieb:
>
> I'm attempting to make a connection with SQL Plus 8.0 / ODBC to my Oracle
> database. We're using SAP on Oracle. Since I only acccess Oracle through the
> SAP interface I've almost zero knowledge about Oracle. I've installed the
> Client software of Oracle and created an alias using SQL Net Easy
> configurator. I've tested it with TNSPING. This results positive...
> When I try to connect I always get the following error :
> ORA-12500:TNS:Listener failed to start a dedicated server process.
>
> Anyone an idea?
>
> Andy Geraerts
> Please mail at Andy.Geraerts @ sentinel.be
Received on Wed Sep 15 1999 - 16:26:52 CDT