All of the topics discussed here in this blog comes from my real life encounters. They serve as references for future research. All of the data, contents and information presented in my entries have been altered and edited to protect the confidentiality and privacy of the clients.

Saturday, February 16, 2013

Applying patches for OBIEE 11G

After installing OBIEE, I have decided to apply a big patch, as a result of this action it will upgrade my current version to 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

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


      Stay tuned



Dinesh dev said...

nice piece of information, I had come to know about your internet site from my friend vinay, delhi,i have read atleast 12 posts of yours by now, and let me tell you, your website gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new post, once again hats off to you! Thanx a ton once again, Regards, obiee online training

naveen kumar said...

Thank you provide valuable informations and iam seacrching same informations,and saved my time OBIEE Online Training

vasu srini said...

Thank you provide valuable informations and iam seacrching same informations,and saved my time SAS Online Training

Related Posts Plugin for WordPress, Blogger...