Liquent InSight Rendering 4.4 Installation Guide

First Time Installation Table Creation

  1. On the computer where you are running the installation script, create a temporary install directory, for example C:\Install\IRDB.
  2. From the Liquent InSight Rendering installation media, copy every file from the EnterpriseServices\Common\Liquent\Database folder to the temporary install directory.
  3. Use a text editor to edit the define.install file to define the orapath variable as the locations of the database tables on the Oracle database server.
  4. Save and close the file.
  5. Use a text editor to edit the define.passwords file to define the vistapass variable as the password of the new vista1 user that is used to connect the Liquent InSight Rendering server to the database.
  6. Save and close the file.
  7. Open a Command Prompt window and do the following:
    1. At the command prompt, enter: sqlplus /nolog.
    2. At the SQL> prompt, enter: connect system/<system password>@<SID>.
      The command prompt returns Connected and then SQL>.
    3. Enter @ followed by the complete file path to the customized SQL script.
      For example, @”C:\Install\IRDB\Oracle-repositoryINSTALL.sql”.
      The SQL script runs and the SQL> prompt is returned when the script completes.
      Note: It is normal to receive ORA-01418: specified index does not exist errors since the script is trying to delete indexes that do not exist.
    4. Enter exit to close the sqlplus connection.
  8. To test the connection to the database for the vista1 user, do the following:
    1. At the command prompt, enter sqlplus /nolog
    2. At the SQL> prompt, enter connect vista1/<new vista1 password>@<SID>
    3. Confirm that the connection is successful.
  9. Enter Exit to close the sqlplus connection.
  10. Enter Exit to close the Command Prompt window.