Re: Oracle instance does not start automatically

To look at the obvious, you can read Howard's comments in his post.

> You should add to the ORA_DBA group any user who you wish to be able to
> perform database administrative actions. That can be a local user, or a
> domain user.... Oracle works fine with both (though some tweaking is
> necessary on the client-side if you want to administer the database
> remotely).

To add to the above post, there is registry entry at HKLM\SOFTWARE\ORACLE\HOME[x]\[ORA_<DB_SID>_AUTOSTART] which gets created when you create new database service using oradim -new option. This entry is set to "FALSE" by default (as of patchset 8.1.7.3). If this entry is set to "FALSE", then Oracle service will only start the Oracle process and *not* mount and open the database...which would have to be done from server manager afterwards. To let your service start Oracle process and mount/open your database in one go, change above registry value to "TRUE". This maybe another reason.

HTH
//Rauf Sarwar Received on Sun Aug 11 2002 - 14:23:35 CDT