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

patch1

Select the respective platform and database.

patch2

Select the Patch which you are planning to apply

patch3
Create the patch plan:

patch4

Give a new to the PATCH PLAN:

patch5

 

Select the database targets. You can select multiple databases at a time.

 

patch6

 

 

 

patch7 patch8
patch9jpg

patch10

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.

patch11

 

Set the ORACLE_HOME credentials , If not then use override and set the database server host username and password.
patch12 patch13

 

Now run the validation, to check the conflicts. This validation shouldn’t show any errors.
patch14 patch15 patch16 patch17

Now the validation is successful, Now go for DEPLOYMENT.

 

patch18 patch19 patch20 patch21 patch22 patch23 patch26

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