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:
-
Set the environment variables as follows (for details, see Environment Variables and Registry Settings):
opa_setup
databaseVariable 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
-
Collect the passwords for OPA and RXC.
-
From the install directory,  run the script loadseed.sql:
SQLPLUS RXC/password
@
databaseloadseed.sql
-
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