B Loading Metadata into the Database

You must load certain metadata into your database by completing the following steps:

1. As appropriate for the operating system of the machine hosting your Oracle Identity Manager server, edit either LoadXML.bat or LoadXML.sh located in <PATCH>/db/Utilities/, and update the JAVA_HOME variable.

2. As appropriate for your database and operating system of the machine hosting your Oracle Identity Manager server, complete one of the following sub-steps:

   SQL Server:

   1. Launch a plain-text editor, open the file LoadXML.bat, and uncomment the following line:

      REM SET SQL_SERVER_DRIVER_DIR=
      
      

   2. Assign the path to the SQL Server driver directory that contains the msbase.jar, msutil.jar and mssqlserver.jar files:

      SET SQL_SERVER_DRIVER_DIR=<PATH_TO_SQL_DRIVER>
      
      

   Oracle on Windows:

   1. Launch a plain-text editor, open LoadXML.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=<XL_HOME>\xellerate\ext
      
      

   Oracle on UNIX and Linux:

   1. Launch a plain-text editor, open LoadXML.sh, then uncomment the following lines:

      #ORACLE_DRIVER_DIR=#export ORACLE_DRIVER_DIR
      
      

   2. Assign the path to the JDBC driver for Oracle, so that the line reads something like the following:

      ORACLE_DRIVER_DIR=<XL_HOME>/xellerate/ext
      export ORACLE_DRIVER_DIR
      
      

3. Open a command prompt or console and run the <PATCH>/db/Utilities/LoadXML.bat or LoadXML.sh script with the following command line parameters in the specified order for the type of database you are using:

   Oracle:

   1. JDBC URL (for example: jdbc:oracle:thin:@<db_host_ip>:<port>:<SID>)

   2. Database user name

   3. Password

   SQL Server:

   1. JDBC URL (for example: jdbc:microsoft:sqlserver://<ipaddress>:<port>)

   2. Database name

   3. Database user name

   4. Password