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
Parent topic: Install Oracle Clinical Database Components on UNIX
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:
Parent topic: Perform Database Post-Installation Tasks
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:
Parent topic: Perform Database Post-Installation Tasks
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
Parent topic: Perform Database Post-Installation Tasks
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:
Parent topic: Set Up Disconnected Replication (Optional)
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.
Parent topic: Set Up Disconnected Replication (Optional)
Add Reference Codelist Value
In the OCL_STATE reference codelist:
- Add a value called DISC_REP_WALLET. See the Oracle Clinical Administrator's Guide for more information.
- Enter the wallet_alias you just created as the long value.
Parent topic: Set Up Disconnected Replication (Optional)