In this post, we will be discussing opatch , How to check the opatch version, apply the patch, and Upgrade
Table of Contents
How to check opatch version
we can check the opatch version using the below command
Log in to the Oracle Database server
Source the Oracle Home
$ORACLE_HOME/OPatch/opatch version
Oracle Interim Patch Installer version 12.2.0.1.29
Copyright (c) 2021, Oracle Corporation. All rights reserved.
How to upgrade opatch version
Looks out for the required version for patch 6880880
Download the patch to the server
Unzip the patch and directory OPatch will be there
Then follow the below command
cd $ORACLE_HOME
mv OPatch OPatch_bk
cp -pr <stage location>/OPatch $ORACLE_HOME
How to apply the patch using opatch
- Download the patch and Unzip the patch on the server
- Source the Oracle Home
- Now apply using the below command
cd <patch stage>/<patch no>
$ORACLE_HOME/OPatch/opatch apply
How to run Opatch conflict
- Download the patch and Unzip the patch on the server
- Source the Oracle Home
- Now apply using the below command
cd <patch stage>/<patch no>
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
how to check if a patch is applied in oracle database
We can check the patches using below command
$ORACLE_HOME/OPatch/opatch lspatches |grep <patch no>
Or
$ORACLE_HOME/OPatch/opatch lsinventory |grep <patch no>
Leave a Reply