OBI EE patching process
If you want to get working instance of OBI EE you typically need to install "basic" OBI EE version (22.214.171.124.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 126.96.36.199.1 16556157 188.8.131.52.131017 17530796 184.108.40.206.140114 17886497 220.127.116.11.140225 18057570 18.104.22.168.140415 18283508 22.214.171.124.140527 18507268 126.96.36.199.140715 18818588 188.8.131.52.141014 19261194 184.108.40.206.150120 20124371 220.127.116.11.150714 21103263
Last six digits of a version (except for 18.104.22.168.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.
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.
(for Windows it would be something like
- Check if opatch is working as intended.
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 22.214.171.124.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. :)
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.