ServiceGuard and Oracle

[Anthony Arindaeng]

Hi,
I'm pretty new to MC/ServiceGuard and I just inherited an existing 2-node cluster running in HP-UX 11.00. The setup is using MC/ServiceGuard A.11.09 and also have the SG-Oracle-Tool B.01.01. The current cluster configuration doesn't include Oracle 8.0.6 to start when the package is brought up. I was told that DBA doesn't want (or I may say doesn't trust) the cluster to start the Oracle. They want to manually check the Oracle DB first then manually bring it up. We finally convinced them to use the cluster to automatically switch and bring it up. During weekends, the DBAs have a maintenance job that shuts down the oracle instance and perform a replication of the dbf file to our Disaster site using the native OS rcp command, then brings it up again. Now the problem I forsee is whenever the Oracle is shutdown by this maintenance job, the cluster will try to bring it up on the second node (?). Is there any cluster command (cm*) wherein I can just shutdown the oracle db, retain the application floating IP address (the maintenance job is running using this IP addr), and also have the Volume Group still activated the FS mounted without triggering a switch to second node? What are the sequence of cluster commands I can use to achieve this?

[Geoff Wild · Accepted solution]

You will have to craete a "maintenance" flag option. Something like:

In your "monitor" section:

while true
do
if [ -f /tmp/maint_flag ]
then sleep 30
#
# DO NOT CHECK IF APP IS RUNNING
#
else
if app_running
then sleep 30
else exit
fi
fi
done


Rgds...Geoff

[Tania Ap. Serpa Martins]

I use the flag to indicate for MC/SG that the application will not be check from that moment.

Then You can put in the job (script) before the command for shutdown the DB Oracle to create the file with "touch " command and use the script described above to check if the file exists. After the maintenance job you need to remove the file for MC/SG start checking if the application is running. You should put the command to remove the file in the same job (script).

Tania

[Anthony Arindaeng]

Thanks to both of you. I'm now trying to build the script and test it. Since we don't have a similar environment in our UAT, I have to test the script in production. Hope this works.