Perform Database Post-Installation Tasks

Note:

To perform the required changes done for PDR hyperlinks during DCI form version generation, follow the instruction in Doc ID 2763299.1 on My Oracle Support.

This section describes the following tasks for completing the installation of your Oracle Clinical database:

• Set the Database Time Zone
  
• Pin Database Packages
  
• Consider Implementing Partitioning
  

Set the Database Time Zone

The Oracle Clinical Remote Data Capture Onsite (RDC Onsite) application uses the dbtimezone value for internal calculations when the Display timestamps in local timezone preference is set.

Oracle recommends setting time zone to a named location rather than a numeric offset so that standard and daylight time adjustments are made automatically.

You can find valid named location strings in the V$TIMEZONE_NAMES view. For example, to find a time zone in the United States, enter the following query:

SELECT distinct tzname
  FROM V$TIMEZONE_NAMES
  WHERE tzname like 'US/%'

To set the time zone in the database:

1. Connect to the database as any user that has ALTER DATABASE privileges.
2. Enter the following command:

   alter database set time_zone='tzname_value’;

   For example:

   alter database set time_zone='US/Eastern’;

Pin Database Packages

To improve performance, some of Oracle Clinical's packages are pin-able packages. Pinning allocates a stable memory location so that a package cannot be subjected to being swapped out of memory. Oracle Clinical provides the rxcdbinit.sql script to pin the database packages.

To pin the database packages located on a UNIX server:

1. Log in to the UNIX server computer as the opapps user.
2. Set the UNIX environment:

   opa_setup database_name code_environment

3. Change to the RXC_INSTALL directory:

   cd $RXC_INSTALL

4. Connect to SQL*Plus as the rxc user:

   sqlplus rxc/password

5. Run the rxcdbinit.sql script:

   start rxcdbinit.sql

   The script pins the database packages and exits upon completion.

   Note:

   You must rerun this script each time you restart the database. Consider creating an entry in the database startup script that runs rxcdbinit.sql automatically.

Consider Implementing Partitioning

1. Partition the Oracle Clinical RESPONSES table, which contains all patient data entered for all studies in an Oracle Clinical installation.

   See the Oracle Clinical Administrator's Guide for more information.