OBIEE 11g - Upgrade from 11.1.1.6.X to 11.1.1.7 on linux

In this example I am taking OBIEE 11.1.1.6   and upgrading it to  OBIEE 11.1.1.7 Version.http://docs.oracle.com/cd/E28280_01/upgrade.1111/e16452/toc.htm.

High-level upgrade path is as follows
There is a  chapter in the upgrade document which says

"Moving from 11.1.1.3, 11.1.1.5, or 11.1.1.6 to 11.1.1.7".

This is you starting point.

http://docs.oracle.com/cd/E28280_01/upgrade.1111/e16452/bi_plan.htm#BABECJJH

Step 1: 

Stop all the  OBIEE Stack

Step 2: Patching Weblogic

As we are going to the latest OBIEE. I want to patch the weblogic to the latest version.
We  have a default weblogic 10.3.5 which came from default OBIEE 11.1.1.6.0 Installation.
I am here trying to patch the weblogic 10.3.5  to 10.3.6.

Why to patch the endeca ?Another  Reason to upgrade weblogic?

If you are planning to use Endeca  better upgrade the weblogic right now... see the screen shot below. Endeca supports  10.3.6

Note : What versions of weblogic is supported for  OBIEE

  

Patch number  13529623 is required to patch the weblogic from 10.3.5 to 10.3.6, download it from oracle support.

Run the following command to start the upgrade process

That's it we have patched the Weblogic Server


Step 3 : Upgrading the BI Domain

For this one you have to download the OBIEE 11.1.1.7.0  Software(bishiphome)

   
Linux Tip :  If you want to unzip all the Linux files at the same time use the following command

Go to software Location unzip the files : unzip  '*.zip'

Run the installer ./runinstaller

Click Finish and you are done with  Installation.

Step 4:

Start the Node Manager and Weblogic in linux

U01/app/oracle/middleware/wlserver_10.3/server/bin
./srartNodeManager.sh

Start Weblogic

U01/app/oracle/Middleware/user_projects/domains/bifoundation_domain
./startWebLogic.sh

 
Step 5: Upgrading MDS and BIPLATFORM Schemas

Starting the  Patch set assitant

U01/app/oracle/Middleware/oracle_common/bin
./psa

Databse Type : Oracle
Connection String : localhost:1521/orcl
DBA User Name : sys as sysdba
DBA Password: sys
Schema userName : DEV_MDS/password (enter earlier password while installed first time)

Click on the connect button it will automatically populate the MDS Schema Details
*Enter the DEV_BIPLATFORM   Schema password you gae during the OBIEE installation and click " NEXT"*

Step 5:  For all the remaining steps in the oracle documentation  ( 6-14)  As said in the document we are gonna use Configuration Assistant.


u01/app/oracle/Middleware/oracle_BI1/bin

./config.sh

Host Name : Locahost

Port No : 9704

User Name : weblogic

Password : weblogic123

That's it done with  configuration

You can now login to OBIEE URL

 http://localhost:9704/analaytics

 Oracle Business Intelligence  Banner etc are misssing... If you have the same problem flush your cache....

After clearing the cache everything looks good.

Even Weblogic is upgraded to the 10.3.6

The only part I am missing is as follows

Need to do some more reading.... I know while installing OBIEE... we all select the RTD option as below...

Will do some research  on upgrading RTD ( Real -Time Decisions)