Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Finding Information and Patches on My Oracle Support
• Finding Documentation on Oracle Technology Network
• Related Documents
• Oracle CPU Security Update Patches
• Conventions

1 Preparing to Install Oracle Clinical

• 1.1 About the Oracle Clinical Network Architecture
• 1.2 Choosing a Character Set
• 1.3 Planning an Oracle Clinical Database Tier Installation
  • 1.3.1 Database Tier Operating System Requirements
  • 1.3.2 Database Tier Character Set Requirements
  • 1.3.3 Database Tier System Resource Requirements
  • 1.3.4 Prerequisite Tasks for Oracle Database 11g
  • 1.3.5 UNIX Database Server Requirements
    • 1.3.5.1 X Window System Capability
    • 1.3.5.2 Compatibility with Oracle9i Database on UNIX Database Servers
    • 1.3.5.3 C Run-time Libraries on UNIX Database Servers
  • 1.3.6 Windows Database Server Requirements
    • 1.3.6.1 Compatibility with Oracle9i Database on Windows Database Servers
    • 1.3.6.2 Access on Windows Platforms
    • 1.3.6.3 Windows Database Server Requires Separate Oracle Home
  • 1.3.7 Oracle Database 11g Requirements
    • 1.3.7.1 Required Reading
    • 1.3.7.2 Oracle Text Option
    • 1.3.7.3 Oracle Database 11g Partitioning Option
  • 1.3.8 Global Library Location
  • 1.3.9 Database Seed Numbers in a Replicated Environment
• 1.4 Planning an Oracle Clinical Application Tier Installation
  • 1.4.1 Application Tier Operating System Requirements
  • 1.4.2 Application Tier Character Set Requirements
  • 1.4.3 Forms Server Requirements
    • 1.4.3.1 CPU Security Update Patch
    • 1.4.3.2 Permanent IP Address
    • 1.4.3.3 Oracle Application Server 10g Release 2 Forms and Reports Services
    • 1.4.3.4 Java Runtime Environment
    • 1.4.3.5 Share a Directory with Separate Reports Servers
  • 1.4.4 Reports Server Requirements
    • 1.4.4.1 CPU Security Update Patch
    • 1.4.4.2 Load Tuning Reports Servers
    • 1.4.4.3 Planning File Viewing and Associated Directories
• 1.5 Planning an Oracle Clinical Client Installation
  • 1.5.1 Client Tier Operating System Requirements
  • 1.5.2 Client Tier Application Requirements
• 1.6 Integrating Oracle Clinical with Other Products and Options
  • 1.6.1 Oracle Remote Data Capture
  • 1.6.2 Oracle Clinical Partitioning
  • 1.6.3 SAS 9.2 Software
  • 1.6.4 Oracle Clinical Stable Interface
  • 1.6.5 Oracle Clinical Data Capture API
• 1.7 Following the Installation Constraints and Order
• 1.8 Reviewing the Installation Log Files

2 Installing the Oracle Clinical Database Server on UNIX

• 2.1 Installing and Patching Oracle Database 11g
  • 2.1.1 Install Oracle Database 11g Release 11.1.0.6.0
  • 2.1.2 Install Oracle Database Examples 11g Release 1
  • 2.1.3 Apply Oracle Database 11g Patch Set 1
  • 2.1.4 Apply Oracle Database 11g Standalone Patches
• 2.2 Granting Write Access to Oracle-Owned Directories
  • 2.2.1 Change Permissions on the oraclehomeproperties.xml File
  • 2.2.2 Modify the oraenv Script for Oracle Solaris
• 2.3 Setting Up User Accounts and User Groups
  • 2.3.1 Create the oclsascr User Group for SAS
  • 2.3.2 Create the opapps Account
  • 2.3.3 Create the rxcprod Account
    • 2.3.3.1 Configuring for the Remote Shell Commands
    • 2.3.3.2 Configuring for the at Command
• 2.4 Adjusting the Operating System Environment
• 2.5 Testing the C Compiler Installation
• 2.6 Installing the Oracle Clinical 4.6 Database Server
  • 2.6.1 Oracle Clinical 4.6 Database Server Directory Structure for UNIX
  • 2.6.2 Transfer the Oracle Clinical 4.6 Database Server Software
  • 2.6.3 Start Installing the Database Server Software
  • 2.6.4 Attend to the Oracle Clinical 4.6 Database Server Installation Screens
  • 2.6.5 Review the Installation Log Files
  • 2.6.6 Remove Group Privileges from this Session
• 2.7 Performing Post-installation Tasks
  • 2.7.1 Complete the Setup of the opapps Account
  • 2.7.2 Complete the Setup of the rxcprod Account
  • 2.7.3 Review the opa_settings File
  • 2.7.4 Apply the Latest CPU Security Update and Any New Patches

3 Installing the Oracle Clinical Database Server on Windows

• 3.1 Installing and Patching Oracle Database 11g
  • 3.1.1 Install Oracle Database 11g Release 11.1.0.6.0
  • 3.1.2 Install Oracle Database Examples 11g Release 1
  • 3.1.3 Apply Oracle Database 11g Patch Set 1
  • 3.1.4 Apply Oracle Database 11g Patch Bundle 8451592
• 3.2 Setting Up User Accounts and User Groups
  • 3.2.1 Create the RXCPROD Account
  • 3.2.2 Create the oclsascr User Group
• 3.3 Installing the Oracle Clinical 4.6 Database Server
  • 3.3.1 Oracle Clinical 4.6 Database Server Directory Structure for Windows
  • 3.3.2 Start the Oracle Clinical 4.6 Database Server Installation for Windows
  • 3.3.3 Attend to the Oracle Clinical 4.6 Database Server Installation Screens
• 3.4 Performing Post-installation Tasks
  • 3.4.1 Limit Permissions on the XMLTEMP Folder
  • 3.4.2 Create the PSUB Root Directory for File Viewing
  • 3.4.3 Edit the opa_settings.bat File
  • 3.4.4 Apply the Latest CPU Security Update and Any New Patches

4 Creating an Oracle Clinical Database

• 4.1 Reviewing Prerequisites
• 4.2 Reviewing Database Requirements and Recommendations
  • 4.2.1 Start with a New Database Instance
  • 4.2.2 Decide on Lowercase or Uppercase SID Name for UNIX
  • 4.2.3 Check Required Tablespaces
  • 4.2.4 Use the Database Configuration Assistant
  • 4.2.5 Select Required Components
  • 4.2.6 Use Automatic Memory Management
  • 4.2.7 Review opa_settings
  • 4.2.8 Set Initialization Parameters
  • 4.2.9 Modify tnsnames.ora
• 4.3 Installing Oracle Clinical 4.6 Database Objects
  • 4.3.1 Transfer the Oracle Clinical 4.6 UNIX Media
  • 4.3.2 Customize the Installer
    • 4.3.2.1 Edit Tablespace Sizes
    • 4.3.2.2 Edit the User Account Creation Script
  • 4.3.3 Start the Installer
    • 4.3.3.1 Starting the Installer on a UNIX Server
    • 4.3.3.2 Starting the Installer on a Windows Server
  • 4.3.4 Attend to the Oracle Clinical Database Installation Screens
  • 4.3.5 Remove Group Privileges from this Session (UNIX Only)
• 4.4 Performing Post-Installation Database Tasks
  • 4.4.1 Review the Log Files for Installation Errors
  • 4.4.2 Change Default Passwords
  • 4.4.3 Pin Database Packages
    • 4.4.3.1 Pin UNIX Database Packages
    • 4.4.3.2 Pin Windows Database Packages
  • 4.4.4 Configure and Start the PSUB Process
    • 4.4.4.1 Starting PSUB on UNIX
    • 4.4.4.2 Changing the Startup of the PSUB Service on Windows
    • 4.4.4.3 Configuring Windows Registry Setting for PSUB
    • 4.4.4.4 Starting the PSUB Service on Windows
    • 4.4.4.5 Configuring PSUB for Automatic Startup
    • 4.4.4.6 Changing PSUB Job Numbering
  • 4.4.5 Enroll Users
  • 4.4.6 Check Disconnected Replication Tablespace
  • 4.4.7 Review Optimization Statistics
  • 4.4.8 Consider Implementing Partitioning
• 4.5 Completing File Viewing Tasks in the Database
• 4.6 Adding the Reports Server to the Database Reference Codelist

5 Installing the Oracle Clinical Forms Server

• 5.1 Setting Up the OPAREPS Account
  • 5.1.1 Create the OPAREPS Account
  • 5.1.2 Add the OPAREPS Account to the Administrator's Group
  • 5.1.3 Add Printers to the OPAREPS Account
• 5.2 Installing and Patching Oracle AS10gR2 Forms and Reports Services
  • 5.2.1 Attend to the Oracle AS10gR2 Installation Screens
  • 5.2.2 Restart the Computer
  • 5.2.3 Apply Oracle AS10gR2 Patch Set 3 (10.1.2.3)
  • 5.2.4 Apply Application Server Patch 7384879
  • 5.2.5 Tune the Performance of the Application Server
  • 5.2.6 Set Resource Limits to Zero in Enterprise Manager
• 5.3 Applying a CPU Security Update Patch
• 5.4 Setting Up the SQL*Net Connections for Existing Databases
  • 5.4.1 Maintain a Central Copy of the tnsnames.ora File
  • 5.4.2 Troubleshoot Network Connection Issues
• 5.5 Installing the Oracle Clinical 4.6 Forms Server
  • 5.5.1 Attend to the Oracle Clinical Forms Server Installation Screens
• 5.6 Performing Post-Installation Tasks
  • 5.6.1 Modify the Oracle AS10gR2 Process Manager Service
  • 5.6.2 Test the Connection from the Database Server
  • 5.6.3 Share the RDC Directory and Set Image Browsing
  • 5.6.4 Enable the JSpell Spelling Checker Application
    • 5.6.4.1 Testing the JSpell Servlet
    • 5.6.4.2 Changing the Lexicons Directory
    • 5.6.4.3 Updating the formsweb.cfg File
    • 5.6.4.4 Updating Registry Entries
  • 5.6.5 Download the Java Runtime Environment
  • 5.6.6 Download the Oracle Clinical PDF Plug-in
  • 5.6.7 Upgrade Forms Server Customizations

6 Installing Reports Servers

• 6.1 Installing the Oracle Clinical 4.6 Reports Server
  • 6.1.1 Attend to the Oracle Clinical Reports Server Installation Screens
• 6.2 Setting Up the Reports Server for Access and File Viewing
  • 6.2.1 Create the Reports Server Root Directory
  • 6.2.2 Grant OPAREPS Read and Write Access to the Reports Server Root Directory
  • 6.2.3 Create Reports Server Log Directories for Each User
  • 6.2.4 Specify Directory Mappings for PSUB in Each Database
  • 6.2.5 Configure the Reports Server for DCI Forms and PDRs
• 6.3 Testing the Reports Server Installation
• 6.4 Troubleshooting Reports Server Problems

7 Setting Up Clients

• 7.1 Reviewing Requirements
• 7.2 Configuring Personal Firewall
• 7.3 Setting Internet Options for Microsoft Internet Explorer
  • 7.3.1 Set Up for Proxy Usage on Fully Qualified Application Tier Names
• 7.4 Downloading Plug-ins
  • 7.4.1 Download the Java Runtime Environment Plug-in
  • 7.4.2 Download the Oracle Clinical PDF Plug-in
  • 7.4.3 Download Adobe Reader
• 7.5 Starting and Logging In to Oracle Clinical and RDC Applications
• 7.6 Mapping Network Drive for Image Browsing
• 7.7 Enabling Report Generation from the Command Line

8 Setting Up SAS

• 8.1 Modifying SAS 9.2 for UNIX
  • 8.1.1 Prepare the SAS Template File
  • 8.1.2 Modify the opa_settings File
  • 8.1.3 Additional Modifications for Oracle Solaris
  • 8.1.4 Additional Modifications for HP-UX Itanium
• 8.2 Modifying SAS 9.2 for Windows
• 8.3 Setting Up SAS on a Different Computer
  • 8.3.1 Setting Up SAS on a Different UNIX Server Computer
  • 8.3.2 Setting Up SAS Use on a Different Windows Server Computer
  • 8.3.3 Executing Data Extract PSUB Jobs

9 Upgrading to Oracle Clinical 4.6

• 9.1 Upgrading the Database Tier
  • 9.1.1 Prepare the Database Tier for Oracle Database 11g
    • 9.1.1.1 Database Tier Upgrade Notes
    • 9.1.1.2 Oracle Database 11g Preliminary Tasks
    • 9.1.1.3 Stopping Replication
    • 9.1.1.4 Preparing Incremental Replication Environments
    • 9.1.1.5 Stopping Conventional Replication
    • 9.1.1.6 Stopping Symmetric Replication
    • 9.1.1.7 Altering the Default Tablespace of the Study Access Accounts
  • 9.1.2 Create a New Oracle Database 11g Oracle Home
    • 9.1.2.1 Creating a New UNIX Oracle Database 11g Oracle Home
    • 9.1.2.2 Creating a New Windows Oracle Database 11g Oracle Home
    • 9.1.2.3 Granting Write Access to Oracle-Owned Directories (UNIX)
  • 9.1.3 Upgrade the Database to the New Oracle Home
  • 9.1.4 Install Oracle Clinical 4.6 on the Database Server
    • 9.1.4.1 Installing Oracle Clinical 4.6 Database Servers on UNIX
    • 9.1.4.2 Install Oracle Clinical on Windows Database Servers
  • 9.1.5 Repair Data
    • 9.1.5.1 Repairing Release 4.5.1 Data
    • 9.1.5.2 Repairing Oracle Clinical 4.5.3 Data
  • 9.1.6 Review Tablespace Sizes
  • 9.1.7 Halt the PSUB process
  • 9.1.8 Set Initialization Parameters
  • 9.1.9 Upgrade the Database Objects from Oracle Clinical 4.5.1, 4.5.2, or 4.5.3 to Oracle Clinical 4.6
    • 9.1.9.1 UNIX Installer Starting Instructions
    • 9.1.9.2 Windows Installer Starting Instructions
    • 9.1.9.3 Attend to the Upgrade Installer Screens
    • 9.1.9.4 Enroll Users
    • 9.1.9.5 Check the Upgrade Results
  • 9.1.10 Implement Partitions
  • 9.1.11 Upgrade Indexes for Non-partitioned Databases
  • 9.1.12 Recompile Invalid Objects
  • 9.1.13 Pin Database Packages
  • 9.1.14 Analyze Tables
  • 9.1.15 Check the Event Parameter in the init.ora File
  • 9.1.16 Start the PSUB Process
  • 9.1.17 Change Default Passwords
• 9.2 Upgrading Forms Servers
  • 9.2.1 Upgrade Forms Server Customizations
    • 9.2.1.1 Upgrade the User Menu
    • 9.2.1.2 Upgrade rxclbcli.pll
    • 9.2.1.3 Change DE_GRIDWIDTH and DE_GRIDHEIGHT Parameters
• 9.3 Upgrading Reports Servers
  • 9.3.1 Replace the Placeholder DCF Logo Graphic
  • 9.3.2 Upgrade Customized DCF Reports
• 9.4 Upgrading Clients

A Migrating Data for Approvals and Verifications Enhancements

• A.1 Determining Requirements Before Migrating Data
  • A.1.1 Benchmarks for Estimating the Downtime Required
  • A.1.2 Tablespace Size Requirements
  • A.1.3 Required Tablespaces
• A.2 Preparing for Data Migration
  • A.2.1 About the Preparation Script
  • A.2.2 Set Up for the Preparation Script
    • A.2.2.1 Setting Up UNIX for the Preparation Script
    • A.2.2.2 Setting Up Windows for the Preparation Script
  • A.2.3 Run the Preparation Script for Data Migration
  • A.2.4 Check the Progress of the Preparation Script
  • A.2.5 View the Output File Created by the Preparation Script
• A.3 Before You Migrate Data
  • A.3.1 Prevent Access to Oracle Clinical Databases During Data Migration
  • A.3.2 Back Up the Databases Before Data Migration
• A.4 Patching Each Oracle Clinical Database
  • A.4.1 Patch Each Oracle Clinical Database on a UNIX Server
  • A.4.2 Patch Each Oracle Clinical Database on a Windows Server
• A.5 Migrating Your Data
  • A.5.1 About the Data Migration Script
  • A.5.2 Set Up the Environment Before Migrating Data
    • A.5.2.1 Setting Up UNIX Before Running the Data Migration Script
    • A.5.2.2 Setting Up Windows Before Running the Data Migration Script
  • A.5.3 Run the Data Migration Script
  • A.5.4 Check the Progress of the Data Migration Script
  • A.5.5 View the Output File Created by the Data Migration Script

Index