Upgrading the Oracle BI Repository from 10g to 11g.

To upgrade the OBIEE 10g repository and presentation catalog, perform the following steps by using the Upgrade Assistant utility. Please note that the Weblogic Administration Server and the Managed Server in the 11g environment must remain running during the upgrade process.

1) Navigate to the ORACLE_HOME\Oracle_BI1\bin directory of the Oracle Fusion Middleware installation. In this example, the directory path is C:\obi11g\Oracle_BI1\bin

2) Double-click ua.bat to open Upgrade Assistant in the graphical user interface mode. This tutorial describes how to use Upgrade Assistant in the graphical user interface mode. You can also use the Upgrade Assistant command line to perform these tasks.

Step 1. On the Welcome screen, click Next.

Step 2. On the Specify Operation screen, select Upgrade Oracle BI RPD and Presentation Catalog and click Next.

Step 3. On the Specify Source Details screen, select Upgrade Repository (RPD).

• Click Browse next to the RPD File field.
• Browse to the location of the 10g version of the Sample Sales repository and click Open. 
• The path to ABC.rpd is added to the RPD File field.
• Enter the Administrator User Name and Administrator Password for the 10g ABC repository. In this example, the username and password are both Administrator.
• Enter and confirm a password that will be used to secure the upgraded 11g repository. This password is required for 11g repositories. It does not have to match the 10g repository password or any other password. In this example, the password is Admin123
• Click Next to continue.

Step 4. On the Specify Weblogic Server screen, enter the Weblogic Admin Server port number. Typically the port number is 7001.