OBIEE 10g to OBIEE 11g Upgradation

OBIEE 10g to OBIEE 11g Upgrade

Hi,

      Our client wanted their OBIEE application to be upgraded from OBIEE 10g to OBIEE 11g. For this up-gradation the steps which i have followed has been shared below.

Upgrade Assistant

Upgrade Assistant is the utility to upgrade OBIEE from 10g to 11g which has been installed by default and is located under Oracle fusion middleware home $ORACLE_FMW/bin.

Pre-Requisites:

• 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.
• Enterprise Manager   : http://localhost:7001/em
• Web Logic Server Admin Console: http://localhost:7001/em console
• OBIEE Answers/Dashboard   : http://localhost:9704/analytics 
• All the relevant TNS names used in the 10g rpd connections are present in/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 file which launches the upgrade wizard by double clicking on it.

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 and 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.

• Once you click Upgrade the  process takes place till from Status in Progress changes to Success..

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:<OBIEE_MW_HOME>\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository. 
• As part of upgrade, security is also upgraded from 10g to 11g. This includes the Users and Groups.
• A 11G version of RPD and WebCat will automatically be placed in the right 11G directory and the NQSconfig,INI file will have a proper entry done. There is no need for any manual edition.

There are a few little things we need to do to ensure our 11G environment is ready to run, These changes are typically done once after the upgrade:

Configure the Administrator user account in 11G:

Since 11G has a very different security management system, the Administrator account, which was managed in the Admin Tool in 10G will need to be configured in the weblogic to ensure access using this account. To do so, go to Weblogic console (under 'My realm') and edit the Administrator user by clicking on it:

 Give a new password:

Release Configuration and restart all BI Services and test logging into Web Presentation using this new password. You will be able to log in as Administrator now..Now you have successfully upgraded OBIEE from 10g to 11g...

Hope it Helps!!

Thanks,

Shanmugha Bharathy G B