Maintenance of Oracle in an HP Service Guard cluster

.

If you will do some maintenance operation that needs db restart on an Oracle database which works inside a Service Guard cluster, you should make the following configurations. Normally if you shutdown the database in the active node, the package halts.

In /opt/cmcluster/toolkit/oracle directory you should set the MAINTENANCE_FLAG variable to "YES" in the configuraiton file (.conf) and restart the package.
After maintenance mode is enabled create a file named oracle.debug under the package directory (generally /etc/cmcluster/package_name)

#touch oracle.debug

After these steps you can manually stop/start Oracle and this doesn't cause the package to fail.
You can remove the oracle.debug file after the maintenance work is done.

1 comments:

Anonymous said...

Hi, many thanks for the information provided. Very appreciated! :D
Regards