Patch OBIEE the quicker way – with OPatch napply
Since 2012, Oracle’s patching strategy for OBIEE has been Bundle Patches released approximately once a month. These bundle patches are usually cumulative ones, applied on top of the .0 version of the product. Patching is done through Oracle’s standard
OPatch tool, which manages the application of patches along with an inventory of them and rollback if necessary.
I’ve previously written about the overall patching process here. OPatch is part and parcel of an OBIEE sysadmin’s life, so I wanted to share this short article to show the quicker way to apply the PSUs. It uses a more direct way than the patch documentation describes, taking advantage of the
napply option of OPatch (documented here). By using this option
OPatch will apply all listed patches in one go, rather than one at a time. As well as this, we can use the
silent flag to stop
OPatch from prompting to apply each patch in turn.
- Download the necessary patches – for 220.127.116.11.1 this is 16569379 and 16556157. In a server environment you can use wget to download the patches as detailed here.
- Validate the checksums for the downloaded files, to make sure they didn’t get corrupted during download. Use the Digest link when downloading to view the checksums. For example, the Linux x86-64 checksums are :
123456p16556157_111170_Linux-x86-64.zip 2673750617 bytesMD5 D3DDDEC4CB189A53B2681BA6522A0035p16569379_111170_Linux-x86-64.zip 93617 bytesMD5 2BC0E8B903A10311C5CBE6F0D4871E31
- Unzip the patches. Within the main patch (16556157) there are a series of further zip archives – unzip these too
- Put all the patch folders in a single folder, so it looks something like this:
- Take backups, as described in the patch documentation.
- Set your environment variables, setting
PATCH_FOLDERto the folder you unzipped the patches to in step 4 above, and
123456set PATCH_FOLDER=Y:\installers\OBI\18.104.22.168\win-x86-64_22.214.171.124.1set ORACLE_HOME=c:\oracle\middleware\Oracle_BI1set JAVA_HOME=%ORACLE_HOME%\jdkset PATH=%ORACLE_HOME%\OPatch;%JAVA_HOME%\bin;%ORACLE_HOME\bin%;%PATH%
123456export PATCH_FOLDER=/mnt/hgfs/installers/OBI/126.96.36.199/linux-x86-64_188.8.131.52.1export ORACLE_HOME=/home/oracle/obiee/Oracle_BI1export JAVA_HOME=$ORACLE_HOME/jdkexport PATH=$ORACLE_HOME/OPatch:$JAVA_HOME/bin:$ORACLE_HOME/bin:$PATH
- Shut down OPMN, the Managed Server and the Admin Server
- Apply all the patches in one go, with no prompting:
12opatch napply -silent %PATCH_FOLDER% -id 16453010,16842070,16849017,16850553,16869578,16916026,16569379
12opatch napply -silent $PATCH_FOLDER -id 16453010,16842070,16849017,16850553,16869578,16916026,16569379
- Validate that they’ve been applied – the following should list all seven patches plus the bugs they fix:
- Per the instructions in the README.html for patch
16453010for post-patch actions:
123456789del<code> %ORACLE_HOME%\bifoundation\web\catalogmanager\configuration\org.eclipse.osgidel</code> %<code>ORACLE_HOME%\</code>bifoundation\web\catalogmanager\configuration\org.eclipse.equinox.appcopy %ORACLE_HOME%\clients\bipublisher\repository\Tools\BIPublisherDesktop*.exe %ORACLE_HOME%\..\user_projects\domains\bifoundation_domain\config\bipublisher\repository\Toolscopy %ORACLE_HOME%\clients\bipublisher\repository\Admin\DataSource\msmdacc64.dll %ORACLE_HOME%\..\user_projects\domains\bifoundation_domain\config\bipublisher\repository\Admin\DataSourcefor /d /r %ORACLE_HOME%\..\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\bipublisher_11.1.1 %d in (jsp_servlet) do @if exist "%d" rd /s/q "%d"
123456789rm -rv $ORACLE_HOME/bifoundation/web/catalogmanager/configuration/org.eclipse.osgirm -rv <code>$ORACLE_HOME/</code>bifoundation/web/catalogmanager/configuration/org.eclipse.equinox.appcp $ORACLE_HOME/clients/bipublisher/repository/Tools/BIPublisherDesktop*.exe $ORACLE_HOME/../user_projects/domains/bifoundation_domain/config/bipublisher/repository/Tools/cp $ORACLE_HOME/clients/bipublisher/repository/Admin/DataSource/msmdacc64.dll $ORACLE_HOME/../user_projects/domains/bifoundation_domain/config/bipublisher/repository/Admin/DataSourcerm -rfv $ORACLE_HOME/../user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/bipublisher_11.1.1/*/jsp_servlet
msmdacc64.dlldidn’t exist on either of my installations that I’ve tried this on)
- Start up Admin Server, Managed Server, and OPMN. Login to OBIEE and check the new version:
- Don’t forget to check the README.html for patch 16453010 for full instructions on updating the client, customised skins, mapviewer config, etc.