B.1.2 Updating Oracle BI Presentation Services Catalog

When migrating from 11g, you must manually update your Oracle BI Presentation Services Catalog.

To update the Oracle BI Presentation Services Catalog:

1. Shut down Oracle BI Presentation Services using Oracle Enterprise Manager Fusion Middleware Control.
   See Using Fusion Middleware Control to Start and Stop BI System Component Processes in System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.
2. Back up your existing Oracle BI Presentation Services Catalog by using the 7-Zip utility to create a compressed file.
3. Create a backup copy of the instanceconfig.xml file present at these locations:
   (UNIX) 11g_DOMAIN_HOME/config/OracleBIPresentationServicesComponent/coreapplication_obipsn
   (Windows) 11g_DOMAIN_HOME\config\OracleBIPresentationServicesComponent\coreapplication_obipsn
4. Change the UpgradeAndExit option to true in the instanceconfig.xml file.
   Find the following code:

   <ps:Catalog xmlns:ps="oracle.bi.presentation.services/config/v1.1">
      <ps:UpgradeAndExit>false</ps:UpgradeAndExit>
   </ps:Catalog>
   

   Change it to the following:

   <ps:Catalog xmlns:ps="oracle.bi.presentation.services/config/v1.1">
      <ps:UpgradeAndExit>true</ps:UpgradeAndExit>
   </ps:Catalog>
   

5. Start Oracle BI Presentation Services using the following OPMN command to update the Oracle BI Presentation Services Catalog:
   opmnctl startproc ias-component=coreapplication_obipsn
   Where, n is the instance.
   For example:
   (UNIX) cd ORACLE_INSTANCE/bin
   (UNIX) ./opmnctl startproc ias-component=coreapplication_obips1
   (Windows) cd ORACLE_INSTANCE\bin
   (Windows) opmnctl startproc ias-component=coreapplication_obips1
6. After catalog is updated, edit the instanceconfig.xml file again and change the UpgradeAndExit option back to false.
7. Restart Oracle BI Presentation Services using Oracle Enterprise Manager Fusion Middleware Control.