Perform Database Post-Installation Tasks

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

• Set the Database Time Zone
  
• Pin Database Packages
  
• Set Up Disconnected Replication (Optional)
  
• 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.

Set Up Disconnected Replication (Optional)

Do the following only if you plan to use disconnected replication:

• Check the Tablespace Size
  
• Create a Wallet Credential for the RXC_DISC_REP Database User
  
• Test Wallet Connection for RXC_DISC_REP
  
• Add Reference Codelist Value
  

Check the Tablespace Size

Installing Oracle Clinical creates the RXC_DISC_REP user account to manage disconnected replication. DISC_REP_DATA is the default tablespace for RXC_DISC_REP.

If you use disconnected replication:

1. Increase the size of the DISC_REP_DATA tablespace to fit the amount of replicated data.

   For more information about disconnected replication, see the Oracle Clinical Administrator's Guide.

Create a Wallet Credential for the RXC_DISC_REP Database User

The system stores these credentials in the same Wallet as the one created for OCPSUB.

1. Log in as opapps.
2. Set environment variables:

   opa_setup database_name 522
   

3. Create an alias for the disconnected replication wallet alias in tnsnames.ora. The disconnected replication wallet alias is the name of the database appended with:

   _disc.

   For example, if the database name is ny123x, the tnsnames entry would look something like:

   ny123x, ny123x_disc, ny123x.world, ny123x.domain.com =  (DESCRIPTION=
       (ADDRESS=(PROTOCOL=tcp)(HOST=myhost.us.example.com)(PORT=1124))
       (CONNECT_DATA=(service=ny123x))
   

   See Modify the tnsnames.ora File on the Database Server.

4. For the disconnected replication wallet alias, enter tnsping wallet_alias to test that it returns success. For example:

   tnsping ny123x_disc
   

5. Create the credentials for the disconnected replication wallet alias and account.

   mkstore -wrl /pharm/home/opapps/wallet522 -createCredential wallet_alias rxc_disc_rep rxc_disc_rep_password
   

Test Wallet Connection for RXC_DISC_REP

1. Set tns_admin:

   setenv  TNS_ADMIN path_of_sqlnet.ora
   

2. For the disconnected replication wallet alias run sqlplus /@wallet_alias. for example:

   sqlplus /@ny123x_disc
   

   The connection should be a success.

3. Run show user

   This should display the rxc_disc_rep user.

Add Reference Codelist Value

In the OCL_STATE reference codelist:

1. Add a value called DISC_REP_WALLET. See the Oracle Clinical Administrator's Guide for more information.
2. Enter the wallet_alias you just created as the long value.

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.