Tuesday, 20 March 2012


OBIEE 10g to 11g Upgrade Wizard

OBIEE 10g to 11g Upgrade Assistant Wizard....


• 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( 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:
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.

Blog Archive

About Authors

Shahed Munir

Krishna Udathu

Shahed and Krishna are Oracle / Big Data Experts