Re: Oracle startup failure on win2000

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 7 Feb 2003 17:06:51 -0000
Message-ID: <3e43e7a7$0$4016$ed9e5944@reading.news.pipex.net>

"Ofergal" <member24517_at_dbforums.com> wrote in message news:2497297.1044633703_at_dbforums.com...
>
> Go to the Oracle bin directory and use oradim.exe to drop and
> then recreate
> the Oracle service.
>
> For instructions on how to use this command line utility type
> oradim at the
> DOS prompt.
>
> First you will:
> oradim -delete -sid
>
> Then you will:
> oradim -new -sid ....
>
> > Daniel Morgan
> -------------------------------------------------
> You would lose all the data like this, right?

Wrong.

>
> Any Idea what is wrong if the service starts but the DB does not?
> (8.1.7)

oradim.log will give you some clues as indeed might the alert log. I can't see the beginning of the thread but at least one possibility is that the instance is set to manual startup. ie it was created with oradim -new -sid <sid> -startmode m

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Fri Feb 07 2003 - 11:06:51 CST