Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Instances vs Services
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...Received on Thu Dec 06 2001 - 04:01:43 CST
>
> 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.
>