ORATAB - automatic start of oracle

[gajananpkini]

How do I get Oracle to automatically start when my server boots up?

I have added this entry in oratab file , but still it is not getting started whenever the server boots up. do i need to change in any other file or do i am missing something.

# $ORACLE_SID:$ORACLE_HOME:[N|Y]
#
ORCL:/u01/app/oracle/product/8.1.7:Y

thanks in advance
Gajanan

[davey23uk]

you dont mention os, ill guess solaris.

You do have entries in /etc/rcX.d pointing to ORACLE_HOME/bin/dbstart dont you?

I am guessing you dont

[gajananpkini]

The OS is linux Red Hat advance server

[SANJAY_G]

1. Update /etc/oratab as

SID:ORACLE_HOME:Y

2. Create the script /etc/init.d/dbora as...

 #!/bin/bash

#

# chkconfig: 35 99 10

# description: Starts and stops Oracle processes

#

# Set ORA_HOME to be equivalent to the $ORACLE_HOME

# from which you wish to execute dbstart and dbshut;

#

# Set ORA_OWNER to the user id of the owner of the

# Oracle database in ORA_HOME.

#

ORA_HOME=

ORA_OWNER=

case "$1" in

'start')

# Start the Oracle databases:

# The following command assumes that the oracle login

# will not prompt the user for any values

su - $ORA_OWNER -c $ORA_HOME/bin/dbstart

# Start the TNS Listener

su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start"

# Start the Intelligent Agent

if [ -f $ORA_HOME/bin/agentctl ]; then

su - $ORA_OWNER -c "$ORA_HOME/bin/agentctl start"

else

su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl dbsnmp_start"

fi

# Start Management Server

if [ -f $ORA_HOME/bin/oemctl ]; then

su - $ORA_OWNER -c "$ORA_HOME/bin/oemctl start oms"

fi

# Start HTTP Server

if [ -f $ORA_HOME/Apache/Apache/bin/apachectl ]; then

su - $ORA_OWNER -c "$ORA_HOME/Apache/Apache/bin/apachectl start"

fi

touch /var/lock/subsys/dbora

;;

'stop')

# Stop HTTP Server

if [ -f $ORA_HOME/Apache/Apache/bin/apachectl ]; then

su - $ORA_OWNER -c "$ORA_HOME/Apache/Apache/bin/apachectl stop"

fi

# Stop Management Server

if [ -f $ORA_HOME/bin/oemctl ]; then

su - $ORA_OWNER -c "$ORA_HOME/bin/oemctl stop oms sysman/"

fi

# Stop the Intelligent Agent

if [ -f $ORA_HOME/bin/agentctl ]; then

su - $ORA_OWNER -c "$ORA_HOME/bin/agentctl stop"

else

su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl dbsnmp_stop"

fi

# Stop the TNS Listener

su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop"

# Stop the Oracle databases:

# The following command assumes that the oracle login

# will not prompt the user for any values

su - $ORA_OWNER -c $ORA_HOME/bin/dbshut

rm -f /var/lock/subsys/dbora

;;

esac

# End of script dbora

3. Set permission to 755 for /etc/ini.d/dbora

4. Register the Service

/sbin/chkconfig --add dbora

[davey23uk]

i suggest changing dbshut to be shutdown immediate as well, it is currently just shutdown up to 9iR2