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: 11.1.0.12.7

OPatch succeeded.
Advertising

3.2 - Applying a patch

Help:

opatch apply -help

Example:

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 11.1.0.8.0

Oracle Interim Patch Installer version 11.1.0.8.0
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    : 11.1.0.8.0
OUI version       : 11.1.0.8.0
OUI location      : E:\MiddelwareHome\Oracle_BI1\oui
Log file location : E:\MiddelwareHome\Oracle_BI1\cfgtoollogs\opatch\opatch2011-0
3-28_07-31-35AM.log

Patch history file: E:\MiddelwareHome\Oracle_BI1\cfgtoollogs\opatch\opatch_histo
ry.txt


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

Lsinventory Output file location : E:\MiddelwareHome\Oracle_BI1\cfgtoollogs\opat
ch\lsinv\lsinventory2011-03-28_07-31-35AM.txt

--------------------------------------------------------------------------------

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:
     9738850
   Files Touched:
     NonJ2EEManagement.ear --> ORACLE_HOME\opmn\applications\NonJ2EEManagement.e
ar
   Patch Location in Inventory:
     E:\MiddelwareHome\Oracle_BI1\inventory\oneoffs\9738850
   Patch Location in Storage area:
     E:\MiddelwareHome\Oracle_BI1\.patch_storage\9738850_Jun_20_2010_12_37_05

--------------------------------------------------------------------------------
OPatch succeeded.

4 - Documentation / Reference

Advertising