Calyx RIM 6.2 CHF 3 Installation Guide

Upgrade to Calyx RIM 6.2

Verify that you already installed the exact version of a database upgrade script. To determine this, run the following query on your system to compare your installed database scripts to those in the package. Log on to SQLPLUS as System and type select * from aud.version_history.

Note: If you already ran a script, do not run it again.
  1. Copy the database.zip file from the Database Server installation media to the temp directory you created and extract the ZIP file.
  2. Open the define.migration file in Notepad.
  3. 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 setting to the file from this list.
    • define sid=name of the database instance for the existing Calyx RIM database
    • define orapath=database files location

      D:\oracle\oraXX\insight or \apps\oracle\oradata\insight

      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).
    The IDs and passwords are set correctly.
    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=shared
    • define activitipass=activiti
    • define syspass=<enter system password for database being upgraded per step action>
  4. Close and save the modified define.migration file.
  5. Open the command prompt, type: sqlplus/nolog and press Enter.
  6. In the sqlplus prompt, type connect database user/database password@sid and press Enter.
  7. After the connection to database is opened, type @master_pre in the sqlplus prompt and press Enter.
  8. After @master_pre is complete, type @master in the sqlplus prompt and press Enter.
  9. 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.
    Note: In case of errors, refer to the Database Script Error Messages topic.
    D:\install\InSightDBUpgrade1\DBupgrade
  10. Optional Step:
    • Open the define.passwords.alternate file in Notepad and update passwords values if needed. Save and close file.
  11. Optional Step:
    • Open a command prompt and navigate to the newly created database folder.

      For Example: cd D:\Install\InSightDB\database.

    • Connect to the Calyx RIM 6.2 CHF 3 database as system user.
    • At the command prompt type: sqlplus /nolog.
    • At the sqlplus prompt type: @BLD_FINAL_change_passwords.sql.
    Script executes updating passwords to Calyx RIM 6.2 CHF 3 defaults.
  12. At the sqlplus prompt type: exit