Validate the Schema

1. Navigate to Database > DBInstaller > SM_ValidateSchema.
2. Run the batch script validate_schema.bat.
3. When prompted, enter the following parameters:
   • Enter instance name: <Argus Mart Database Instance name>
   • Enter DBA User Name: <Install user> of Oracle Argus Mart
   • Enter Password for DBA User: <Install user password> in Oracle Argus Mart>
   • Enter Validation Data File Name: The validation control file name:

     <VLDN_AM_8.2.2.CTL>

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

     <C:\AM_822\Database\DBInstaller\SM_ValidateSchema>

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

     <VLDN_AM_8.2.2_diff.log>

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

     <VLDN_AM_8.2.2_out.log>

4. When the validation process is complete, a confirmation message appears.
   • 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 Mart read-only user is created, then ignore the schema validation differences, where

• Objects are RO% views/columns
• GRANTEE is Oracle Argus Mart Read-only user