OBI EE patching process


If you want to get working instance of OBI EE you typically need to install "basic" OBI EE version (11.1.1.7.0 currently) and then patch it to the latest version. Each patch corrects multiple errors and brings new features and browsers support.
This post outlines basic patching principles and shows step by step process of applying the latest patch.
There are nine patches available at the time of this post:

Version            Patch number
11.1.1.7.1            16556157
11.1.1.7.131017        17530796
11.1.1.7.140114        17886497
11.1.1.7.140225        18057570
11.1.1.7.140415        18283508
11.1.1.7.140527        18507268
11.1.1.7.140715        18818588
11.1.1.7.141014        19261194
11.1.1.7.150120        20124371
11.1.1.7.150714        21103263

Last six digits of a version (except for 11.1.1.7.1) are the date of patch availability in a form "ddmmyy".

Obtaining the patch

Patch download is available only for customers with valid support contract. To get the patch you should go to My Oracle Support portal (former Oracle Metalink). This is the only place where you can get patches for your system.

Sign in with your Oracle account. Your account needs to be linked to a valid customer support identifier (CSI).
Navigate to Patches & Updates tab. You can search patches by patch number if you know one or by product, version and so on.

For example, navigate to Product or Family (advanced) section to search for patch by product.

Start typing into product edit box. Typing Oracle biee is sufficient to find Oracle Business Intelligence product.

Fill in other fields with your parameters. Please note that Release field requires the version of your current release, not the release you want to get after patching. Usually, there is no reason to choose not latest version so check Show recommended patches only and Exclude superseded patches checkboxes.

Press the Search button and review the result.

If your system is a full OBI EE Suite installation, then select BI BUNDLE PATCH result row. Small pop-up window will appear.

Press the Download button and the select *.zip file to download.

Applying patch

When you unzip the file, you've got from My Oracle Support you will get eight zip files and one html file. Zip files contain patches for different parts of your OBI EE Suite instance, and the html file is an instruction for installation. If your instance does not include all of the available OBI EE Suite components, you may remove files you don't need without any trouble.

Move these files to the OBI EE server you want to patch and unzip them. Readme says you must place contents of zip files into a subdirectory below the Oracle BI Home directory but from my experience it is not necessary, and you may use any directory you like.
After that, you need to follow the installation steps from the readme file. They may differ from patch to patch, but the general direction is the following:
1. Stop OBI EE instance.
2. Backup some directories (see readme).
3. Define ORACLEHOME environment variable. It should point to <installdir>/OracleBI1 directory. For my server it's /u01/oracle/Middleware/OracleBI1 directory.

export ORACLE_HOME=/u01/oracle/Middleware/Oracle_BI1

(for Windows it would be something like

set ORACLE_HOME=C:\OBIEE\Middleware\Oracle_BI1)
  1. Check if opatch is working as intended.
$ORACLE_HOME/OPatch/opatch lsinventory


5. Apply patches one by one using opatch apply command

$ORACLE_HOME/OPatch/opatch apply <patch_dir>
<patch_dir> is the directory of current patch part. For OBIEE 11.1.1.7.150120 it will be the following sequence of commands (not necessarily in this order)
$ORACLE_HOME/OPatch/opatch apply /tmp/bi.150120/20124371/16913445  
$ORACLE_HOME/OPatch/opatch apply /tmp/bi.150120/20124371/16997936  
$ORACLE_HOME/OPatch/opatch apply /tmp/bi.150120/20124371/19822826  
$ORACLE_HOME/OPatch/opatch apply /tmp/bi.150120/20124371/19822857  
$ORACLE_HOME/OPatch/opatch apply /tmp/bi.150120/20124371/19822893  
$ORACLE_HOME/OPatch/opatch apply /tmp/bi.150120/20124371/19823874  
$ORACLE_HOME/OPatch/opatch apply /tmp/bi.150120/20124371/19825503  
$ORACLE_HOME/OPatch/opatch apply /tmp/bi.150120/20124371/20022695

/tmp/bi.150120/20124371 is a temporary directory where I unzipped the patch.
6. Check patch result using lsinventory command

7. Typically you'll have to remove some files or directories (see readme).
8. Start your newly patched system.
Don't hesitate to leave a comment or two. :)

oracle obiee patch


Andrew Fomin Profile Picture
Andrew Fomin

OBIEE specialist since 2007 and Oracle Discoverer before. DWH architect, BI enthusiast, blogger. Lazy cats owner. All opinions are my own and not the views of my employer.


Additional Posts
Share This Post
Twitter Google+ Pinterest Facebook
comments powered by HyperComments