Re: Instances vs Services

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 6 Dec 2001 10:01:43 -0000
Message-ID: <3c0f420d$0$8508$ed9e5944@reading.news.pipex.net>

Try issuing

oradim -edit -sid <your sid> -startmode auto for auto start.
and
oradim -edit -sid <your sid> -shutmode i -shuttype srvc,inst for immediate shutdown at server shutdown.

also as always check the alert log.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************


"dsmcd" <dsmcd_at_uswestmail.net> wrote in message
news:6idP7.241$Ui5.401840_at_news.uswest.net...


>

> Already set this way, but still, just the service starts, the database

> instance does not. Any other ideas?

>

> Win2k-Server SP2

>

> D.

>

>

> >regedt32

> >HKEY_LOCAL_MACHINE\Software\Oracle\Home0\...

> >

> >set ORA_INSTANCENAME_AUTOSTART = TRUE

> >

> >replace INSTANCENAME with your SID.

>

Received on Thu Dec 06 2001 - 04:01:43 CST