When I had installed the Oracle BI 11g R1 version, I thought it would be nice to see what happened when I migrate a simple 10g Repository and Catalog to 11g.
Migrating from 10g to 11g seems very straight forward.
Navigate to <MIDDLEWARE_HOME>\Oracle_BI1\bin\ and start ‘ua.bat’
You are presented with the following screens fill in the required values according to your site’s needs;
click ‘Next’
Choose to upgrade the RPD and the Presentation Catalog.
click ‘Next’
Choose the location of the RPD file you want to migrate.
Fill in the credentials
In 11g you have to provide an additional password for your RPD.
Fill in the credentials
Choose the location of your catalog
Choose the Deliveries directory
click ‘Next’
Provide the details (port and credentials) of your Weblogic server
click ‘Next’
If everything has been provided well so far the status will be ‘succeeded’
click ‘Next’
The summary shows the details. Now you are ready to upgrade.
click ‘Upgrade’
If everything runs like expected, the status will be ‘succeeded’
click ‘Next’
You are finished.
click ‘Closed’
For some more/other details, please refer to Venkat’s post.
You can now check the ‘Enterprise Manager’. There you will see that the newly created Repository and Catalog are ‘active’.
In the end it seems that most of the functionality has been migrated succesfully to 11g. Two ‘major’ problems I experienced immediately;
- I used some custom folders in 10g. In 11g you have to take some additional steps to make custom folders available. I will cover this topic in a next post.
- I used a ‘Narrative View’ with; ‘ ‘. This doesn’t work for all HTML Markup. It does work in the ‘Static View’. I do not have a solution for that yet.
DaAnalytics Blog 
2 thoughts on “Upgrading from 10g to 11g (Repository and Webcat)”