Today we will cover where, why and how to download OPatch utility and how to upgrade the current version of the Utility to latest one. It’s a easy task and same procedure is followed from 10g ( I have worked only from 10g hence I am confirming from 10g. If you have done this same way from 9i or 8 do let me know in comment section.)
If you are interested in how to downgrade non cdb database from 19c to 11g You can check this link.
Table of Contents
Frequently Asked Questions
From where we can download Latest OPatch Utility
Answer You can use following link to open download the latest OPatch Utility
https://updates.oracle.com/download/6880880.html
How to download OPatch Utility
Once you open the link –> you will have two drop down menu to chose from.
1. Select a Release
2. Platform
Once you chose appropriate options – Click on download button.
Here for example – I chose OPatch 19.0.0.0.0 as release and AIX as Platform. And clicked Download.
Why to download Latest OPatch Utility
Oracle always recommend to use latest OPatch utility while applying the patches. Along with that it’s always recommended to keep OPatch utility same across all the nodes while patching RAC environment.
When you are applying a Patch it comes with an ReadMe.html which suggest you minimum version of OPatch utility. Hence there is always a need of Upgradation of OPatch Utility whenever you are applying patches regularly. Each company has a compliance team which make sure all the security patches related to all the application used in their company are updated on regular basis.
Step by Step – How to upgrade OPatch utility
- Upload the file which you have downloaded on your local system on your database server.
- Make a separate directory, move the file and unzip it.
oracledbworld]$cd oracledbworld]$mkdir PATCHES oracledbworld]$mv /tmp/p6880880_190000_AIX64-5L.zip ~/PATCHES oracledbworld]$cd ~/PATCHES oracledbworld]$unzip p6880880_190000_AIX64-5L.zip oracledbworld]$ls OPatch
3. Go to ORACLE_HOME and mv your exiting OPatch utility.
oracledbworld]$cd $ORACLE_HOME oracledbworld]$mv OPatch OPatch_backup_21072021
4. Finally move the latest OPatch to ORACLE_HOME
oracledbworld]$cd ~/PATCHES oracledbworld]$mv OPatch $ORACLE_HOME
5. Finally check the version of OPatch Utility
oracledbworld]$export PATH=$PATH:$ORACLE_HOME/OPatch oracledbworld]$opatch version
Done!
Reference – How To Download And Install The Latest OPatch(6880880) Version (Doc ID 274526.1)