|
Home > Archive > Red Hat Topics > August 2006 > Oracle database not starting up after reboot on RedHat ES4 Linux !
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Oracle database not starting up after reboot on RedHat ES4 Linux !
|
|
| shahid.bhatti@gmail.com 2006-08-11, 1:13 am |
| 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
| |
| shahid.bhatti@gmail.com 2006-08-11, 7:13 pm |
| 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
########################################
################
|
|
|
|
|