Wednesday, June 20, 2012

OBIEE 10g To 11G Upgrade


OBIEE 10g to 11G Upgrade Step by Step


Before we begin the upgrade process, a couple of key points to note. As part of the OBIEE 11g upgrade, the following gets upgraded:
  1. RPD including users and groups
  2. Webcat
  3. Scheduler Schema (Delivers)
  4. BI Publisher Repository
  5. BI Publisher Schema
The following will NOT get upgraded:
  1. Configuration files
  2. Custom style sheets
  3. Custom javascripts
 OBIEE Upgrade Start:-

Now, let’s start with the upgrade. To begin with let’s identify a 10g RPD and webcat that we want to upgrade. OBIEE 11g services would need to up and running.
image
On the Deployment tab, we can verify which RPD and webcat is currently online:
image
Important: We need to make a copy of the the rpd and webcat currently loaded in OBIEE. After a successful upgrade, OBIEE switches the upgraded RPD & Webcat to be the online copy. We need to switch these back after a successful upgrade.
Hint: You may need to ‘Lock and Edit’ the configuration in order to see the webcat location.
Navigate to ?:\<installfolder>\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1

image
Let’s create a new folder, then copy the ‘sample’ folder with all subfolders into the new folder:
image
This folder will provide the data for the rpd we are about to upgrade.
Now let’s start the Upgrade Assistant and run through the prompts.
?:\<installfolder>\Oracle_BI1\bin\ua.bat
image
image
image
    1. Browse to the rpd that we want to upgrade.
    2. Enter the credentials for this RPD.
    3. We need to create a password to secure the upgraded RPD.
    4. We need to browse to the folder that contains the 10g webcat.
    5. Now we specify an empty folder for deliveries.
image
     6.We specify the location and credentials to login to your Weblogic Admin Server.
image
image
   7.Select ‘Upgrade’
image
image
image
image
We refresh the Deployments tab in Enterprise Manager
image
Let’s check that we are now using the 10g rpd and webcat (upgraded to 11g).
image
Let’s login to BI and view the updated dashboard.
image
The Upgrade is complete. We now need to switch back to the original Application. This step is very important as the upgraded rpd and webcat is now the one loaded in OBIEE. As part of the upgrade, the security has also been migrated to the weblogic layer.

Thanks,
Satya Ranki Reddy

10 comments:

  1. Satya,
    do you have an idea of time to accomplish the migration with tests?
    Any MS Project to help?
    Tks,
    Manuel

    ReplyDelete
  2. Hi Manuel,

    Thanks for visiting my blog.

    Tell me what kind of tests if you required..

    I will try to help you on this.

    Thank,
    Satya

    ReplyDelete
  3. Hi Satya,
    what I had in mind was asking for any estimate of time to perform the migration with a set of testing activities to assure the success?

    Tks,
    Manuel

    ReplyDelete

  4. Hi Manuel,

    For me it was taken 2 hour's for migrate to 10g to 11g. I guess same time length will take for you also.

    Thanks,
    Satya

    ReplyDelete
  5. Thanks for posting the above blog. It really helps

    ReplyDelete
  6. Hi Satya,

    Can you please provide me with some kind of Project Plan that u had used for 10g to 11g upgrade?

    Please mail it to satesh_sarathi@yahoo.com

    Thanks
    Satesh

    ReplyDelete
  7. Hi Satya,
    Can you also send me the Project Plan, I really appreciate your help. My email is return.asap@yahoo.com
    Regards,
    Ruby

    ReplyDelete
  8. i am new to obiee ,can you plz tell me what exact difference between table view and pivot table view and limitation and errors in pivot table

    ReplyDelete
  9. Thanks for providing valuable information.Request you to please provide a time estimate of a project in each phase for migration to 10G to 11g.(Production evironment) .My email is ashokbi2302@gmail.com.
    Thanks,
    Ashok

    ReplyDelete
  10. Hi Satya,

    This post is very very help full for migration from 10g to 11g.
    I would request you to provide a time estimation for the migration to my mail vsreekanthobia@outlook.com

    ReplyDelete