This is the third part of my recent adventure with upgrading an Oracle BI Enterprise Edition (OBIEE) installation. This is about patching the OBIEE to the latest patchset release.
Patching OBIEE
When writing this I was patching from 11.1.1.6.0 to 11.1.1.6.4. As this was the requested patchset by the customer.
Obtaining the Patches
All of the patches can be obtained from Oracle Support. Figuring out which patches you need can be quite tricky. But they can all be found by doing the following.
- Click on the "Patches & Updates" tab
- In the "Patch Search" box select the following
- Product/Family = Oracle BI Suite EE
- Release = 11.1.1.6.4
- Select the patches and download the files
Applying the Patches
Unzip the patch zip files into the MIDDLEWARE_HOME/Oracle_BI1 folder.
Then following the README files from the first patch, you should set the following environment variables. As this patch was done on windows you would do the following. You should be able to rewrite for other operating systems.
set ORACLE_HOME=e:\Omit\OWL1035\Oracle_BI1
set PATH=%ORACLE_HOME%\bin;%PATH%
set JAVA_HOME=%ORACLE_HOME%\jdk
set PATH=%JAVA_HOME%\bin;%PATH%
set PATH=%ORACLE_HOME%\OPatch;%PATH%
Then for each of the unzippen patch folders. run opatch apply. You should do this in the order specified in the README file from the first patch.
Then following the README files from the first patch, you should set the following environment variables. As this patch was done on windows you would do the following. You should be able to rewrite for other operating systems.
set ORACLE_HOME=e:\Omit\OWL1035\Oracle_BI1
set PATH=%ORACLE_HOME%\bin;%PATH%
set JAVA_HOME=%ORACLE_HOME%\jdk
set PATH=%JAVA_HOME%\bin;%PATH%
set PATH=%ORACLE_HOME%\OPatch;%PATH%
Then for each of the unzippen patch folders. run opatch apply. You should do this in the order specified in the README file from the first patch.
Post Patch tasks
After patching the product you should do the following:
- Copy the BIPublisherDesktop32.exe and BIPublisherDesktop64.exe files from the ORACLE_BI_HOME/clients/bipublisher/repository/Tools directory to the MW_HOME/user_projects/domains/bifoundation_domain/config/bipublisher/repository/Tools directory.
- Remove the jsp_servlet subdirectory associated with Oracle BI Publisher (if it exists), as follows:
- If it exists, the jsp_servlet subdirectory is located in one of the directories below the <Middleware Home>/<Domain Home>/servers/bi_server1/tmp/_WL_user/bipublisher_11.1.1 directory.
- Start all the BI components (AdminServer, Managed Server and Process Manager)
After having done all of the above you should now have a fully patched OBIEE installation.