10gR2 Tips on RHEL4/Centos
edit dbstart
ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracle
to
ORACLE_HOME_LISTNER=$ORACLE_HOME
oracle startup script
![[WWW]](/wiki/rightsidebarsmaller/img/moin-www.png){kind=small}
http://www.orafaq.com/faqunix.htm#STARTUP
/etc/oratab will have to be edited to indicate that ASM and the databases are going to be started automatically by putting a Y in the last field:
/etc/oratab
+ASM:/u01/app/oracle/oracle/product/10.2.0/db_1:Y test:/u01/app/oracle/oracle/product/10.2.0/db_1:Y
oracleasm's startup script contains
chkconfig: 2345 29 20
oracle needs to start after asm and shutdown before asm
/etc/init.d/oracle
#!/bin/sh
#
# Purpose: a script to start oracle
#
# chkconfig: 345 90 15
# description: oracle is the oracle database
export ORACLE_HOME=/u01/app/oracle/oracle/product/10.2.0/db_1
export ORA_OWNER=oracle
if [ ! -f $ORACLE_HOME/bin/dbstart ]
then
echo "Oracle startup: cannot start"
exit
fi
case "$1" in
'start') # Start the Oracle databases and Net listener
su - $ORA_OWNER -c "$ORACLE_HOME/bin/dbstart"
su - $ORA_OWNER -c "$ORACLE_HOME/bin/lsnrctl start"
;;
'stop') # Stop the Oracle databases and Net listener
su - $ORA_OWNER -c "$ORACLE_HOME/bin/lsnrctl stop"
su - $ORA_OWNER -c "$ORACLE_HOME/bin/dbshut"
;;
'restart')
cd $CWD
$0 stop
$0 start
;;
*)
echo "Usage: oracle {start|stop|abort|restart}"
exit 1
;;
esac