It is sometime desirable by most DBAs to have the oracle database and listener automatically shutdown and startup when the server reboots. The following steps shows you how to automate your database and listener shutdown and startup. Please note that this demonstration is linux centric (I am working on OEL 6.8), so if you are working with a different Unix platform, refer to the Oracle Database Admin’s Guide. 1. Edit the /etc/oratab file, and place a Y at the end of the entry for the database you want to restart automatically when the system reboots. You will need root priv to edit the file: 2. Paste within the file a line similar to the one below, for your environment: db11g:/u01/app/oracle/product/11.2.0/dbhome_1:Y Note: The entries are of the form: # $ORACLE_SID:$ORACLE_HOME:N|Y: 3. As root, navigate to the /etc/init.d directory, and create a file named dbora: Paste the following lines in the dbora file. Make sure you...
Practical tips for smarter database work