B.1.2 Updating Oracle Business Intelligence Catalogs

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

To update the Oracle BI catalog:

1. Shut down Oracle BI Presentation Services using the Fusion Middleware Control.
   For more information, see Using Fusion Middleware Control to Start and Stop BI System Component Processes in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.
2. Back up your Release 10g catalogs by using the 7-Zip utility to create a compressed file.
3. Create a backup copy of the instanceconfig.xml file. The instanceconfig.xml file is located at the following location:
   On UNIX operating system:
   $DOMAIN_HOME/config/OracleBIPresentationServicesComponent/coreapplication_obipsn
   On Windows operating system:
   %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 catalogs:
   opmnctl startproc ias-component=coreapplication_obipsn
   Where, n is the instance.
   For example:
   On UNIX operating system:
   cd ORACLE_INSTANCE/bin
   ./opmnctl startproc ias-component=coreapplication_obips1
   On Windows operating system:
   cd ORACLE_INSTANCE\bin
   opmnctl startproc ias-component=coreapplication_obips1
6. After the catalogs are updated, edit the instanceconfig.xml file again and change the UpgradeAndExit option back to false.
7. Restart Oracle BI Presentation Services using the Fusion Middleware Control.