[OBIEE11g] - Upgrade OBIEE 11.1.1.5 To Latest Version 11.1.1.6

The process to upgrade OBIEE 11.1.1.5to the latest version 11.1.1.6

(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 fromversion 11.1.1.5.

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

Let’s get started.

Step0: Only applicable to VM machines:

Take a snapshot of the VM in caseanything goes wrong, you can revert the machine back to its workingcondition.

Step1: Pre-upgrade tasks:

Stop Weblogic Servers and OPMN Managedservices. Back up directories. If the VM is just powered up and youdid Step 0, skip this step.

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

Step2: Run the Installer:

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

./runInstaller

Skip Software Update, and then selectSoftware Install Only

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

Click Next until you get toSummary screen and click Install. The installationshould start and complete in around 15 minutes.

Step3: Upgrade schemas using Patch Set Assistant:

You only need to upgrade MDS andBIPLATFORM schema.

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

./psa

Check Oracle Business Intelligencebox and click Next

Check the two prerequisite boxes andclick Next

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

Click Connect to test theconnection and then type in the MDS schema’s password. ClickNext

Type in BIPLATFORM’s password andclick Next until you get to Upgrade Summaryscreen.Click on Upgrade.

Step 4: Upgrading System Components

Start up Weblogic and all BI Services.

Set ORACLE_HOME environment variable toyour 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

-adminHostlocalhost

-adminPort7001

-adminUsernameweblogic

The script will prompt for Weblogicpassword few times. At the end, it will indicate the upgrade issuccessful.

Step 5: Updating Configurations and Stores:

Stop BI Services and Weblogic.

Start WLST

cd/bishiphome/Middleware/oracle_common/common/bin

./wlst.sh

Runthe 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“)

Thescript should come back with the message “Upgrade of opssconfiguration and security stores is done.”

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

REFERENCE

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