OBIEE 11g - How to Retrieve Patch List Using the OPatch Utility

In OBIEE 11g, the patching model has changed to using OPatch, it is most sophisticated and controllable patching model. It is always difficult to know what is current patch level and how do you get list the of the OBIEE 11g patches with OPatch.

This blog is copy and pasted from a technical note which describes how to get the list of the OBIEE 11g patches with OPatch.

OPatch

To get the list of patches applied in a OBIEE 11g environment, the opatch -lsinventory command can be used. Depending on the product you want to check, set ORACLE_HOME either to Oracle_BI1 or oracle_common.

On Windows Server

Set ORACLE_HOME to your BI Home.

For example, in this case, BI Home is set to D:\BI11\Oracle_BI1:

opatch lsinventory -patch -jdk %JDK_HOME% -jre %JDK_HOME%\jre -oh %ORACLE_HOME%

On Unix Server

Set ORACLE_HOME to your BI Home.

For example, in this case, BI Home is set to D:\BI11\Oracle_BI1:

opatch lsinventory -patch -jdk $JDK_HOME% -jre $JDK_HOME/jre -oh $ORACLE_HOME

Example of OPatch Command

For example you will see the following:-

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 : D:\BI11\Oracle_BI1

Central Inventory : C:\Program Files\Oracle\Inventory

from : n/a

OPatch version : 11.1.0.8.3

OUI version : 11.1.0.8.0

OUI location : D:\BI11\Oracle_BI1\oui

Log file location : D:\BI11\Oracle_BI1\cfgtoollogs\opatch\opatch2010-09-24_16-52-41PM.log

Patch history file: D:\BI11\Oracle_BI1\cfgtoollogs\opatch\opatch_history.txt

OPatch detects the Middleware Home as " D:\BI11" Lsinventory Output file location : D:\BI11\Oracle_BI1\cfgtoollogs\cfgtoollogs\opatch\lsinv\lsinventory2010-11-23_16-52 21PM.txt

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

Interim patches (1) :

Patch 10042883 : applied on Fri Sep 24 16:55:12 PDT 2010  Created on 22 Sep 2010, 16:51:37 hrs  Bugs fixed:

9966690, 9980734, 9975798, 9959228

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

OPatch succeeded.

Limitation

As you know OBIEE 11g is tightly coupled with Web Logic but Web Logic Server patches still need to be applied using Smart Update. So two different patch model for the Web Logic and OBIEE 11g, it is not ideal.