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.

2 Responses so far.

  1. Anonymous says:

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

  2. It was great to see someone write on this topic. Thanks for sharing your thoughts
    Hp Gis Plotters

Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -