Sunday 29 October 2023

How to apply OJVM patch without down time of database in RAC


In RAC environment, we can do any patch without down time if we follow rolling method(node by node).

We dont required to bring down database for running datapatch, so no down time here as well.

But for OJVM patch, its required to run in upgrade mode, hence DB restart required which is a bad news for RAC environments.


But we have a workaround to run datapatch without putting database in upgrade mode, i.e using   -skip_upgrade_check


./datapatch -verbose -skip_upgrade_check

DBAs will face challenge to apply OJVM patch as it required to put database in upgrade mode to run datapatch.

This way DBA can apply all patches with Zero down time in RAC environments.


No comments:

Post a Comment