Monday, July 9, 2012

How-To: Applying OBIEE Patch 11.1.1.6.2 BP1

Introduction

I have for a long time been thinking about starting blogging about the bits and pieces around Oracle Business Intelligence and Data Warehouse technology currently available. This is a first post, focused around applying the latest bundle patch 11.1.1.6.2 BP1 released June 30th 2012, for Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.6.0. This release is a patch release, which means you must first install OBIEE 11.1.1.6.0 or upgrade your current 11.1.1.3 or 11.1.1.5 version to 11.1.1.6.0. The instructions below are based on the following setup:
  • OBIEE 11.1.1.6.0 installed on an Oracle Enterprise Linux 32-bit Virtual Machine, the Weblogic Server is version 10.3.5.0
  • The Virtual Machine is running in Oracle VirtualBox on a 64-bit Windows 7 host with  8GB RAM
  • MW_HOME=/home/oracle/obiee/
  • BI ORACLE_HOME=/home/oracle/obiee/Oracle_BI1
At first, the patching process can seem quite overwhelming, but fear not - it should be quite simple - and can be carried out in less than an hour if you have downloaded the patch files before hand.  The patches are approximately 4GB, depending on your operating system version, so make sure you have downloaded these before starting.

The high-level steps

The text below will go deeper into these steps:
  1. Preparation
  2. Download the patches from My Oracle Support (3,90GB in total)
  3. Unzip Patches
  4. Transfer patches to the ORACLE_HOME folder
  5. Shut down services
  6. Apply OBIEE Patches
  7. Tasks to be carried out after patching

1. Preparation

Start by reading the README.TXT that comes with the first patch (14223977). It gives all the instructions necessary for patching your existing system.

But you should be aware of the following warnings in the Read Me file before continuing:
  1. This patchset is available for all customers who are using Oracle Business Intelligence Enterprise Edition 11.1.1.6.0, 11.1.1.6.1, and 11.1.1.6.2.
  2. This is not meant for Oracle Exalytics installations - wait for the official Oracle Release Patchset PS1 for Exalytics - this will also include patches for other components in the Exalytics system.

2. Download Patches

For downloading the files, you log on to My Oracle Support (http://supporthtml.oracle.com), and search for the patches. This process is described very well by Robin Mofatt, you can see his excellent description by clicking the link below. If you are using a Unix-based operating system, you can even use the WGET functionality described by Robin

http://www.rittmanmead.com/2012/07/downloading-obiee-patches-from-oracle-with-wget/

One good tip is to use shift-click selecting all the patches you want to download, instead of downloading them one at a time.

Selecting the patches to download - make sure you choose the right operating system

These are the patches you need to download - make sure you get the right version for your operating system:

  1. 14223977 - 1 of 7 - Oracle Business Intelligence Installer
  2. 14226980 - 2 of 7 - Oracle Real Time Decisions
  3. 13960955 - 3 of 7 - Oracle Business Intelligence Publisher
  4. 14226993 - 4 of 7 - Oracle Business Intelligence ADF Components
  5. 14228505 - 5 of 7 - Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x
  6. 13867143 - 6 of 7 - Oracle Business Intelligence
  7. 14142868 - 7 of 7 - Oracle Business Intelligence Platform Client Installers and MapViewer
  8. 13952743 - Interim Patch for Bug: 13952743 - JDeveloper

3. Unzip patches

When you have downloaded all 8 patches, unzip the files into each its own folder. When the files are downloaded and unzipped, you should end up with this structure:

The folder structure on Windows 7 after unzipping all 8 patches - ready to be applied in the virtual machine
I am working with a Virtual Machine with Oracle Enterprise Linux 32-bit and OBIEE 11.1.1.6.0 installed. I have downloaded the files to my host, and unzipped all the patch files to a folder called E:\Oracle Software\Shared\OBIEE_Linux_11.1.1.6.2_BP1.

If you do not work on a Virtual Machine, please skip down to the next step

Next step is to map the E:\Oracle Software\Shared folder as a shared folder in the VM, and then mount the Shared folder in the Virtual Machine:

Add a shared folder to the virtual machine by going to Devices - Shared Folders
This is the information entered when adding a shared folder to the virtual machine

Then open a terminal window (command line) in the Linux virtual machine, and type in the following commands: 
sudo mkdir /mnt/sf_Shared
sudo mount -t vboxsf Shared /mnt/sf_Shared

You will probably be prompted for a password, enter the password for root to be able to mount the shared folder.

This now means you will have access to the downloaded and unzipped patch files in the /mnt/sf_Shared/OBIEE_Linux_11.1.1.6.2_BP1/ folder from within the Linux virtual machine.

4. Transfer patches to the ORACLE_HOME folder

Next step is to copy the files to the correct place. The patch instructions recommends that the patch folders be copied to the Oracle_BI1 folder (ORACLE_HOME) in the middleware home folder.

We start by only copying the 7 OBIEE patches first - the JDeveloper patch will be applied later.

cp -R /mnt/sf_Shared/OBIEE_Linux_11.1.1.6.2_BP1/p14223977_1111621_Generic/14223977 /home/oracle/obiee/Oracle_BI1
cp -R /mnt/sf_Shared/OBIEE_Linux_11.1.1.6.2_BP1/p14226980_1111621_Generic/14226980 /home/oracle/obiee/Oracle_BI1
cp -R /mnt/sf_Shared/OBIEE_Linux_11.1.1.6.2_BP1/p13960955_1111621_Generic/13960955 /home/oracle/obiee/Oracle_BI1
cp -R /mnt/sf_Shared/OBIEE_Linux_11.1.1.6.2_BP1/p14226993_1111621_Generic/14226993 /home/oracle/obiee/Oracle_BI1
cp -R /mnt/sf_Shared/OBIEE_Linux_11.1.1.6.2_BP1/p14228505_1111621_LINUX/14228505 /home/oracle/obiee/Oracle_BI1
cp -R /mnt/sf_Shared/OBIEE_Linux_11.1.1.6.2_BP1/p13867143_1111621_LINUX/13867143 /home/oracle/obiee/Oracle_BI1
cp -R /mnt/sf_Shared/OBIEE_Linux_11.1.1.6.2_BP1/p14142868_1111621_Generic/14142868 /home/oracle/obiee/Oracle_BI1

The patches are now in the correct position, and are ready to be applied.

5. Shut down services

You should shut down all services:
  1. OPMN: ./opmnctl stopall
  2. Managed Server: $MW_HOME/user_projects/domains/bifoundation_domain/bin/stopManagedWeblogic.sh bi_server1
  3. Admin Server: $MW_HOME/user_projects/domains/bifoundation_domain/bin/stopWeblogic.sh

6. Apply OBIE Patches

First, we need to prepare the environment variables. The ORACLE_HOME, JAVA_HOME and PATH variables all need to point to the OBIEE Installation. Change the first line below to make sure it is pointing at the right folder in your installation:
cd /home/oracle/obiee/Oracle_BI1
export ORACLE_HOME=$PWD
export PATH=$ORACLE_HOME/bin:$PATH
export JAVA_HOME=$ORACLE_HOME/jdk
export PATH=$JAVA_HOME/bin:$PATH
export PATH=$ORACLE_HOME/OPatch:$PATH
Once this is correct, you can now apply the patches. Apply the patches one at a time, and make sure that you get a positive result:
cd $ORACLE_HOME/14223977
opatch apply
cd $ORACLE_HOME/14226980
opatch apply
cd $ORACLE_HOME/13960955
opatch apply
cd $ORACLE_HOME/14226993
opatch apply
cd $ORACLE_HOME/14228505
opatch apply
cd $ORACLE_HOME/13867143
opatch apply

7. Tasks to be carried out after patching

7.1. Copy  new files

Copy the BIPublisherDesktop32.exe and BIPublisherDesktop64.exe files from the Oracle BI Home/clients/bipublisher/repository/Tools directory to the Middleware Home/user_projects/domains/bifoundation_domain/config/bipublisher/repository/Tools directory.

cd /home/oracle/obiee/user_projects/domains/bifoundation_domain/config/bipublisher/repository/Tools/
cp /home/oracle/obiee/Oracle_BI1/clients/bipublisher/repository/Tools/BIPublisherDesktop* .

7.2. Apply JDeveloper Interim Patch

Check that you have the correct version of Perl

export ORACLE_HOME= /home/oracle/obiee/oracle_common
perl -v

The resulting version should be greater that 5.00503 . If not, you should follow the instructions in this MOS note:
  Note 189489.1 - Oracle Data Server Interim Patch Installation
   - https://support.oracle.com/CSP/main/article?cmd=show&?;type=NOT&;id=189489.1

Confirm that opatch and unzip are in your path:
which opatch
which unzip

If you have come this far without any errors, you can apply the last patch. If you are not succesful, double-check the ORACLE_HOME environment variable, and make sure that it points to the oracle_common folder, and not the Oracle_BI1 folder.

export ORACLE_HOME=/home/oracle/obiee/oracle_common

cd $ORACLE_HOME

cp -R /mnt/sf_Shared/OBIEE_Linux_11.1.1.6.2_BP1/p13952743_111162_Generic/13952743/ .

cd $ORACLE_HOME/13952743

opatch apply

7.3 Starting the System

 When the last patch has been applied succesfully, start the Weblogic Admin server (and Managed server if you are not running a Simple install type)


- Weblogic AdminServer:
/home/oracle/obiee/user_projects/domains/bifoundation_domain/bin/startWeblogic.sh
- Weblogic Managed Server bi_server1 (if your installation is of type "Simple", this step is not necessary):
/home/oracle/obiee/user_projects/domains/bifoundation_domain/bin/startManagedWeblogic.sh bi_server1
- Start BI Components with opmnctl
/home/oracle/obiee/instances/instance1/bin/opmnctl startall

7.4 Client Configuration

- Clear browser cache on client PC

- Uninstall BI Administration Tool

FInd the "Change Oracle Business Intelligence Enterprise Edition Plus Client Installation" icon in Start - All Programs - Oracle Business Intelligence Enterprise Edition folder.
Select "Uninstall Product" to remove the old Oracle BI Administration Tool
- Install BI Administration Tool

  1. Log on to OBIEE (http://<servername>:<port>/analytics)
  2. Go to Home Page (Click Home in the Link bar in the top right)
    3. After logging in to OBIEE, click the Home link

  3. In the bottom left, find the "Get Started..." Section, click on "Download BI Desktop Tools" and select "Oracle BI Client Installer" for the operating system you are using:



- Uninstall & Install BI Publisher Desktop Tool

Follow the same procedure as described above for uninstalling and reinstalling the Oracle BI Administration Tool.

Conclusion

That's it! You should now have patched your system, and be ready to use Trellis Views, the new Mobile BI App for iOS, etc. as Mark Rittman goes through in a detailed manner in this post:

http://www.rittmanmead.com/2012/07/obiee-11-1-1-6-2-bp1-new-features-oracle-bi-mobile-hd-and-patching-upgrade-considerations/

I will be returning with more posts, I am planning on sharing more information on the Mobile App for iOS, Exalytics installation, and more - with inspiration on my current assignment as an Oracle BI & Data Warehouse Consultant.


The views expressed on this blog are those of the author and do not necessarily reflect the views of Oracle.

Posted by at
Labels: , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)