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

On Jan 31, 10:40 am, kennymcet..._at_googlemail.com wrote:
> Hi,
>
> I've just tried to re-install Oracle 9.2.0.1.0 on my dev server. I
> uninstalled Oracle, then went through the normal install process, and
> patched it to 9.2.0.7. During the main install, Oracle was unable to
> install 'Cluster Queries' (due to a media failure, I presume), but the
> rest of the install seemed to go OK. The main install finished with an
> "Installation Unsuccessful" message, but I presumed this was because
> of the "Cluster Queries" problem.
>
> Here's the error stack from listener.log when I try to connect:
>
> 31-JAN-2007 09:25:21 * (CONNECT_DATA=(SERVICE_NAME=ORADEV2)
> (CID=(PROGRAM=D:\oracle\ora92\bin\sqlplus.exe)(HOST=BGL-DEV2)
> (USER=kmce4272))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.100.92)
> (PORT=1488)) * establish * ORADEV2 * 12500
> TNS-12500: TNS:listener failed to start a dedicated server process
> TNS-12560: TNS:protocol adapter error
> TNS-00530: Protocol adapter error
> 32-bit Windows Error: 126: Unknown error
>
> Can anyone advise?
>
> Thanks in advance,
>
> Kenny McEwan.

Did you check the status of the database? Is it running? Can you (in a DOS box) connect using
set oracle_sid = <yoursid>
sqlplus /nolog
connect / as sysdba

One of the main reasons for TNS-12500 is the database is down.

--
Sybrand Bakker
Senior Oracle DBA