LIQUENT InSight Database Setup – New Installation

If you are upgrading from an existing version and not performing a new installation, go to section LIQUENT InSightOracle Database Setup - Upgrade Installation.

  1. On the computer where you are running the installation script, check the system registry to verify it is set to AL32UTF8.

    Under - HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb12C_home1\NLS_LANG

    AMERICAN_AMERICA.AL32UTF8

    Note: KEY_OraDb12C_home1 name might be different based on the computer you are running the installation script from and also the version of Oracle installed.
  2. On the computer where you are running the installation script, create a temporary install directory.
    The installation script can be run either directly on the database server or remotely from a client running Windows with Oracle SQL*Plus installed on it.
    D:\Install\InSightDB
    1. For remotely running the script, change the listener.ora file:
      SID_DESC = (GLOBAL_DBNAME = <dbName>)(ORACLE_HOME = D:\oracle\product\12.*.*\dbhome_1)(SID_NAME =<dbSID>)
    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.
  3. Copy the database.zip file from the Database Server installation media to the temp directory you created, and extract the ZIP file into that directory.
  4. Open a command prompt and navigate to the newly created database folder.
    cd D:\Install\InSightDB\database
  5. At the command prompt type: sqlplus /nolog
    • Ensure that the forward slash (/) character is included when the above statement is input.
    • The build.sql script can be run by the system user only from the sql prompt.
  6. Open the file define.install in Notepad from the newly created database folder.
  7. Enter correct values for the specified parameters:
    • define sid=dbSID
    • define syspass=*syspass*
    • define sysuser=system user
    • define orapath=path of DB Instance location
  8. At the sql> prompt type: @build.sql
    The build process starts and the sid prompt appears.
  9. After the script is complete, check the buildlog.lst for errors. This file is generated in the directory where the build script was executed, and should be in the same directory previously created.
    D:\Install\InSightDB\database
    There should be no errors on the log except for those relating to:
    • Dropping indexes that do not exist
    • Dropping roles that do not exist
    • Dropping users that do not exist
    • Dropping/deleting tablespaces that do not exist
    • Connect errors that occur at the beginning of the script as attempts are made to connect as users that do not exist.
    Note: All database passwords are validated at the beginning of the migration script. If you received the error message ORA-01017: invalid username/password; logon denied and the script terminates without connecting, correct the password values that you defined.
  10. Close the command prompt.
Next topic: LIQUENT InSight Oracle Database Setup – Upgrade Installation v6.1 to v6.1 CHF 4
Previous topic: Prerequisite Installation Procedure
Related tasks
Related reference

© 2000-2021 PAREXEL International Corporation and its affiliates. All rights reserved.