Install the Database Upgrade Script for a LIQUENT InSight 6.2 CHF

Perform the following procedure to update your LIQUENT InSight 6.2 database for each CHF.

The following table lists the Database Upgrade Scripts that need to be used to update your LIQUENT InSight 6.2 database for each CHF. The Certified Hotfix (CHF) Version column identifies to which CHF version each script applies.
File Name Certified Hotfix (CHF) Version Last Modified Build
DB_update6_2_0_chf1_0014.zip LIQUENT InSight 6.2 CHF 1 6.2.0.1.0004

To update the database, perform the following procedure to install each database script in the preceding table:

  1. Extract the .zip file located in the scripts directory of the hotfix.
  2. Edit the define.migration script to fill in the following values:
    SID
    orapath
    dbcommonuser
    dbcommonpass
    dbcommonpath
    password
  3. Use the sqlplus /nolog command to connect to sqlplus from the directory where the .zip file was extracted.
  4. At the sqlplus prompt, run the master_pre.sql by using @master_pre.
  5. At the sqlplus prompt, run the master.sql script by using @master.
  6. Check the log file for errors. If you find errors in the log, contact Technical Support.
  7. Restart your database instance after making these changes.