Wednesday, December 26, 2012

To apply patch OBIEE 11.1.1.6.0 TO 11.1.1.6.1


Steps to apply the patch on Linux 64 bit Platform.

OBIEE 11.1.1.6.0 is boxed up with OPatch Version: 11.1.0.9.0


Oracle Business Intelligence Enterprise Edition 11.1.1.6.1 –Patch 13742915


The OPatch features and executables for LINUX can be found here

MiddlewareHome/Oracle_BI1/OPatch

Before Running any commands make sure an ORACLE_HOME is set
This can be set within the .bash_profile like below

-------------------------------------------------------------------------------
 export ORACLE_HOME=/mydisk/MiddlewareHome/Oracle_BI1
 PATH=$PATH:/mydisk/MiddlewareHome/Oracle_BI1/OPatch
 export PATH
 ------------------------------------------------------------------------------

To check the Version of the OPatch run this command : 
------------------------------------------------------------------------------
opatch version
------------------------------------------------------------------------------

To make sure everything is working properly ready to install a patch run the below command
check the patch inventory is accessible

------------------------------------------------------------------------------
opatch lsinv -jre /mydisk/MiddlewareHome/Oracle_BI1/jdk
------------------------------------------------------------------------------

Download your patch from Metalink

FTP to your linux Box and unzip the patch in a directory.

------------------------------------------------------------------------------
unzip p13742915_111161_Linux-x86-64.zip
------------------------------------------------------------------------------

Then run the following command to install your patch. 
Note Before Installing just bring down your OPMN Services

------------------------------------------------------------------------------
$MW_HOME/instances/instance1/bin/opmnctl stopall
------------------------------------------------------------------------------

GOTO DIRECTORY WHERE PATCH WAS UNZIPPED and into directory 13742915 AND RUN COMMAND below

------------------------------------------------------------------------------
opatch apply -jre /mydisk/MiddlewareHome/Oracle_BI1/jdk
------------------------------------------------------------------------------

Thats it patch should be applied. 
Bring up the OPMN Services for OBIEE and check version and also run the below command

------------------------------------------------------------------------------
$MW_HOME/instances/instance1/bin/opmnctl startall
------------------------------------------------------------------------------
opatch lsinv -jre /mydisk/MiddlewareHome/Oracle_BI1/jdk
------------------------------------------------------------------------------

Opatch Logs are here:

$ORACLE_HOME/cfgtoollogs/opatch

Here is what it should look like under Help - About OBIEE