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.

7 Responses so far.

  1. Anonymous says:

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

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

  3. Sravani 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.

    Oracle Fusion HCM Online Training

  4. sushma says:

    Hey Really Thanks for sharing the best information regarding category, hope you will write more great blogs.
    Oracle Fusion Financials Online Training

  5. Naga says:

    Very interesting blog, keep posting such an informative post.

    Oracle Fusion Financials Online Training

  6. Thank you for sharing such a nice and interesting blog and really very helpful article

    Oracle Fusion SCM Online Training

  7. Awesome postЕЕ. your article is really informative and helpful for me and other bloggers too

    oracle fusion financials online training

Powered by Blogger.

Page Views

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