Migration of BI Publisher Reports

Migrating 10g to 11g BI PUBLISHER

The Following are the below steps in-order to migrate the BI Publisher reports from 10g to 11g.Copy  the 10g reports repository and restore  it to some location in the current system where BI Publisher 11g is Installed.

• Take a backup of the BI 11g Repository by going into the following location.
• mv  $ORACLE_HOME/user_projects/domains/bitest_domain/config/bipublisher  bipublisher_ORG
• Running the Upgrade wizard by going into the following location
•   Cd  $ORACLE_HOME/Oracle_BI/bin
• $ ./ua
• Click on Next
• Select  à  Upgrade Oracle BI Publisher Repository and click on next.
• Select  à  Upgrade 10g BI Publisher Repository Directory and click on next.
• Provide the 10g reports repository location which is copied and stored in the current system.
• /rtmrap/bi10greports_repos/XMLP
• Enter the destination 11g BI Publisher Repository Directory and click on next. Provide the 11g reports repository location  /rtmrap/bi_weblogic/middleware_home/user_projects/domains/bitest_domain/config/bipublisher/repository
• Enter the weblogic Admin Server Connections details 
• UserName       :   biweblogic
• Password        :   biweblogic1
• Click on Next
• Click on Finish
• 
  
• After completing the upgrading steps restart the weblogic domain and managed server.
• To Start the BI Core application go the following location and execute the below command.
• Cd  $ORACLE_HOME/instance/bi_inst1/bin
• ./opmnctl  startall
• ./opmnctl status
• After re-bouncing the BI domain & Managed Server. Login into the BI Publisher application and go the following location
• Click on Administration tab
• Select Server Configuration
• Select Catalog Type :  Oracle BI EE Catalog
• Specify the BI Publisher repository location
• For ex:/rtmrap/bi_weblogic/middleware_home/user_projects/domains/bitest_domain/config/bipublisher/repository
• Click on Upload to BI Presentation Catalog
• Restart the BI domain, Managed Server & core application.
• After re-bouncing the weblogic domain, login into the bi publisher application.
• In-order to view the reports
• Go the catalog and select the respective folder to view the reports.