Oracle start up script issue with RHEL3 Cluster

[Yong Huang]

Lingu,

Can you check whether the script /etc/init.d/script_db.sh is called at all? After failover, see if the file last access time was about the failover time or much earlier (ls -ltu). Or add some lines like

/usr/bin/date > /tmp/mylog
/usr/bin/env | /usr/bin/sort >> /tmp/mylog

to that script. If that script is called, how about startdb.sh? If that's called too, check Oracle's alert_<DBSID>.log under Oracle's bdump directory.

Yong Huang

> I am running two node active/passive cluster on RHEL3U8-64 bit
> operating system for my oracle 9i  database.I am facing issue when
> cluster fail over to node 2 my oracle start up script not starting up
> even though i configured start up script in my cluster configuration
> but if i type clustat on node 2  it shows service is started. If i
> shift the service manually from node 2 to node 1 or even if rebooted
> the node1  my cluster starting up the same  service  properly on node
> 1.Any one help me to fix out this issue.Below  is my script.
> 
> Cluster Version: clumanager-1.2.31-1.x86_64
> 
> Note: If i start the same script manually on the node 2 it is starting
> the database properly without any error.
> 
> /etc/init.d/script_db.sh
> #####################################################################################
> #!/bin/bash
> . /etc/rc.d/init.d/functions
> 
> start() {
>       echo "Starting Database"
> 
>       su -l oracle -c "sh startdb.sh"
>       ## Sleep for 2 Minuts ####
> 
> #       sleep 120
> #       echo " reStarting app"
> #        clusvcadm -R application
> #        echo " app restarted"
> 
>       RETVAL=$?
>       return $RETVAL
> }
> 
> 
> stop()  {
>       echo "Stopping  Database"
> 
>       su -l oracle -c "sh stopdb.sh"
> 
>       RETVAL=$?
>       return $RETVAL
> }
> 
> status() {
> #DBUP=`ps -ef | grep oracle | grep -v grep | grep -c ora_pmon `
> DBUP=`ps -ef | grep -c ora_pmon `
> #LSNRUP=`ps -ef | grep oracle | grep 9.2.0  | grep -v grep | grep -c lsnrctl`
> LSNRUP=`ps -ef | grep -c lsnrctl`
> if [ ${DBUP} -ge 1 ]
> then
>       if [ ${LSNRUP} -ge 1 ]
>       then
>               echo "Database Running"
>               return 0
>       fi
> fi
> echo "Database  Not Running"
> return 1
> }
> 
> 
> case "$1" in
>       start)
>               start
>               echo "Start Database complete"
>               ;;
> 
>       stop)
>               stop
>               echo "Database Stopped"
>               ;;
>       restart)
>                stop
>                start
>                ;;
>       status)
>               status
>               ;;
> 
>       *)
> 
>       echo $" Not Applicable"
>       exit 1
> 
> esac
> echo "exiting script"
> exit $RETVAL
> ###################################################################################
> stopdb.sh
> 
> /home/oracle/orahome/bin/sqlplus /nolog<<EOF
> connect sys/sysxyzcall at xyzcall as sysdba
> shutdown immediate;
> host lsnrctl stop
> quit;
> EOF
> exit
> ######################################################################################
> startdb.sh
> #######################################################################
> /home/oracle/orahome/bin/sqlplus /nolog <<EOF
> host lsnrctl stop
> host lsnrctl start
> connect sys/sysxyzcall at xyzcall as sysdba
> startup
> quit;
> EOF
> exit
> ############################################################################
> 
> Regards,
> Lingu