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.

6 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

  3. shivani says:

    A befuddling web diary I visit this blog, it's incredibly grand. Strangely, in this present blog's substance made motivation behind fact and sensible. The substance of information is instructive
    Oracle Fusion Financials Online Training
    Oracle Fusion HCM Online Training
    Oracle Fusion SCM Online Training

  4. Anonymous says:

    Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.

    sem training in hyderabad
    seo training in hyderabad
    SMM Training In Hyderabad

  5. I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.

    oracle fusion functional training
    oracle integration cloud service online training

Powered by Blogger.

Page Views

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