1. Update /etc/oratab as
Code:
SID:ORACLE_HOME:Y
2. Create the script /etc/init.d/dbora as...
Code:
 #!/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