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:
- Preparation
- Download the patches from My Oracle Support (3,90GB in total)
- Unzip Patches
- Transfer patches to the ORACLE_HOME folder
- Shut down services
- Apply OBIEE Patches
- 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:
- 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.
- 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:
- 14223977 - 1 of 7 - Oracle Business Intelligence Installer
- 14226980 - 2 of 7 - Oracle Real Time Decisions
- 13960955 - 3 of 7 - Oracle Business Intelligence Publisher
- 14226993 - 4 of 7 - Oracle Business Intelligence ADF Components
- 14228505 - 5 of 7 - Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x
- 13867143 - 6 of 7 - Oracle Business Intelligence
- 14142868 - 7 of 7 - Oracle Business Intelligence Platform Client Installers and MapViewer
- 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:
- OPMN: ./opmnctl stopall
- Managed Server: $MW_HOME/user_projects/domains/bifoundation_domain/bin/stopManagedWeblogic.sh bi_server1
- 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
- Log on to OBIEE (http://<servername>:<port>/analytics)
- Go to Home Page (Click Home in the Link bar in the top right)
 |
| After logging in to OBIEE, click the Home link |
|
|
- 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.
