LIQUENT InSight 6.2 Installation Guide

LIQUENT InSight Oracle Database Setup – Upgrade Installation v6.1 to v6.1 CHF 4

The cycle must be repeated for each script run when migrating your database to the current version. Start at the version of LIQUENT InSight you are running, and run the applicable SQL scripts in the order shown to bring your LIQUENT InSight database up to the current release:

InSight versions: 6.1 > 6.1 CHF 1 > 6.1 CHF 2 > 6.1 CHF 3 > 6.1 CHF 4
Note: For every migration cycle review a migration document applicable for your migration path. All migration documents are available as PDFs in the Data Migration Documents topic.
  1. Based on the version of InSight from which you will be starting the upgrade, execute pre-migration steps if they are defined for your migration path.
  2. Back up your existing Database Server database.
  3. Verify that all users are logged off the InSight system and stop the InSight Manager service.
  4. Based on the version of LIQUENT InSight from which you will be starting the upgrade, note the ZIP files containing the migration scripts that you need to run:
    • DB Upgrade 61 to 61 CHF1
    • DB Upgrade 61 CHF 1 to 61 CHF2
    • DB Upgrade 61 CHF 2 to 61 CHF3
    • DB Upgrade 61 CHF 3 to 61 CHF4
  5. On the computer where you are running the installation script, create as many temporary install directories as needed. The installation script can be run either directly on the database server or remotely from a client running Windows with Oracle’s SQL*Plus installed on it.

    D:\Install\InSightDBUpgrade1

    D:\Install\InSightDBUpgrade2

    D:\Install\InSightDBUpgrade3

    Note: Verify that you are running the Oracle Database installation SQL script on a Windows based computer. If your Oracle Database is hosted by a Unix server, you must run the Oracle Database installation SQL script on a Windows client that can remotely access the database server using Oracle’s SQL*Plus.
  6. Copy and unzip the DB DB upgrade.zip file from the Database Server installation media to the temp directory.
  7. Navigate to the newly created extraction folder.
    cd D:\Install\InSightDBUpgrade1\DBupgrade
  8. Open the define.migration file in Notepad.
  9. Set the value to the right of the equals sign for the following ID or passwords in the define.migration file you are editing.
    Only define the settings from this list that are already present in the define.migration file. Do not add any settings to the file from this list.
    • define sid=name of the database instance for the existing LIQUENT InSight database
    • define orapath=database files location 
    D:\oracle\oraXX\insight or /apps/oracle/oradata/insight

    Default passwords:

    • define audpass=aud
    • define dmpass=dm
    • define ismpass=ism
    • define mgrpass=mgr
    • define odspass=ods
    • define secpass=sec
    • define migrationpass=migration
    • define jmsadminpass=jmsadmin
    • define sharedpass=sgared
    • define activitipass=activity
    • define syspass=<enter system password for database being upgraded per step action>
    Note: To prevent connection errors when modifying database execution scripts, because the @ symbol is a value in the Oracle database connection string, enter database passwords containing the character @ using quotes.
    Password abc@123 should be entered as '"abc@123"' (single quotes, double quotes, password, double quotes, single quotes).
  10. Close and save the modified define.migration file.
  11. Open the command prompt from the directory where the .zip file was extracted. In the command prompt:
    1. Type sqlplus/nolog.
    2. Press Enter.
  12. At the SQL> prompt, type connect database user/database password@sid and press Enter.
    • After the connection to the database is established, at the SQL> prompt, type @master_pre and press Enter.
    When the SQL script begins, you are returned to the sqlplus prompt.
  13. After master_pre is completed, at the SQL> prompt type @master and press Enter.
  14. From the command prompt type sqlplus/nolog. At the sqlplus prompt type @master.sql.
    The upgrade process starts and you are returned to the sqlplus prompt.
  15. Once the script is complete, check the database log file for errors. This file is generated in the directory where the build script was executed, and should be found in the same directory created previously.
    D:\install\InSightDBUpgrade1\DBupgrade
    Note: In case of errors, refer to the Database Script Error Messages topic.
  16. Based on the version of LIQUENT InSight from which you will be starting the upgrade, execute post-migration steps if they are defined for your migration path.