1/15

Contents

Title and Copyright Information

Preface

• Audience
• User Documentation
• Change Record
• Documentation Accessibility

1 Prepare to Install Oracle Clinical

• 1.1 Check Installation Documentation
  • 1.1.1 My Oracle Support Articles
  • 1.1.2 User and Installation Documentation
• 1.2 Architecture
• 1.3 Network Topology
• 1.4 Software Requirements
  • 1.4.1 Database Tier Operating System Requirements
• 1.5 Supported Configurations with Oracle Data Guard and RAC
  • 1.5.1 Supported Configurations with Oracle Real Application Clusters (RAC)
    • 1.5.1.1 Node 1: Install and Set Up Everything Required for Oracle Clinical
    • 1.5.1.2 Node 2: Install the Minimum Required as a RAC Node
    • 1.5.1.3 Node 3: Install Everything Required for Oracle Clinical as Backup
      • 1.5.1.3.1 Recommended Options for RAC
  • 1.5.2 Supported Configurations with Oracle Data Guard
• 1.6 Download the Software
  • 1.6.1 Create Staging Areas
  • 1.6.2 Download the Oracle Clinical 5.2.1.0.x and Oracle Thesaurus Management System 5.2.3.0.x Media Pack
  • 1.6.3 Download Patches from My Oracle Support
  • 1.6.4 Download Oracle Java Development Kit
  • 1.6.5 Download the Java Runtime Environment
  • 1.6.6 Download Adobe Reader
  • 1.6.7 Download JSpell (Optional)
• 1.7 Use the Silent Installer (Optional)
• 1.8 Choose a Character Set
• 1.9 Apply the Latest Oracle Clinical Patches
• 1.10 Integrating Oracle Clinical with Other Products and Options
  • 1.10.1 Oracle Clinical Remote Data Capture Onsite
  • 1.10.2 Oracle Thesaurus Management System
  • 1.10.3 Oracle Life Sciences Data Hub
  • 1.10.4 SAS
  • 1.10.5 Custom Applications for Oracle Clinical

Part I Database Tier

2 Install Oracle Database

• 2.1 Get the Oracle Database 12.1.0 Installation Guide
• 2.2 Download and Extract the Oracle Database 12.1.0 Software
• 2.3 Performing Prerequisite Tasks for Installing Oracle Database
  • 2.3.1 Create Owners, Groups, and Mount Points
  • 2.3.2 Configure Kernel Resources and Adjust Operating System Environment
  • 2.3.3 Test the C Compiler Installation
  • 2.3.4 Install Latest Operating System Patches
• 2.4 Install Oracle Database 12.1.0
  • 2.4.1 Install and Configure Oracle Database
  • 2.4.2 Modify the tnsnames.ora File on the Database Server
  • 2.4.3 Create the oinstall User Group
  • 2.4.4 Check Required Tablespaces
  • 2.4.5 Performance Tuning Step for Pluggable Databases
• 2.5 Install Oracle Database 12c Release 2 (12.1.0.2) Examples
• 2.6 Install Oracle Critical Patch Update

3 Install Oracle Clinical Database Components on UNIX

• 3.1 Set Up the opapps User Account and oclsascr User Group
  • 3.1.1 Create the oclsascr User Group for SAS
  • 3.1.2 Create the opapps Account and Add It to Groups
• 3.2 Set Permissions
  • 3.2.1 Change Permissions for Running oraenv Script
  • 3.2.2 Grant Access to the ORACLE_HOME Directory
  • 3.2.3 Set Permissions for the Oracle Inventory Directory
• 3.3 Install the Oracle Clinical Database Server
  • 3.3.1 Gather Required Information
  • 3.3.2 Prepare to Install the Oracle Clinical Database Server Software
  • 3.3.3 Install the Oracle Clinical Database Server Software
  • 3.3.4 Save the Installation Information
  • 3.3.5 Review the Installation Log Files
  • 3.3.6 Oracle Clinical Database Server Directory Structure for UNIX
  • 3.3.7 Remove Group Privileges from this Session
• 3.4 Perform Server Post-Installation Tasks
  • 3.4.1 Complete the Setup of the opapps Account
  • 3.4.2 Limit Permissions on the XMLTEMP Folder
  • 3.4.3 Review the opa_settings File
  • 3.4.4 Check for Oracle Clinical Databases on a UNIX Server
• 3.5 Install Oracle Clinical Database Objects
  • 3.5.1 Customize the Installation
  • 3.5.2 Check for an ORA-29548 Error
  • 3.5.3 Gather Required Information
  • 3.5.4 Start Installing the Oracle Clinical Database
    • 3.5.4.1 Start the Installer on a UNIX Server
  • 3.5.5 Remove Group Privileges from this Session
  • 3.5.6 Review the Installation Log Files
• 3.6 Perform Database Post-Installation Tasks
  • 3.6.1 Set the Database Time Zone
  • 3.6.2 Pin Database Packages
  • 3.6.3 Set Up Disconnected Replication (Optional)
    • 3.6.3.1 Check the Tablespace Size
    • 3.6.3.2 Create a Wallet Credential for the RXC_DISC_REP Database User
    • 3.6.3.3 Test Wallet Connection for RXC_DISC_REP
    • 3.6.3.4 Add Reference Codelist Value
  • 3.6.4 Consider Implementing Partitioning
• 3.7 Set Up Parameterized Submissions
  • 3.7.1 Create Directories and Enter Values in OCL_STATE Local Reference Codelist
  • 3.7.2 Enable Users to Submit PSUB Jobs
  • 3.7.3 Enable opapps to Use the at Command
  • 3.7.4 Start the PSUB Service
  • 3.7.5 Customize the PSUB Service (Optional)
  • 3.7.6 Test the PSUB Installation

4 Install Oracle Clinical Database Components on Windows

• 4.1 Set Up the opapps User Account and the oclsascr User Group
  • 4.1.1 Create the oclsascr User Group
  • 4.1.2 Create the opapps Account and Add It to Groups
• 4.2 Set Up Local Policy Security Options
• 4.3 Install the Oracle Clinical Database Server
  • 4.3.1 Gather Required Information
  • 4.3.2 Install the Oracle Clinical 5.2.1 Database Server for Windows
  • 4.3.3 Save the Installation Information
  • 4.3.4 Review the Installation Log Files
  • 4.3.5 Oracle Clinical Database Server Directory Structure for Windows
• 4.4 Perform Server Post-Installation Tasks
  • 4.4.1 Limit Permissions on the XMLTEMP Folder
  • 4.4.2 Review the opa_settings.bat File
• 4.5 Install Oracle Clinical Database Objects
  • 4.5.1 Customize the Installation
  • 4.5.2 Check for an ORA-29548 Error
  • 4.5.3 Gather Required Information
  • 4.5.4 Start Installing the Oracle Clinical Database
  • 4.5.5 Review the Installation Log Files
• 4.6 Perform Database Post-Installation Tasks
  • 4.6.1 Set the Database Time Zone
  • 4.6.2 Pin Database Packages
  • 4.6.3 Set Up Disconnected Replication (Optional)
    • 4.6.3.1 Check Tablespace Size
    • 4.6.3.2 Create a Wallet Credential for the RXC_DISC_REP Database User
    • 4.6.3.3 Test Wallet Connection for RXC_DISC_REP
    • 4.6.3.4 Add Reference Codelist Value
  • 4.6.4 Consider Implementing Partitioning
• 4.7 Set Up Parameterized Submissions
  • 4.7.1 Create Directories and Enter Values in OCL_STATE Local Reference Codelist
  • 4.7.2 Enable Users to Submit PSUB Jobs
  • 4.7.3 Set Up Active Directory
  • 4.7.4 Start the PSUB Service
  • 4.7.5 Customize the PSUB Service (Optional)
  • 4.7.6 Test the PSUB Installation

5 Integrate SAS (Optional)

• 5.1 Set Up SAS Data Extract
  • 5.1.1 Give Users Access to the opapps Account
  • 5.1.2 Add the opapps Account to the oclsascr User Group
  • 5.1.3 Give opapps Access to the Directory Specified in the RXC_SAS_VIEW Environment Variable
  • 5.1.4 Set Up SAS User Authentication and Set OCL_STATE Reference Codelist Values
• 5.2 Install SAS on a UNIX Computer
  • 5.2.1 Modify SAS 9.4 and opa_settings on UNIX
    • 5.2.1.1 Prepare the SAS Template File
    • 5.2.1.2 Additional Modifications for Oracle Solaris
  • 5.2.2 Install SAS on the Same UNIX Computer as Oracle Clinical
    • 5.2.2.1 Set REMOTE_OS_AUTHENT to FALSE
    • 5.2.2.2 Set Up a SAS Connection
      • 5.2.2.2.1 Oracle Wallet
      • 5.2.2.2.2 SAS Encryption
  • 5.2.3 Install SAS on a Different UNIX Computer from Oracle Clinical
    • 5.2.3.1 Establish the Connection to SAS on a Different Computer
      • 5.2.3.1.1 NFS
      • 5.2.3.1.2 Create opapps on the SAS Server
      • 5.2.3.1.3 Check init.ora
      • 5.2.3.1.4 Create a Shell Script
    • 5.2.3.2 Set Up SAS Security on a Different Computer
      • 5.2.3.2.1 Oracle Wallet
      • 5.2.3.2.2 SAS Encryption
    • 5.2.3.3 Configure Private and Public Keys for Using SSH with SAS
• 5.3 Install SAS on a Windows Computer
  • 5.3.1 Modify the opasettings.bat file
  • 5.3.2 Install SAS on the Same Windows Computer as Oracle Clinical
    • 5.3.2.1 Set REMOTE_OS_AUTHENT to FALSE
    • 5.3.2.2 Set System Path
    • 5.3.2.3 Edit the SAS Config File and Grant Permissions
  • 5.3.3 Install SAS on a Different Windows Computer from Oracle Clinical
    • 5.3.3.1 Set REMOTE_OS_AUTHENT to TRUE
    • 5.3.3.2 Edit the SAS Config File and Grant Permissions
    • 5.3.3.3 Set Values in OCL_STATE Reference Codelist

Part II Application Tier

6 Install and Configure the Oracle Application Tier

• 6.1 Before You Start
  • 6.1.1 Identify a Single Account to Perform All Application Tier Installation Tasks
  • 6.1.2 Get a CA Certificate for HTTPS
  • 6.1.3 Shared Directory
  • 6.1.4 Permanent IP Address
• 6.2 Gather Required Information
• 6.3 Install Adobe Reader
• 6.4 Install Oracle Java Development Kit
• 6.5 Install Oracle WebLogic Server 12.2.1.3
• 6.6 Install the Oracle Fusion Middleware Infrastructure Software
• 6.7 Install the Oracle Forms and Reports Servers
• 6.8 Create the Repository Creation Utility
• 6.9 Configure the FRDomain
  • 6.9.1 Run ohs_updateInstances
• 6.10 Enable SSL Between a Browser and Oracle HTTP Server
  • 6.10.1 Enable SSL Between a Browser and Oracle HTTP Server Using a Certificate Authority
    • 6.10.1.1 Create an Oracle Wallet and Generate a Certificate Request
    • 6.10.1.2 Obtain Trusted Certificate and User Certificate from Certificate Authority
    • 6.10.1.3 Add the User Certificate and Trusted Certificate to an Oracle Wallet
    • 6.10.1.4 Edit the Oracle HTTP Server Configuration File
  • 6.10.2 Enable SSL Between a Browser and Oracle HTTP Server With Self Signing
    • 6.10.2.1 Edit the Oracle HTTP Server Configuration File
• 6.11 Apply Patch on the Application Server
• 6.12 Modify the tnsnames.ora File on the Application Server
• 6.13 Configure Firewall on the Application Tier
• 6.14 Test Connectivity to Databases for Forms and Reports Servers
  • 6.14.1 Test the Connection from the Application Servers to the Database
  • 6.14.2 Troubleshoot Network Connection Issues

7 Install the Oracle Clinical Front End

• 7.1 Gather Required Information
• 7.2 Restart Computer and Start All Services
• 7.3 Install the Oracle Clinical Front End Components
  • 7.3.1 Review the Installation Log Files
  • 7.3.2 Restart the Computer
  • 7.3.3 Add WebLogic Data Sources If Using Multiple Databases
• 7.4 Make the Java Runtime Environment Available for Download
• 7.5 Make the Oracle Clinical PDF Plug-in Available to Users
• 7.6 Share the RDC Directory for Image Access
  • 7.6.1 Sharing the Directory Across Multiple Computers
  • 7.6.2 Setting Up the Image Directory on a Single Computer
• 7.7 Install and Configure JSpell Spell Checker SDK (Optional)
  • 7.7.1 Install JSpell on Oracle Application Server
  • 7.7.2 Install the JSpell WAR File on the WebLogic Server
  • 7.7.3 Update the mod_wl_ohs.conf File for JSpell
  • 7.7.4 Stop and Start Oracle HTTP Server (OHS)
  • 7.7.5 Test the JSpell Servlet
  • 7.7.6 Update the formsweb.cfg File for JSpell
  • 7.7.7 Update the Windows System Registry for JSpell
  • 7.7.8 Test JSpell in the Graphic Layout Editor
• 7.8 Verify and Fix Environment Variables
  • 7.8.1 Check Values
  • 7.8.2 Correct Values
• 7.9 Set Up Automatic Startup
  • 7.9.1 Create boot.properties
  • 7.9.2 Increase the Delay for Auto Start OPADomain and FRDomain
  • 7.9.3 Set Up Scripts to Execute Automatically at Machine Startup
  • 7.9.4 Test Autostart
• 7.10 Start Servers Manually
  • 7.10.1 Start the FRDomain Node Manager
  • 7.10.2 Start the FRDomain Admin Server
  • 7.10.3 Start the Forms Server
  • 7.10.4 Start the Reports Server
  • 7.10.5 Start the OPADomain Node Manager
  • 7.10.6 Start the OPADomain Admin Server
  • 7.10.7 Start the Managed Server of OPADomain
  • 7.10.8 Start the OHS Server
• 7.11 Verify the Application Tier Installation
• 7.12 Stop Servers
  • 7.12.1 Stop the Forms Server
  • 7.12.2 Stop the Reports Server
  • 7.12.3 Stop the FRDomain Admin Server
  • 7.12.4 Stop the OPADomain Admin Server
  • 7.12.5 Stop the Managed Server of OPADomain

8 Install the Oracle Clinical Reports Server

• 8.1 Gather Required Information
• 8.2 Restart the Computer
• 8.3 Start the WebLogic FRDomain Admin Server
• 8.4 Install the Oracle Clinical Reports Server
  • 8.4.1 Review the Installation Log File
• 8.5 Apply Oracle Reports Developer Patch 22334822
• 8.6 Restart the Computer
• 8.7 Set Up Reports Server and Forms Server for Access and File Viewing
  • 8.7.1 Create the Reports Server Root Directory
  • 8.7.2 Share Each Reports Server Root Directory
  • 8.7.3 Provide Oracle Clinical and RDC Users Access to the Root Directory
  • 8.7.4 Configure the Reports Server and Forms Server for DCI Form Generation
  • 8.7.5 Configure the Reports Server to Send Output to a Printer
• 8.8 Add the Reports Server to the Database Reference Codelist
• 8.9 Test the Reports Server Installation
• 8.10 Set Up Automatic Startup of Services

Part III Client Tier

9 Set Up Clients

• 9.1 Configure Personal Firewall
• 9.2 About Using Safari on an iPad
• 9.3 Set Internet Options for Microsoft Internet Explorer
  • 9.3.1 Set Up for Proxy Usage on Fully Qualified Application Tier Names
  • 9.3.2 Turn Off Compatibility View in Internet Explorer
• 9.4 Download Required Applications
  • 9.4.1 Download the Java Runtime Environment
  • 9.4.2 Download the Oracle Clinical PDF Plug-in
  • 9.4.3 Download Adobe Reader
• 9.5 Map Network Drive for Image Browsing (Optional)
• 9.6 Enable Report Generation from the Command Line (Optional)
• 9.7 How to Log In