Re: Database autostart after reboot (10g issue)

Christophe Bonte wrote:
> Hi
>
> I have Oracle 8i, 9i and 10g installed on several Windows computers.
>
> When I reboot the server the oracle databases startup automatically.
I
> specified that in the oradim command. But I have one issue with 10g.
I
> checked the registry. Everything looks good there.
>
> For 8i and 9i the database is OPEN, but for 10g, the database is
> started, however in NOMOUNT mode. I can't figure out how to start the
> 10g DB in OPEN mode after the server did a reboot. Right now i do it
> manually in SQL-plus.
>
> Any ideas? What has changed for 10g for that particular
functionality.
> I don't understand why the 10g doesn't behave like 8i and 9i. Thanks
> in advance
>
> Christophe

I have 10g database on my laptop (XP but should be same on NT/2K) and opens up automatically on reboot if I want to. Here is my configuration,

1. Regisrty flag ORA_<SID>_AUTOSTART is set to TRUE
2. Database Service logon is LocalSystem and is set to Automatic
3. Sqlnet.ora has SQLNET.AUTHENTICATION_SERVICES = (NTS)
4. Administrator is part of the ORA_DBA group

You can have a Domain user in steps 2 and 4 but make sure he is also part of the local Administrator group. Oracle service needs to start up the database without password and the above configuration needs to be in place to do it. This is like logging in as sqlplus "/ as sysdba". Regards
/Rauf Received on Mon Jan 10 2005 - 11:48:20 CST