• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oracle Database » How to check opatch version , apply patch, Upgrade

How to check opatch version , apply patch, Upgrade

July 10, 2022 by techgoeasy Leave a Comment

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
  • How to upgrade opatch version
  • How to apply the patch using opatch
  • How to run Opatch conflict
  • how to check if a patch is applied in oracle database

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>

Filed Under: Oracle, Oracle Database

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • srvctl commands
  • how to check db size in oracle
  • How to access oracle cloud compute instance(Linux/Window)
  • size of schema in oracle
  • Pagination in Oracle

Copyright © 2022 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us