Download Required Security Patch from oracle support
Copy zip file to server and unzip the patch as below example
It will create a directory with patch number.
Then Read README.txt file thoroughly follow the steps given in the readme file..
First of all If the patch is online patch-able then we need to decide whether to apply
online or offline.
Here I am giving example for online patching and patch is 17258083
From the patch directory where we unzipped the patch
Suppose If I unzipped patch in /u01/patches directory then
cd /u01/patches/17258083/
Determine whether any currently installed interim patches conflict with this patch 17258083
as shown below
Ensure that you maintain adequate memory on your system to apply this online patch
Formula to calculate required memory is
Memory Consumed = (Number of Oracle Processes + 1) X (Size of Patched .pch File)
in my example
Memory Comsumed=(150+1)*(122554)=17MB
my one instance max process is 150
then apply patch
opatch apply online -connectString <SID>:<USERNAME>:<PASSWORD>:
for RAC environment
opatch apply online -connectString <SID_Node1>:<Username_Node1>:<Password_Node1>:<Node1_Name>,<SID_Node2>:<Username_Node2>:<Password_Node2>:<Node2_Name>
opatch apply online -connectString TESTDB1:sys:sys123:Node1,TESTDB2:sys:sys123:Node2
If in readme.txt file If mentioned to run catbundle.sql then run it ..
@?/rdbms/admin/catbundle.sql cpu apply
Then You Can check in the registry$history view that patch is loaded into database or not..
To apply this same patch for other sid s
To Rollback Installed Patch