Upgrade OBIEE 11.1.1.5 to 11.1.1.6

The process to upgrade OBIEE 11.1.1.5 to the latest version 11.1.1.6 is rather simple. Oracle has a great guide to move from 1.3 or 1.5 to 1.6 here. (http://docs.oracle.com/cd/E23943_01/bi.1111/e16452/bi_plan.htm#BABECJJH) However, few of the steps can be skipped if you are starting from version 11.1.1.5.

For demonstration purpose, we use SampleApp v107 VirtualBox image as a starting point. All commands and paths below are UNIX based. See Oracle guide for Windows equivalent commands and paths. If you want to follow along, please download and configure OBIEE 11.1.1.5 SampleApp v107 (Links are provided under Reference section). Video of the whole process is also provided at the end of this post.

Let’s get started.

Step 0: Only applicable to VM machines:

Take a snapshot of the VM in case anything goes wrong, you can revert the machine back to its working condition.

Step 1: Pre-upgrade tasks:

Stop Weblogic Servers and OPMN Managed services. Back up directories. If the VM is just powered up and you did Step 0, skip this step.

Since OBIEE 11.1.1.5 came with Weblogic 10.3.5, you do not have to patch Weblogic.

Step 2: Run the Installer:

• Go to Disk1 folder inside the installation package folder
• Run the following

./runInstaller

Skip Software Update, and then select Software Install Only

Once Prerequisite Checks are done, the next screen will show your system’s current Middleware and Oracle Home. If not, select the proper locations.

Click Next until you get to Summary screen and click Install. The installation should start and complete in around 15 minutes.

Step 3: Upgrade schemas using Patch Set Assistant:

You only need to upgrade MDS and BIPLATFORM schema.

• Change your folder to Middleware/oracle_common/bin folder
• Run the following command

./psa

Check Oracle Business Intelligence box and click Next

Check the two prerequisite boxes and click Next

Put in your database connection string and SYS account/password. Note: for DBA User Name, you have to connect as SYSDBA (i.e: SYS AS SYSDBA).

Click Connect to test the connection and then type in the MDS schema’s password. Click Next

Type in BIPLATFORM’s password and click Next until you get to Upgrade Summary screen. Click on Upgrade.

Step 4: Upgrading System Components

Start up Weblogic and all BI Services.

Set ORACLE_HOME environment variable to your Oracle_BI1 folder

ORACLE_HOME=/bishiphome/Middleware/Oracle_BI1

Run the following command:

cd /bishiphome/Middleware/Oracle_BI1/opmn/bin

./upgradenonj2eeapp.sh

-oracleInstance /bishiphome/Middleware/instances/instance1

-adminHost localhost

-adminPort 7001

-adminUsername weblogic

The script will prompt for Weblogic password few times. At the end, it will indicate the upgrade is successful.

Step 5: Updating Configurations and Stores:

Stop BI Services and Weblogic.

Start WLST

cd /bishiphome/Middleware/oracle_common/common/bin

./wlst.sh

Run the following WLST command:

upgradeOpss(jpsConfig="/bishiphome/Middleware/user_projects/domains/bifoundation_domain/config/fmwconfig/jps-config.xml", jaznData="/bishiphome/Middleware /oracle_common/modules/oracle.jps_11.1.1/domain_config/system-jazn-data.xml ")

The script should come back with the message “Upgrade of opss configuration and security stores is done.”

Now reboot the box and verify you have just successfully upgraded to version 11.1.1.6

Let us know in the comments if you have any questions.

REFERENCE

OBIEE 11.1.1.5 - Sample Application (V107) http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html

Oracle Upgrade Guide - Moving from 11.1.1.3 or 11.1.1.5 to 11.1.1.6 http://docs.oracle.com/cd/E23943_01/bi.1111/e16452/bi_plan.htm#BABECJJH