Hi Tinkster, below is my start and stop script, thanks bser regards
#!/bin/bash
#
# Oracle 10g2 This shell script takes care of starting and stopping
# Oracle 10g2.
#
# chkconfig: 345 95 00
# description: Oracle 10g2 service listner and database
#
# processname
racledb
# config: /etc/oratab
# Source function library.
. /etc/rc.d/init.d/functions
# Source networking configuration.
. /etc/sysconfig/network
export ORACLE_BASE="/home/app/oracle"
export ORACLE_HOME="/home/app/oracle/product/10.2.0"
export ORACLE_HOME_LISTNER=${ORACLE_HOME}
export ORA_OWNR="oracle10g2"
RETVAL=0
prog="Oracle10g2"
start() {
# Start Oracle process.
[ -f $ORACLE_HOME/bin/lsnrctl ] || exit 4
[ -f $ORACLE_HOME/bin/dbstart ] || exit 4
site="Listner"
echo -n $"Starting $site for $prog: "
su - $ORA_OWNR -c "$ORACLE_HOME/bin/lsnrctl start"
site="db"
echo -n $"Starting $prog "
su - $ORA_OWNR -c "$ORACLE_HOME/bin/dbstart"
RETVAL=$?
[ $RETVAL -eq 0 ] && touch /var/lock/subsys/$prog
echo
return $RETVAL
}
stop() {
# Stoping Oracle process.
[ -f $ORACLE_HOME/bin/lsnrctl ] || exit 4
[ -f $ORACLE_HOME/bin/dbshut ] || exit 4
site="Listner"
echo -n $"Stoping $site for $prog: "
su - $ORA_OWNR -c "$ORACLE_HOME/bin/lsnrctl stop"
site="db"
echo -n $"Stoping $prog "
su - $ORA_OWNR -c "$ORACLE_HOME/bin/dbshut"
RETVAL=$?
[ $RETVAL -eq 0 ] && rm -f /var/lock/subsys/$prog
echo
return $RETVAL
}
# See how we were called.
case "$1" in
start)
start
;;
stop)
stop
;;
restart|reload)
stop
start
RETVAL=$?
;;
asarestart)
if [ -f /var/lock/subsys/$prog ]; then
stop
start
RETVAL=$?
fi
;;
status)
status $prog
RETVAL=$?
;;
*)
echo $"Usage: $0 {start|stop|restart|asarestart|status}"
exit 2
esac
exit $RETVAL