Create an Oracle Database

If you are upgrading to the new version of Calyx RIM Viewing using an existing database, skip the following database creation procedures.

1. If using Oracle, create a schema (preferably lqtweb). Create lqtadmin user (password = lqtadmin1) with connect and resource rights granted.
   1. For character set, choose AL32UTF8.
   2. For National character set, choose AL16UTF16 - Unicode UTF-16 Universal Character Set.
2. Log on with lqtadmin and run the NewInstall.sql scripts for Oracle scripts using SQLPlus. Use the following procedure to run the scripts using SQLPlus:
   1. Open Command Prompt and set the path to C: drive
   2. Set the database with the command Set ORACLE_SID=<Schema Name>
   3. Connect to SQLPlus and the domain with the command sqlplus / as system database administrator.
   4. Enter the database username and the password
   5. Run the scripts using the command @<scriptpath>