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

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

anymore for anymore? I'm struggling here!

thanks,
Kenny. Received on Wed Jan 31 2007 - 08:44:26 CST