Oracle® Business Intelligence Infrastructure Upgrade Guide > Performing an Oracle BI Infrastructure Upgrade > Upgrading the Siebel Analytics Web Catalog to Oracle BI Presentation Catalog >

Upgrading the Web Catalog for Linux or UNIX for Less Than 4000 Users


Follow these steps to convert the Web Catalog on Linux or UNIX to the Presentation Catalog structure when you have less than 4000 Web Catalog users or plan to have less than 4000 Presentation Services users. The steps use mywebcat.webcat as the example name for the Web Catalog.

To upgrade the Web Catalog for Linux or UNIX for less than 4000 users

  1. Copy the existing custom webcat file to the $OracleBIData_HOME/web/catalog directory.
  2. Stop Presentation Services.
  3. Delete the existing default directory in $OracleBIData_HOME/web/catalog.
  4. Change to bash shell and then source saw.sh, which is located in the $OracleBI_HOME/setup directory. This command sets environment variables including ANA_INSTALL_DIR, PATH, LD_LIBRARY_PATH, and JAVA_HOME.

    bash

    source saw.sh

    NOTE:  If you do not source saw.sh before you run the sawmigrate utility, then you might get shared library errors.

  5. Assuming that the name of the Web Catalog is mywebcat.webcat, run the sawmigrate utility, which resides in $OracleBIData_HOME/web/bin from the bash shell:

    sawmigrate $OracleBIData_HOME/web/catalog/mywebcat.webcat

    The sawmigrate utility runs and writes a report to the shell, screen, or console in which the utility was run. The report includes warning and error messages and a list of objects that might have failed to upgrade. The utility creates a directory named mywebcat under $OracleBIData_HOME/web/catalog with shared folders, users, and other catalog objects.

    NOTE:  The upgrade of a large Web Catalog can take several hours to complete (approximately 1 hour per 30MB of catalog data). Killing the sawmigrate process before it completes results in an incomplete upgrade.

Oracle® Business Intelligence Infrastructure Upgrade Guide Copyright © 2007, Oracle. All rights reserved.