A Loading Report Metadata Into the Database

You must load the metadata into the database by running the LoadXML or LoadXML_XACM utilities. The utility must be run after running oim_db_upg_9032_to_9100.bat or oim_db_upg_9032_to_9100.sh.

To load metadata into the database:

1. As appropriate for the operating system on the Oracle Identity Manager host computer, edit either LoadXML.bat or LoadXML.sh (LoadXML_XACM.bat or LoadXML_XACM.sh) located in the PATCH/db/Utilities/ directory, and set the JAVA_HOME variable to the directory on which Java is installed.

   Note:

   Run the LoadXML script if Oracle Identity Manager is installed without the Audit and Compliance module, and run the LoadXML_XACM script if Oracle Identity Manager is installed with the Audit and Compliance module.

2. As appropriate for the database and operating system of the computer hosting Oracle Identity Manager, perform the following steps:

   For Oracle Database on Microsoft Windows:

   1. In a text editor, open LoadXML.bat (or LoadXML_XACM.bat), and uncomment the following line:

      REM SET ORACLE_DRIVER_DIR=
      

   2. Assign the path to the Oracle driver directory containing the Oracle JDBC drivers:

      SET ORACLE_DRIVER_DIR=PATH_TO_ORACLE_DRIVER
      

   For Oracle Database on UNIX:

   1. In a text editor, open LoadXML.sh (or LoadXML_XACM.sh), and uncomment the following lines:

      #ORACLE_DRIVER_DIR=#export ORACLE_DRIVER_DIR
      

   2. Assign the path to the JDBC driver for Oracle, as shown:

      ORACLE_DRIVER_DIR=PATH_TO_ORACLE_DRIVER
      export ORACLE_DRIVER_DIR
      

3. From a command prompt, run the PATCH/db/Utilities/LoadXML.bat or LoadXML.sh script (LoadXML_XACM.bat or LoadXML_XACM.sh if you are using Oracle Identity Manager with the Audit and Compliance module).

   The command-line usage of the LoadXML and LoadXML_XACM scripts for Oracle Database are as shown:

   LoadXML JDBC_URL DB_USERNAME DB_PASSWORD
   LoadXML_XACM JDBC_URL DB_USERNAME DB_PASSWORD
   

   When you run the LoadXML or LoadXML_XACM command:

   • Replace JDBC_URL with the JDBC URL, for example, jdbc:oracle:thin:@DB_HOST_IP:PORT:SID.

   • Replace DB_USERNAME with the database user name.

   • Replace DB_PASSWORD with the database password.