1. Administrator's Guide
  2. Routine Server Administration
  3. Updating Oracle Clinical Seed Data

Updating Oracle Clinical Seed Data

If you run the Installer to create or upgrade an Oracle Clinical database, the Installer places the correct seed data in that database. If, however, you upgrade an existing Oracle Clinical database manually, you must also upgrade the seed data manually.

To upgrade Oracle Clinical seed data manually:

  1. Set the environment variables as follows (for details, see Environment Variables and Registry Settings): 

    opa_setup database code_environment
    Variable Description

    ORACLE_SID

    set to the name of the database

    ORACLE_HOME

    set to your desired Oracle home directory

    PATH

    make sure oracle_home/bin is in your PATH variable

  2. Collect the passwords for OPA and RXC.

  3. From the install directory,  run the script loadseed.sql: 

    SQLPLUS RXC/password@database
loadseed.sql

  4. Enter responses for the loadseed.sql prompts: 

    Enter the password for OPA: opa_password
Enter the password for RXC: rxc_password
Enter product code (OC or TMS): OC

Parent topic: Routine Server Administration