Re: Service don't start db

From: Jesper Wolf Jespersen <ingen_at_dut.dat>
Date: Fri, 29 Dec 2006 01:27:48 +0100
Message-ID: <45946108$0$2094$edfadb0f@dtext02.news.tele.dk>

Hi.

> I have 10.2.0.1 on Windows 2003.
> The service don't start the database.
> The registry is correct
> I tried with pfile, spfile
> default location OH\database
> other location (oradim)
> but no success ...
>
> Any ideas ?
>
> Thanks in advance

Can you start the database via sqlplus ?

If yes then the problem might be that the service has not been configured to start the database instance.
With the utility oradim you can instruct the service to do different things on startup, the startupmode parameter controls this behaviour.

I dont have the documentatioin handy but quoting from memory i would say that a command like:

oradim -edit -sid orcl -startmode auto

Might do the trick. If the instance name is not orcl then just feed the right name instead.

Pleas look in the oradim documentation here is a link: http://download-west.oracle.com/docs/cd/B19306_01/win.102/b14304/create.htm#i1006533

Hope this helps you out.

Greetings from Denmark
Jesper Wolf Jespersen Received on Thu Dec 28 2006 - 18:27:48 CST