OBIEE 11G - Opatch

> Reporting and Data Access Tools

1 - About

You use the Oracle OPatch utility to apply (and to roll back) Oracle BI EE platform patches.

When OPatch processes the script for the installation of a patch, it :

  • generates a Rollback script
  • saves a copy of every file edited or deleted during the patching.
  • backs up the inventory information.

In one system, you can have several Oracle Home that have each their own patch system. Setting the good oracle home is critical.

export ORACLE_HOME=${FMW_HOME}/oracle_common
export ORACLE_HOME=${FMW_HOME}/Oracle_BI1

3 - Management

3.1 - Version

opatch version
OPatch Version:

OPatch succeeded.

3.2 - Applying a patch


opatch apply -help


export ORACLE_HOME=/path/to/theOracleHome
cd patchLocation
opatch apply -jre $ORACLE_HOME/jdk/jre

3.3 - Verifying that the patch is correctly installed

opatch lsinventory | grep PatchId
# Example
opatch lsinventory | grep 20188679

3.4 - Rollback

export ORACLE_HOME=myOracleHome
opatch rollback -id PatchId

3.5 - Determining Current Patch Levels (Inventory)

cd \MiddelwareHome\Oracle_BI_Home\OPatch
set ORACLE_HOME=E:\MiddelwareHome\Oracle_BI1
opatch lsinventory -patch -detail
Invoking OPatch

Oracle Interim Patch Installer version
Copyright (c) 2009, Oracle Corporation.  All rights reserved.

Oracle Home       : E:\MiddelwareHome\Oracle_BI1
Central Inventory : C:\Program Files\Oracle\Inventory
   from           : n/a
OPatch version    :
OUI version       :
OUI location      : E:\MiddelwareHome\Oracle_BI1\oui
Log file location : E:\MiddelwareHome\Oracle_BI1\cfgtoollogs\opatch\opatch2011-0

Patch history file: E:\MiddelwareHome\Oracle_BI1\cfgtoollogs\opatch\opatch_histo

OPatch detects the Middleware Home as "E:\MiddelwareHome"

Lsinventory Output file location : E:\MiddelwareHome\Oracle_BI1\cfgtoollogs\opat


Interim patches (1) :

Patch  9738850      : applied on Wed Sep 15 17:02:42 PDT 2010
   Created on 20 Jun 2010, 12:37:05 hrs PST8PDT
   Bugs fixed:
   Files Touched:
     NonJ2EEManagement.ear --> ORACLE_HOME\opmn\applications\NonJ2EEManagement.e
   Patch Location in Inventory:
   Patch Location in Storage area:

OPatch succeeded.

4 - Documentation / Reference