Simplify Oracle critical patch updates using simple configurations
# MDinh : Nov 15, 2018 # SET VARIABLES FOR GI_PSU AND OJVM_PSU 11.2.0.4 # Modify Locations/OPatch Version/Patch Number #-------------------------------------------------------------------------------- # Patch 28429134 - Oracle Oracle Grid Infrastructure Patch Set Update 11.2.0.4.181016 # Patch Number Description Applicable Homes # 28204707 DB PSU 11.2.0.4.181016 Both DB Homes and Grid Home # 27735020 OCW PSU 11.2.0.4.181016 Both DB Homes and Grid Home # 28204939 ACFS PSU 11.2.0.4.181016 Only Grid Home # # Patch 28440700 - Oracle JavaVM Component 11.2.0.4.181016 Database PSU #-------------------------------------------------------------------------------- set +x export OPATCH_VER=11.2.0.3.6 export PATCH_TOP_DIR=/export/media/PSU/2018OCT export GI_PSU=$PATCH_TOP_DIR/GI/28429134 export DB_PSU=$GI_PSU/28204707 export OCW_PSU=$GI_PSU/27735020 export ACFS_PSU=$GI_PSU/28204939 export OJVM_PSU=$PATCH_TOP_DIR/OJVM/28440700 env|grep PSUHere is an example for Jul 2018 PSU. Note: other variables are there to accommodate manual patching vs opatch auto.
# MDinh : Nov 15, 2018 # SET VARIABLES FOR GI_PSU AND OJVM_PSU 11.2.0.4 # Modify Locations/OPatch Version/Patch Number #-------------------------------------------------------------------------------- # Patch 27967757 - Oracle Grid Infrastructure Patch Set Update 11.2.0.4.180717 (Includes Database PSU) # Patch Number Description Applicable Homes # 27734982 DB PSU 11.2.0.4.180717 Both DB Homes and Grid Home # 27441052 OCW PSU 11.2.0.4.180417 Both DB Homes and Grid Home # 27959254 ACFS PSU 11.2.0.4.180717 Only Grid Home # # Patch 27923163 - Oracle JavaVM Component 11.2.0.4.180717 Database PSU #-------------------------------------------------------------------------------- set +x export OPATCH_VER=11.2.0.3.6 export PATCH_TOP_DIR=/recovery_area/media/PSU/2018JUL export GI_PSU=$PATCH_TOP_DIR/GI/27967757 export OJVM_PSU=$PATCH_TOP_DIR/OJVM/27923163 export OCW_PSU=$GI_PSU/27441052 export ACFS_PSU=$GI_PSU/27959254 export DB_PSU=$GI_PSU/27734982 env|grep PSUTo patch GI PSU:
. /home/oracle/gi.env echo $GRID_HOME . /recovery_area/media/PSU/2018JUL/law_psu.env ls -ld $GI_PSU; ls -l /tmp/ocm.rsp $GRID_HOME/OPatch/opatch auto $GI_PSU -ocmrf /tmp/ocm.rspTo patch OJVM PSU:
. /home/oracle/db.env echo $ORACLE_HOME . /recovery_area/media/PSU/2018JUL/law_psu.env ls -ld $OJVM_PSU $ORACLE_HOME/OPatch/opatch apply $OJVM_PSUThe only difference between patching Oracle July 2018 for AIX and October 2018 Linux is the *psu.env to source.
. /export/media/PSU/2018OCT/pos_psu.env . /recovery_area/media/PSU/2018JUL/law_psu.envHopefully, this will make your patching simpler.
On this page
Share this
Share this
More resources
Learn more about Pythian by reading the following blogs and articles.
Recovering from quarterly PSU patching disaster
Recovering from quarterly PSU patching disaster
Nov 16, 2018 12:00:00 AM
2
min read
How to Apply a Standby-First PSU Patch in a 2 node RAC environment
How to Apply a Standby-First PSU Patch in a 2 node RAC environment
Dec 24, 2013 12:00:00 AM
18
min read
Automating Oracle Patching With an Ansible Module
Automating Oracle Patching With an Ansible Module
Jan 11, 2021 12:00:00 AM
7
min read
Ready to unlock value from your data?
With Pythian, you can accomplish your data transformation goals and more.