How to Automate Startup/Shutdown of Oracle Database on Linux

There are already good sample scripts for automating database startup and shutdown (i.e. check Tim Hall’s oracle-base.com or read MOS [ID 222813.1]), but I wanted to create a wizard to generate “dbora” script according to your inputs. So here it is:

http://apex.oracle.com/pls/apex/f?p=22258:1

This script uses dbstart/dbshut scripts of Oracle. If dbstart/dbshut scripts return the error: “Test: Argument Expected”, you should replace the value #!/bin/sh with the value #!/bin/bash in the first line of dbstart/dbshut files (MOS [ID 369923.1]).

I have also create a wizard to generate shell profile files:

http://apex.oracle.com/pls/apex/f?p=22258:2

I hope you find them useful. Feel free to post your feedback and suggestions here.

Please share
  •  
  •  
  •  
  •  
  •  
  •  

AWS Big Data Specialist. Oracle Certified Professional (OCP) for EBS R12, Oracle 10g and 11g. Co-author of "Expert Oracle Enterprise Manager 12c" book published by Apress. Awarded as Oracle ACE (in 2011) and Oracle ACE Director (in 2016) for the continuous contributions to the Oracle users community. Founding member, and vice president of Turkish Oracle User Group (TROUG). Presented at various international conferences including Oracle Open World.

Leave Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.