Installing Oracle XML DB component

You need to install Oracle XML DB component to store XML documents in the database.

About this task

The Oracle XML DB component is required for IBM® Product Master. This component enables the efficient processing and storage of XML documents in the database. You can perform these steps for manually installing this component. You can also use Oracles database configuration assistant for installation. For more information, see Administering Oracle XML DB.

Procedure

  1. Change directory to $ORACLE_HOME/rdbms/admin in the Oracle Database server.
  2. Log on to SQLPlus by using SYS or SYSDBA user sqlplus "/as sysdba"
  3. Run the catqm.sql script with the following parameters:
    • xdb_password is the password for XML DB repository.
    • xdb_ts_name is the table space to use for Oracle XML DB, it must be XML_DATA
    • temp_ts_name is the temporary table space, example TEMP
    • secure_file_for_repo is NO (if you want to use SecureFile LOB then XML_DATA table space can use Oracles Automatic Storage Management).
    For example,
    @catqm.sql pass4xdb XML_DATA TEMP NO
  4. Ensure that XML DB installation is successful.
    Note: XML DB protocol access is not required for Product Master.
  5. In the Oracle initialization parameter file, add the following parameter or ensure that the existing value for the compatible parameter is 11.2.0.1. Restart Oracle after changing the parameter value to compatible = 11.2.0.1.