Validate the Schema

1. Navigate to Argus Release Media\Database\ArgusInsight\ValidateSchema.
2. Run the batch script validate_schema.bat.
3. When prompted, enter the following parameters:
   • Enter instance name: <Oracle Argus Insight Database Instance name>
   • Enter DBA User Name: <DBA user of Oracle Argus Insight>
   • Enter Password for DBA User: <DBA User password in Oracle Argus Insight>

   • Enter Validation Data File Name: The validation control file name:

     <VLDN_APR_AI_8.2.3.CTL>

   • Enter the destination where the log file is to be placed:

     Argus Release Media\Database\ArgusInsight\ValidateSchema

   • Enter the log file name for recording the schema differences:

     <VLDN_APR_AI_8.2.3_diff.log>

   • Enter Validation Output File Name: The validation output file name to record the validation progress:

     <VLDN_APR_AI_8.2.3.log>

4. Enter the password for the Oracle Argus Insight SYSTEM or DBA user, and press Enter.
5. When the validation process is complete, a confirmation message appears.

   The log files are created at the following location:

   Argus Release Media\Database\ArgusInsight\ValidateSchema\

   • To view any schema discrepancies, such as missing objects, use the Difference Log File.
   • To view the list of errors, which occurred during schema validation, use the Output Log File.

Note:

• If Oracle Argus Insight read-only user is created, then ignore the schema validation differences, where
  • Objects are RO% views/columns
  • GRANTEE is Oracle Argus Insight Read-only user
• If Oracle Argus Insight and Oracle Argus Mart are installed on the same Database server, ignore the differences due to grants from APR_MART/RLS_USER of Oracle Argus Insight to AM_MART_USER/AM_APP_USER of Oracle Argus Mart.