Applying patches for OBIEE 11G

After installing OBIEE 11.1.1.6.0, I have decided to apply a big patch, as a result of this action it will upgrade my current version to 11.1.1.6.5. I will go over how this is done in my environment.

The current version after the installation:

Now comes the steps:

1. Download and extract the following zip files to my linux machine and unzip them

p    14665284_111160_Linux-x86-64.zip 

p    14696072_111160_Generic.zip 

p    14733370_111160_Generic.zip

      

      2. Take a backup of the existing 11G

      3. Stop the BI Process:

      $ cd $ORACLEBI_HOME/instances/instance1/bin

$    $ ./opmnctl stopall

$    $ cd $ORACLEBI_HOME/user_projects/domains/bifoundation_domain/bin/

$    $ ./stopManagedWebLogic.sh bi_server1

$    $ ps -ef | grep Node|grep nodemanager | cut -c10-15

k    $ kill all return PIDs

$    $ cd $ORACLE BI_HOME/user_projects/domains/bifoundation_domain/bin/

$    $ ./stopWebLogic.sh

     

      4. Clear OBIEE Catalog binary cache. This step is usually not needed for the immediate upgrade after refresh installation. But if you have used the existing environment for a while and then do the patching, it's better to clear the cache on some of the existing catalog folders.

$    $ cd $ORACLEBI_HOME/Oracle_BI1/bifoundation/web/catalogmanager/configuration
$    $ rm –rf org.eclipse.osgi
$    $ rm –rf org.eclipse.equinox.app

      5. Set environment variables:


      $ export ORACLE_HOME=/opt/oracle/obiee/Oracle_BI1
      $ export PATH=$ORACLE_HOME/bin:$PATH
      $ export JAVA_HOME=$ORACLE_HOME/jdk
      $ export PATH=$JAVA_HOME/bin:$PATH
      $ export PATH=$ORACLE_HOME/OPatch:$PATH

       6. Navigate to each of the unzipped patch folder and enter the following commend to apply patch:

       $ cd 14696072
       $ opatch apply
       $ cd 14665284
       $ opatch apply
       $ cd 14733370
       $ opatch apply

7     7. Process goes and now validate and see if the patches are applied:


       $ cd $OBIEE_HOME
       $ opatch lsinventory
       The above patches should be displayed in the list of applied patches.

       8. Generate Boot.properties:


$ cd $ORACLEBI_HOME/user_projects/domains/bifoundation_domain/bin/
$ ./startWebLogic.sh -Dweblogic.system.StoreBootIdentity=true
$ Enter weblogic username and password when asked
$ wait for few minutes

       9. Copy boot.properties to bi_server1
$ cd  $ORACLEBI_HOME/user_projects/domains/bifoundation_domain/servers/
$ cp AdminServer/security/boot.properties bi_server1/security/boot.properties


      10. Start all of the services back up. If you are not sure what is the order to get 11g started, you can visit this article 

      Now after logging into the newly updated 11g front end, you should see the result of applying this patch and now the application is upgraded to 11.1.1.6.5

      Next time, we will talk about how to upgrade RPD files and Webcatalogs from 10G to 11g.

      Thanks

      Stay tuned