Prerequisites to Setting Up Replication

Each database instance in your distributed installation must use the same release of Oracle Clinical.

In addition, the following replication-specific objects must be in place before you can set up and use replication in your Oracle Clinical installation:

• The Oracle accounts required to set up and perform replication.

• The tables that record each type of replication. The replication types are Global Library, study design, study definition, data, Global Labs, and local labs and ranges.

• The seed number (unique sequence generators).

You already set up these items as part of creating the database.

This section reviews the prerequisites so you can check that your system meets the requirements before you begin the actual replication setup activities.

For more information , see:

• Oracle Accounts for Replication
  
• Tables that Store Replication Information
  
• Seed Numbers for Databases Involved in Replication
  

Oracle Accounts for Replication

When you install Oracle Clinical, the system creates the following accounts for managing and conducting studies in a distributed environment:

See Changing the Password for a Schema or Role Using the SET_PWD Utility

For more information, see:

• RXA_READ Account
  
• RXC_REP Account
  
• RXC_DISC_REP Account
  

RXA_READ Account

Oracle Clinical uses the RXA_READ account for various read-only operations for standard replication. As part of the setup for standard replication, you create a public database link that connects to each of the other database locations as the RXA_READ account.

The RXA_READ account has SELECT privilege on the study design tables and UPDATE privilege on the CLINICAL_STUDY_STATES table.

RXC_REP Account

You use the RXC_REP account to replicate the Global Library, study definitions, study design, data, and labs (Global lab, local labs, and ranges). The RXC_REP account has the following privileges:

• SELECT on all the journal tables; INSERT, UPDATE, and DELETE on some journal tables

• SELECT, INSERT, UPDATE, and DELETE on all replicated tables

• SELECT, INSERT, UPDATE, and DELETE on the following tables:

  • STUDY_REPLICATION_JOBS

  • LAB_REPLICATION_JOBS

• SELECT, INSERT, and UPDATE on the following tables:

  • CLINICAL_STUDY_STATES

  • REPLICATION_TAB

Note:

The password of the RXC_REP account is used when creating database links at other locations. If it is modified, you must recreate the database links at those remote sites.

RXC_DISC_REP Account

Only disconnected replication uses the RXC_DISC_REP account. The RXC_DISC_REP account has the following privileges:

• SELECT on all the journal tables; INSERT, UPDATE, and DELETE on some journal tables

• SELECT, INSERT, and DELETE on all replicated tables

• SELECT, INSERT, UPDATE, and DELETE on the STUDY_REPLICATION_JOBS table

• SELECT, INSERT, and UPDATE on the following tables:

  • DESIGN_REPLICATION_JOBS

  • LAB_REPLICATION_JOBS

  • CLINICAL_STUDY_STATES

• SELECT and INSERT on the REPLICATION_TAB table

Tables that Store Replication Information

The following table lists the tables that Oracle Clinical uses to record information about the execution of each type of replication. The information recorded, which varies from table to table, may include the date and time the replication started, the current status of the replication, and the date and time the replication completed.

Table 12-2 Oracle Clinical Tables that Store Information about Replication

Owner	This Table…	Stores Replication Information About…
RXC	REPLICATION_TAB	Global Library and study definition
RXC	STUDY_REPLICATION_JOBS	Data
RXA_DES	DESIGN_REPLICATION_JOBS	Study design
RXA_LR	LAB_REPLICATION_JOBS	Global labs, labs, and ranges
RXC_DISC_REP	DISCONNECTED_REPL_JOBS	Extracts and loads of the disconnected replication process

Seed Numbers for Databases Involved in Replication

Each database within an installation requires a unique start with value that seeds the internal numbers assigned to generated study objects (DCMs, Validation Procedures, and so on) so they are uniquely identified across all locations.

When you install Oracle Clinical, the Oracle Universal Installer prompts you for a unique starting number (from 1 to 99) for each database to be involved in replication. For information on the installation process, see the Oracle Clinical Installation Guide.