Hi,
I have Oracle database enterprise edition 9.2.0.4 running on RedHat
Linux ES release 4. Although the installation went fine and after the
installation I was able to see the common processes like ora_pmon
started in system, but when I reboot system the database does not
comeup.

I am using dbstart command via a /etc/init.d/oracle file. This is
linked to /etc/rc5.d and /etc/rc3.d as well in the Linux server.

The amazing thing is that tnslistener is started automatically after
system reboot but not database. That is, when I check the status of
that via the command "lsnrctl status" it shows me the one database
instance that I am hoping to see correctly. But no ora_pmon etc
processes are there.

Even interesting thing is that when I manually run the command
"/etc/init.d/oracle start" by hand, it does start the database
perfectly fine. This is the same command that I am running via the
startup scripts in /etc/rc5.d and othe runlevels.

Please help me finding out why is the database not starting up
automatically? I have checked the
/u02/app/oracle/product/9.2.0/startup.log which just says reports that
Listener has started but after that it does not show anything about
database starting up.

Below I am pasting the chunk of /etc/init.d/oracle script that is
supposed to start the listener and database. Please have a look at it
and tell me what can I be doing wrong in this case?

 ########################################
#########
ORACLE=oracle1
export ORACLE_HOME PATH
#

LOG=$ORACLE_HOME/startup.log
touch $LOG
chmod a+r $LOG
#

case $1 in
'start')
echo "$0: starting up" >> $LOG
date >> $LOG

# Start Oracle Net
if [ -f $ORACLE_HOME/bin/tnslsnr ] ; then
echo "starting Oracle Net listener"
su - oracle1 -c "$ORACLE_HOME/bin/lsnrctl start" >> $LOG 2>&1 &
fi
echo "starting Oracle databases"
su - oracle1 -c "$ORACLE_HOME/bin/dbstart" >> $LOG 2>&1
;;
 ########################################
################

Thanks in advance for your urgent help.

--Smb

[ Post a follow-up to this message ]

Thanks for your reply Jan, actually I have already set the value of
$ORACLE_HOME to the correct value as per my installation, sorry that
line was cut when I last time pasted the chunk of my /etc/init.d/oracle
file because I only wanted to paste the relevant portion of that file.

But here is the complete /etc/init.d/oracle file that I have below,
please suggest what might be wrong?

thanks.
 ########################################
##################
#!/bin/sh
#
# chkconfig: 235 99 01
# description: controls Oracle database startup and shutdown

ORACLE_HOME=/u02/app/oracle/product/9.2.0
PATH=${PATH}:$ORACLE_HOME/bin
HOST=`hostname`

ORACLE=oracle1
export ORACLE_HOME PATH
#

LOG=$ORACLE_HOME/startup.log
touch $LOG
chmod a+r $LOG
#

case $1 in
'start')
echo "$0: starting up" >> $LOG
date >> $LOG

# Start Oracle Net
if [ -f $ORACLE_HOME/bin/tnslsnr ] ; then
echo "Shahid starting Oracle Net listener"
su - oracle1 -c "$ORACLE_HOME/bin/lsnrctl start" >> $LOG 2>&1 &
fi
echo "Shahid starting Oracle databases"
su - oracle1 -c "$ORACLE_HOME/bin/dbstart" >> $LOG 2>&1
;;

'stop')
echo "$0: shutting down" >> $LOG
date >> $LOG

# Stop Oracle Net
if [ -f $ORACLE_HOME/bin/tnslsnr ] ; then
echo "stopping Oracle Net listener"
su - oracle1 -c "$ORACLE_HOME/bin/lsnrctl stop" >> $LOG 2>&1
fi
echo "stopping Oracle databases"
su - oracle1 -c "$ORACLE_HOME/bin/dbshut" >> $LOG 2>&1
;;

*)
echo "usage: $0 {start|stop}"
exit
;;
esac
#
exit
 ########################################
################

[ Post a follow-up to this message ]