Upgrading from 10g to 11g (Repository and Webcat)

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;

  1. 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.
  2. 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.

Author: Daan Bakboord

I am an Oracle Business Analytics Consultant with great interest in anything closely related to the Oracle Business Analytics (OBIEE, BICS, Big Data, Data Integration, Data Visualization) .

2 thoughts on “Upgrading from 10g to 11g (Repository and Webcat)”

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s