Sunday, May 20, 2012

Upgrade OBIEE to

The process to upgrade OBIEE the latest version is rather simple. Oracle has a greatguide to move from 1.3 or 1.5 to 1.6 here

However, few of the steps can be skipped if you are starting fromversion
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 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 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
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
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. Click Next 
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
Run the following command:
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
Runthe following WLST command:
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 

Let us know in the comments if you haveany questions.
Satya Ranki Reddy.

No comments:

Post a Comment