Friday, 28 October 2011

Automating Oracle DB startup in Linux

I am writing steps that will auto start Oracle Database along with linux OS startup.

1. connect with Oracle user and edit the "/etc/oratab" file setting flag to 'Y'. soni:/home/oracle/oracle/product/10.2.0/db_1:Y
2. connect wih root user- created empty file (/etc/init.d/dbora) and write:






























3. chmod 750 /etc/init.d/dbora
4. chkconfig --add dbora
5 check whether dbora is working or not.. as root issue /etc/init.d/dbora start
# /etc/init.d/dbora start
Failed to auto-start Oracle Net Listene using /ade/vikrkuma_new/oracle/bin/tnslsnr
Processing Database instance "soni": log file /home/oracle/oracle/product/10.2.0/db_1/startup.log

We got any error in listner settings... This is due to a hard coded path in the dbstart script. To correct this, connect with Oracle user, edit the "$ORACLE_HOME/bin/dbstart" script and replace the following line (approximately line 78): ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracle withORACLE_HOME_LISTNER=$ORACLE_HOME and then check
# /etc/init.d/dbora start
Processing Database instance "soni": log file /home/oracle/oracle/product/10.2.0/db_1/startup.log
---------------
Congratz you are DONE