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

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

Hi Sybrand,
OracleService<SID> is running.
There's nothing in oradim.log since I reinstalled Oracle (only messages previous to that point). Same for alert_oradev2.log. The last message in there dates from just prior to my re-install.

Just for info, they are:
1) alert_oradev2.log:

Tue Jan 30 12:45:20 2007
Restarting dead background process QMN0
QMN0 started with pid=9

2) oradim.log:
Tue Jan 30 12:02:20 2007
ORA-12705: invalid or unknown NLS parameter value specified

The message in oradim.log is the reason I decided to re-install Oracle in the first place.

In any case, it seems as though the re-install didn't work out too well!

Many thanks for your help,
Kenny. Received on Wed Jan 31 2007 - 05:13:50 CST