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

On 31 Jan, 09:56, "sybrandb" <sybra..._at_gmail.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

Hi Sybrand,

When I do this, I get ORA-12560: TNS:protocol adapter error.

Thanks,
Kenny. Received on Wed Jan 31 2007 - 04:09:26 CST