Running HDR Loader Job

You can find the database scripts in $HDR_HOME/ hdr_db/ets/db, if the HDR database is installed using Oracle Universal Installer.

To run a HDR loader job, perform the following:

1. Log in to the database machine as ORACLE_OWNER user and navigate to the $HDR_HOME/hdr_db/ets/db/execute folder.

   Execute the following command:

2. su $ORACLE_OWNER
   

   Use the preceding command if you are not logged in as $ORACLE_OWNER user.

   cd $HDR_HOME/hdr_db/ets/db/execute

   Update the run_ets_loader.sql script with required job arguments.

   Substitute &1 with absolute path of the control file, &2 with the coding scheme name, and &3 with the version name.

3. Log in to the database as sysdba user.

   Execute the following command:

   sqlplus sys@$SID as sysdba
   

   Provide the password when prompted.

4. Execute the following script:

   @ run_ets_loader.sql;
   

   Check the log file and execution report for status.

   The log file is generated when the job starts and the execution report is generated when the job ends. These files are located in the $HDR_HOME/ hdr_db/ets/log folder.