You are here: OBIEE OBIEE 10g to OBIEE 11g Upgrade for Repository and Presentation Catalog

OBIEE 10g to OBIEE 11g Upgrade for Repository and Presentation Catalog

Written by  Saurabh Kumar, OBIEE Architect, Adiva Consulting
Rate this item
(15 votes)

 Have you tired to migrate OBIEE 10g Repository and Presentation Catalog  to OBIEE11g ? As a part of OBIEE 11g uptake exercise for one of our client, We tried it and went pretty well. I thought, lets share with our blog readers..

Pre-Requisites
• Start up all the OBIEE 11g related services (BI Services and Web logic Server) and check that you can log in to Enterprise Manager,WLS Admin Console and OBIEE Answers.
Enterpise Manager   : http://localhost:7001/em
 WLS Admin Console : http://localhost:7001/em console
 OBIEE Answers/DashBoard   : http://localhost:9704/analytics 
• All the releventrelevant TNS names used in the 10g rpd connections are present in <OBIEE_MW_HOME>/Oracle_BI1/network/admin/tnsnames.ora file

 • Step-1

Navigate to <OBIEE_MW_HOME>/Oracle_BI1/bin/ua.bat . This batch file is the Upgrade Assistant wizard. Launch the wizard by double clicking on it.
Once this launches, it specifies the version(11.1.1.3.0) the upgraded rpd will be. Click NEXT

• Step-2

In this page select "Upgrade Oracle BI RPD and Presentation Catalog" radio button. Click NEXT


 

• Step-3

Here check the "Upgrade Repository (RPD)" checkbox.
Specify the location of the 10g RPD file.
Enter the Administrator credentials of the old 10g RPD file.
Specify the password for the upgraded 11g RPD and confirm it once again.

 

• Step-4

Specify the Weblogic Admin Console username and password. Port number is 7001
Click Next..

 


 

During the examination process, Upgrade Assistant checks for the following:
• The source directory exists.
• The source directory is readable and contains a file for upgrade.
Under the Status column, the word succeeded should appear. If instead, the word failed appears, inspect the log file for details.

• Step-5

Check the upgrade summary and click UPGRADE to start the upgrade process.
 

• Step-6

Once the upgrade process completes the process log output is available at <OBIEE_MW_HOME>\Oracle_BI1\upgrade\logs


 

The new rpd will be named as OldPaint_BI001.rpd and placed at the following path:
<OBIEE_MW_HOME>\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository.
As part of upgrade, security is also upgraded from 10g to 11g. This includes the Users and Groups.
Manual customizations to files like instanceconfig.xml are not upgraded and must be redone after upgrade. Same applies for nqconfig.ini, even though the nqconfig.ini parameters are fully controlled from the Enterprise Manager in OBIEE 11g.
 

Hope you will find this article useful during your upgrade process... Please write your feedback to   This e-mail address is being protected from spambots. You need JavaScript enabled to view it .

Read 20449 times