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.
