Data Migration Documentation

Installing the Database Upgrade

The database upgrade is installed by executing the supplied master.sql script either directly on the database server or remotely from a client running Windows with Oracle's SQL*Plus installed on it. Additionally, we recommend that you run the supplied stats.sql script to refresh Calyx RIM's database statistics.

To install the database upgrade:
  1. Back up your existing Calyx RIM Database Server database.
  2. Verify that all users are logged off the Calyx RIM system.
  3. Stop the Calyx RIM Manager service on the Calyx RIM application server:
    1. Choose Start > Administrative Tools > Services.
    2. Double-click the Calyx RIM Manager service.
    3. In the Calyx RIM Manager Service Properties dialog box, click Stop and then click OK.
  4. Based on the version of Calyx RIM from which you will be starting the upgrade, determine each of the ZIP files containing the migration scripts that you need to run.
    The list of ZIP files is provided in the Calyx RIM Database Migration Details topic. You must repeat this database upgrade procedure for each script to be run.
  5. On the computer where you are running the installation script, create as many temporary install directories as needed, according to the ZIP files determined in step 4.
    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.

    Example - D:\Install\Calyx RIMDBUpgrade1 D:\Install\InSightDBUpgrade2 D:\Install\InSightDBUpgrade3

  6. 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.
  7. Copy the ZIP file from the Calyx RIM database server installation media to the appropriate temp directory created in step 5, and then unzip the ZIP file to this directory.
  8. Navigate to the newly created folder.
    Example - D:\Install\InSightDBUpgrade1\DB Upgrade xx to yy.
  9. Open the define.migration file in Notepad.
  10. 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 Calyx RIM database
    • define audpass=password for the AUD user
    • define dbopass=password for the DBO user
    • define ismpass=password for the ISM user
    • define odspass=password for the ODS user
    • define pubpass=password for the PUB user
    • define secpass=password for the SEC user
    • define syspass=password for the Oracle system
    • define sysuser=ID of the Oracle administrative user. The default Oracle administrative user ID is sys.
    • define orapath=the directory location for the database data files. Example - C:\oracle\oraXX\insight or \apps\oracle\oradata\insight
    • define sec_user=ID of the SEC user
    • define ods_user=ID of the ODS user
    • define jmsadminpass=s98$h32* (s98$h32* is the default password, but it can be modified.)
    • define quartzpass=password for the QUARTZ user (Last used in Calyx RIM version 2.2. Use for migration only, if necessary.)
    • define mgrpass=mgr (
      Note: leave as default
      )
    • define migrationpass=r45$x*94 
    • To prevent connection errors when modifying database execution scripts, enter database passwords containing the character @ using quotes. Example - password abc@123 should be entered as '"abc@123"' (single quotes, double quotes, password, double quotes, single quotes)

    Default Passwords

    • · define audpass='"i73%r49^"'
    • · define dbopass='"h01%q34@"'
    • · define ismpass='"f78#o98*"'
    • · define odspass='"e45!n65("'
    • · define secpass='"g01$p34)"'
    • · define pubpass='"r74$i64*"'
    • · define jmspass='"s98$h32*"'
    • · define insight_userpass='"uv5~hi9%"'
  11. Save and close the modified define.migration file.
  12. Open a command prompt and navigate to the newly created folder.
    Example– cd D:\Install\InSightDBUpgrade1\DB Upgrade xx to yy.
  13. At the command prompt enter sqlplus /nolog. Ensure that the forward slash (‘/’) character is included when the above statement is input.
  14. At the sqlplus prompt, enter @master.sql.
    Once the database upgrade process completes successfully, you are returned to a sql> prompt.
  15. Check for errors in the <DB script name>.log file generated for this update. This file is generated in the directory where the script was executed, and should be the same directory created in step 7.
  16. 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, repeat the procedure from step 8 and correct the password values in step 9.
  17. Repeat the procedure from step 6 for each migration script you need to run.
  18. At the sqlplus prompt, enter Exit.
  19. At the command prompt, enter Exit.
    A script named stats.sql is included in each database upgrade zip file for the purpose of refreshing database statistics after the migration script has been executed. Your DBA can refresh database statistics either using this script or your own in-house utilities.