Automating Oracle Database Startup

There is good solution derived , which i believe will make sense when you have scripts written but not taken a step forward to automate it.  I will explain this by my simplistic view and approach to automate oracle database on Linux environment in a scenario when  a server reboots itself or with a purpose.



To begin with I have couple of scripts writen to stop and start the database.

Please see below screen shots which conveys everything , but in case you have good idea or have any queries please send feedback as comments which will be appreciated.



 

      Add dbora to the services list to run on shutdown or startup.

 

Bounce the server, to test the database starts up automatically. There should be a log in the /home/oracle/startup_shutdown directory.

 

Optional – But Good Practice.

 Install the Oracle Diagnostic and Data Capture Tools:-

OSWATCHER – Only switched on if there are severe performance problems and we need to capture database and system statistics over a long period of time.

ORACHK – Used to health check the current database and cluster installation, this can be run to build a baseline for future comparisons. It is also gives recommendations where improvements can be made.

Remote Diagnostic Agent (RDA) . This generates a very detailed report on the configuration of the hardware and software, the results of this report are usually required by Oracle Support if a service request is ever raised with Oracle. Again it is worth running this report as a baseline for future changes.