OBIEE 11G - Opatch

Card Puncher Data Processing

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

Management

Version

opatch version
OPatch Version: 11.1.0.12.7

OPatch succeeded.

Applying a patch

Help:

opatch apply -help

Example:

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

Verifying that the patch is correctly installed

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

Rollback

export ORACLE_HOME=myOracleHome
opatch rollback -id PatchId

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.

Documentation / Reference







Share this page:
Follow us:
Task Runner