OPATCH

How to apply JDK patch in oracle database

Recently we got a notification from security Team, that the java versions inside the ORACLE_HOME were outdated, and those need to be updated to the latest one. So We checked in  oracle support portal...

Useful OPATCH commands

1. list inventory details of patch. $ORACLE_HOME/OPatch/opatch lsinventory 2. list patchsets applied : $ORACLE_HOME/OPatch/opatch lspatches 3. Find opatch version: $ORACLE_HOME/OPatch/opatch version 4...

LsInventorySession failed: RawInventory gets null OracleHomeInfo

  PROBLEM:   While running opatch lsinventory , got below error LsInventorySession failed: RawInventory gets null OracleHomeInfo: oracle@dbhost1:…p/app/oraInventory/ContentsXML$ $ORACL...

How to install OPatch in ORACLE RAC

In this article I will explain how to install/upgrade OPatch utility in grid_home and oracle_home in a RAC infrastructure. Opatch utility is used while applying patches to the database. Every readme f...

ZOP-51: The patch location is not valid for apply

PROBLEM:   While applying patch to binary using opatch utility got below error. ZOP-51: The patch location is not valid for apply, because it doesn’t have correct metadata, or it points to...

Rollback database patch in oracle 12c

In this article , we will provide steps for rolling back a patch in non-rac standalone database. PATCH TO BE ROLLED BACK – 27105253 – Database Jan 2018 Release Update (DB RU) 12.2.0.1.1801...

Prerequisite check “CheckActiveFilesAndExecutables” failed

PROBLEM: While applying a patch to oracle binary using opatch utility, got below error. $ORACLE_HOME/OPatch/opatch apply Oracle Interim Patch Installer version 12.1.0.1.10 Copyright (c) 2017, Oracle C...