Being a Core DBA we have deep knowledge about patching.On the internet we have lots of knowledge is available about patching.This patching is different from the normal one. In this article, we are going to have look on steps which use to Apply Database Patch From OEM Cloud Control. With help of OEM cloud control, we can apply the patch on multiple databases easily. No need to download the patch and copy that to the database server, OEM will download the patch if require and do the rest of patching activities.
Below are the steps for applying the patch using OEM Cloud Control.
ENTERPRISE – > PATCHES & UPDATES -> RECOMMENDED PATCH
Select the respective platform and database.
Select the Patch which you are planning to apply
Create the patch plan:
Give a new to the PATCH PLAN:
Select the database targets. You can select multiple databases at a time.
This is screen is very important.
There are two types of patching mode.
– Out of place – In this option, A new Oracle binary will be created and the patch will be applied on top of that. And database will started from the new Oracle home. This is recommended method, because, it reduced DB downtime and also during patching to binary if some issue happens, then also the old ORACLE_HOME is intact.
– In place – Here the database and listeners running from that home will be shut down , Then patch will be applied to that ORACLE_HOME, once done database will be started with post patch.
Here I have selected In place.
Set the ORACLE_HOME credentials, If not then use override and set the database server host username and password.
Now run the validation, to check the conflicts. This validation shouldn’t show any errors.
Now the validation is successful, Now go for DEPLOYMENT.
With this patching has been completed. Now you can log in to the database and check the patch registry.
SQL> SET LINES 200 SQL> select patch_Id,status,description from dba_registry_sqlpatch; PATCH_ID STATUS DESCRIPTION ---------- --------------- ------------------------------------------------------------------------------------------------- 24917972 SUCCESS Database PSU 12.1.0.2.170117, Oracle JavaVM Component (JAN2017) 24732082 SUCCESS DATABASE PATCH SET UPDATE 12.1.0.2.170117
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez
Anuradha’s LinkedIn: https://www.linkedin.com/in/dbaanuradhamudgal/
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
Thank you for this detailed post.
Cheers,
Foued
You are welcome.
Cheers,
S G
Thanks Skant, this document is very much helful and well explained