Re: auto-starting Oracle on NT?

Mohamad Nazri Shuib wrote:
>
> In article <30D9EF83.40B9_at_mind.net>, Bruce Robertson <brucer_at_mind.net> says:
> >
> >We would like to free up our DBA at night when the power
> >bounces and our NT server restarts. She's complaining that
> >dialing in to start the database is stupid. Is there a way
> >to configure Oracle to start up by itself?
>
> There are bulletins that you look through in the Oracle Home Page
> (www.oracle.com) under the heading: Installation Assistance.
>
> Briefly, this is how it goes:
>
> 1. Go into the Services Control Panel and make sure that Oracle services
> are automaticcally started.
> 2. Create a batch file called 'STARTUP.BAT' in the ORANT\RDBMSXX
> directory containing the following:
>
> ORASRV sidname -ORA -START
> ORASRV sidname -NMP -START
> ORASRV sidname -TCP -START
>
> 3. Create a file called 'STARTUP.SQL' in the ORANT\RDBMSXX directory
> containing the following:
>
> CONNECT INTERNAL/password
> STARTUP
> EXIT
>
> 4. Run the registry editor REGEDT32 and go down the following tree:
> HKEY_LOCAL_MACHINE -> SOFTWARE -> MICROSOFT -> WINDOWSNT -> CURRENT
> VERSION -> WINLOGON
> Edit the System entry and add a line that executes the STARTUP.BAT
> e.g. C:\ORANT\RDBMSXX\STARTUP.BAT
>
> There are variations of the steps and commang depending on SQL*Net
> version etc. Refer to Appendix G of the Oracle 7.1 Installation and
> User Guide for more details or the Oracle Home Page as mentioned above
>
> Hope this helps.

I use this method too in a production environment. It works well and seems to be very clean. I would suggest that when you create these batch files you use basic DOS redirection to capture the output of each of the command line calls. This way if Oracle bails when comming up you can see what hapened. Even though you cannot redirect stderr, you get a lot of info this way.

• good luck!