Upgrading the Oracle BI Repository and Catalog

To upgrade the Sample Sales repository and presentation catalog, perform the following steps by using the Upgrade Assistant. 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\bin directory of the Oracle Fusion Middleware installation. In this example, the directory path is D:\bi\Oracle_BI1\bin.

2. Double-click ua.bat to open Upgrade Assistant in the graphical user interface mode. Refer screen shot:

3. On the Welcome screen, click Next.

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

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

6. Click Browse next to the RPD File field.

7. Browse to the location of the 10g version of the Sample Sales repository and click Open. In this example, the path is D:\SampleSales\samplesales.rpd.

 8. Enter the Administrator User Name and Administrator Password for the 10g samplesales repository. In this    example, the username and password are both Administrator.

9. Enter new password for rpd which doesn't match with the previous 10g rpd password.

10. Select Upgrade Catalog.

11. Browse to the location of the 10g version of the Sample Sales presentation catalog and click Open. In this example  the path is D:\SampleSales\Sample_Sales_V1.3_Webcat\samplesales.

12. The path to the Sample Sales presentation catalog is added to the Catalog Directory field. The path to  the deliveries directory is automatically added to the Catalog Deliveries Directory field.

13.Enter the weblogic admin server details. Port number, user name and password. 

14. Click Next to continue. On the Examining Components screen, wait until you see a succeeded message. During the examination process, Upgrade Assistant checks whether the source directory exists, the source directory is readable, and contains a file for upgrade.

15. Click Next to continue. On the Upgrade Summary screen, review the summary of the upgrade to be performed.

16. Click Next to continue. When the upgrade completes the status changes to succeeded.

17. Click Next to continue. n the Upgrade Success screen, review information related to the upgrade task and  click Close.

             In this way have upgraded rpd and catalog to 11g. Comment if it is helpful and keep visiting  for new posts.

Thanks....!!