With help of OEM cloud control, we can apply 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 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
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
What is your OMS database version?
It is 12.1.0.2
Nice post, But I am using OEM 13C and trying to patch a database version 12.2.0.1.0 and it’s giving me an error while creating plan is “It renders the plan as non-deployable.: Expected Database patching is not supported via conventional patch plan based methodology from 12.2.0.0.0. Alternately, Fleet Management is recommended to be used…………”
So I want to ask is it possible to patch 12.2.0.1.0 database with OEM 13C or not ?