Upgrading the Presentation Catalog

Use these instructions to upgrade the Presentation Catalog using the Upgrade Metadata Tool.

To upgrade the Presentation Catalog:

1. Take a back-up of the Presentation Catalog.
2. Create a writable directory where logs will be stored.

   For example, C:\Webcat_Upgrade or WORKDIR_HOME/ Webcat_Upgrade.

3. Run the following command to upgrade the Presentation Catalog:

   <BI_Oracle_Home>/jdk/jre/bin/java -cp <BI_Oracle_Home>/biapps/patch/biappspatch.jar oracle.as.biapps.patch.update.UpdateBIAppsMetadata bi.oracle.home=<BI Oracle Home> bi.admin.url=<BI EM Admin URL> bi.admin.username=<bi EM Admin User> bi.admin.password=<BI EM Admin User Password> only.apply=webcat log.file=<Work dir>/webcat.log log.level=INFO work.dir=<writable work dir path>
   

   Example:

   /Middleware_Home/Oracle_BI1/jdk/jre/bin/java -cp /Middleware_Home/Oracle_BI1/biapps/patch/biappspatch.jar oracle.as.biapps.patch.update.UpdateBIAppsMetadata bi.oracle.home=/Middleware_Home>/Oracle_BI1 bi.admin.url=http://host:7001 bi.admin.username=weblogic bi.admin.password=password only.apply=webcat log.file=/WORKDIR_HOME/Webcat_Upgrade/webcat.log log.level=INFO work.dir=/ WORKDIR_HOME/Webcat_Upgrade
   

   The password is prompted after the process is started.

   
   Description of the illustration GUID-D7687A6C-4584-4758-8720-7ECFF2822BAB-default.gif

   Optional Parameters:

   • log.level - default is INFO. Valid values are FINEST, FINE, INFO, WARNING, SEVERE.

4. Restart all BI processes using Oracle Process Manager and Notification Server (OPMN).
5. It is recommended to update GUIDS in OBIEE.