Friday, 29 September 2017

Automating Database Startup and Shutdown on Windows server

To automate database startup and shutdown by using Oracle Administration Assistant for Windows:

1. From the Start menu, select All Programs, then select Oracle - HOMENAME,then select Configuration
    and Migration Tools, and then select Administration Assistant for Windows.
   
                        

2.    Right-click the SID.

3.    Select Startup/Shutdown Options.

                       

4.    Select the Oracle Instance tab.

5.    Select start up instance when service is started.

                  

                     
6.    Select the Oracle NT Service tab.

7.    Select Automatic in Oracle NT Service Startup Type.

                  

8.    Click Apply.

9.    Click OK.

Done. All set now, Oracle database will start automatically when system reboots on windows machine

No comments:

Post a Comment