DBA GENESIS
Courses
Contact
Members
More
In oracle RAC, should we deploy patches to all nodes or we just deploy on any one node?
Hi Altaf,
You should apply patches to all instances in the cluster. You should do this at the same time.
You can use the following query to get a list of all patches applied to the system:
select patch_id, version, release_date, status from dba_registry;
You should check the version and release date columns to make sure that all patches are at the same level.
If you have multiple nodes in your RAC, you will need to apply the patches to each node individually.
Thanks, do we need down time of node while deploying patches?
No, you can patch one node at a time and the other nodes will continue to run.
Thanks
Hi Altaf,
You should apply patches to all instances in the cluster. You should do this at the same time.
You can use the following query to get a list of all patches applied to the system:
select patch_id, version, release_date, status from dba_registry;
You should check the version and release date columns to make sure that all patches are at the same level.
If you have multiple nodes in your RAC, you will need to apply the patches to each node individually.