Go to main content
1/15
Contents
Title and Copyright Information
Preface
Audience
User Documentation
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.0.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 12
c
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 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.2
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.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 Patches 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
6.15
Restart the Computer
7
Install the Oracle Clinical Front End
7.1
Gather Required Information
7.2
Restart Computer and Start All Servers and Services
7.3
Install the Oracle Clinical Front End Components
7.3.1
Review the Installation Log File
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
Allow More Connections
9.3.3
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
Scripting on this page enhances content navigation, but does not change the content in any way.