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

On Jan 31, 11:09 am, kennymcet..._at_googlemail.com wrote:
> 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.- Hide quoted text -
>
> - Show quoted text -

Hi Kenny,

Time to check

- whether OracleService<SID> is running
- oradim.log in %ORACLE_HOME%\database
- alert_<SID>.log

12560 will occur because Oracle tries the default SID ORCL if the designated database is not available.

--
Sybrand Bakker
Senior Oracle DBA