1 Before You Begin

This section presents an overview of the Oracle Health Sciences Clinical Development Analytics (OHSCDA) requirements. It also describes the tasks that you must complete before you can install the application.

This chapter includes the following sections:

Section 1.1, "Checking for the Most Recent Information"
Section 1.2, "Technology Stack and System Requirements"
Section 1.3, "Installing the Prerequisite Software"

1.1 Checking for the Most Recent Information

OHSCDA documentation is updated periodically. Therefore, it is critical that you check that you have the most current information before you begin the installation process.

To ensure that you have the most recent version of this Installation and Configuration Guide, and all other OHSCDA user documentation, see Finding Documentation on Oracle Technology Network.

1.2 Technology Stack and System Requirements

The requisite technology stack for OHSCDA configuration consists of the following products:

Oracle Database 12.1.0.2.0 with patch 19509982
Oracle WebLogic Server 10.3.6
Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.9.0
Oracle Fusion Middleware 12c (12.1.3.0.0) Infrastructure
Oracle Data Integrator (ODI) 12.1.3

Note:

Technology stack components are not part of the media pack. You must acquire their license separately.

All references to media pack server in this document refer to the system onto which you download the media pack for Oracle Health Sciences Clinical Development Analytics.

Table 1-1 System Requirements References

Product	Reference
Oracle Database 12.1.0.2.0 with patch 19509982	Database Installation Guide for <platform>
Oracle WebLogic Server 10.3.6	Oracle WebLogic Server Documentation Library
Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.9.0	System Requirements and Supported Platforms for Oracle Business Intelligence Suite Enterprise Edition Oracle Business Intelligence Infrastructure Installation and Configuration Guide
Oracle Fusion Middleware 12c (12.1.3.0.0) Infrastructure	Oracle Fusion Middleware Documentation Library
Oracle Data Integrator 12.1.3	Oracle Data Integrator Documentation Library

Installation Considerations

Determine the computer on which you will install each component of OHSCDA.
You may select to install each product on a different server, if required. The OHSCDA media pack server does not have to act as server for any of the products, though it may. You may consult Figure 1-1, and the documentation listed in Table 1-1 for information on installing each product.
Determine the databases you need to create.
You must create a database schema to serve as the warehouse for OHSCDA.
It is a good practice to create the schema for the OHSCDA warehouse in a new database.
You may select to create schemas for repositories for the other OHSCDA components in the same database that will be used for the OHSCDA warehouse. It minimizes the number of databases that you need to maintain for OHSCDA. However, if you will be using the component applications for purposes other than OHSCDA, Oracle recommends that you create their repositories in instances other than the one holding the OHSCDA warehouse.

Figure 1-1 Oracle Health Sciences Clinical Development Analytics Technology

Description of ''Figure 1-1 Oracle Health Sciences Clinical Development Analytics Technology''

For more information about certifications, see Finding Certification Information.

1.2.1 Supported Web Browsers

OHSCDA supports web browsers that are supported by OBIEE. For the list of the browsers supported by OBIEE, refer to Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition 11g.

Note:

For information on Oracle Software Web Browser Support Policy, see Doc ID 2092205.1 on My Oracle Support (https://support.oracle.com).

1.2.2 Source Systems

OHSCDA is designed to extract data from the following three systems:

Oracle Clinical (OC) 4.6 or 5.1
Siebel Clinical Trial Management System (SC) 8.1.1.15
Oracle Health Sciences InForm 4.6, 5.5, 6.0, or 6.1

1.3 Installing the Prerequisite Software

Figure 1-2 displays a sample topology of the technology components for OHSCDA.

Figure 1-2 Sample Topology

Description of ''Figure 1-2 Sample Topology''

Before you can install the OHSCDA application, you must complete the following pre-installation tasks:

Install Oracle Database 12.1.0.2.0 with patch 19509982

Note:
You must set the init parameter processes for the database to a minimum of 500.

Follow the instructions in Oracle Database Installation Guide for <platform>.

Also, install Oracle Database Client for 12.1.0.2.0 on the system where you are running the OHSCDA installer. Follow the instructions in Oracle Database Client Installation Guide for <platform>.
Install Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.9.0 with the following components:
- Oracle Business Intelligence Server (Supported on Windows and Unix)
- Oracle Business Intelligence Presentation Services (Supported on Windows and Unix)
- Oracle Business Intelligence Client Tools (Supported only on Windows)
Follow the instructions in Oracle Business Intelligence Infrastructure Installation and Configuration Guide.
Install Oracle Data Integrator 12.1.3

Note:
Oracle recommends that the Java heap size where you install ODI Studio must be minimum of 2 GB.

For more information, see Oracle Data Integrator Installation Guide.
If you implement multi-byte character support for OHSCDA, set the following:
- Operating System Level: Ensure that the system that hosts ODI and Database have the following parameters set:
  - NLS_LANG=AMERICAN_AMERICA.AL32UTF8
  - LANG=en_US.UTF-8
- Database Level: Ensure that the following parameters are set while creating database:
  - NLS_CHARACTERSET =AL32UTF8
  - NLS_NCHAR_CHARACTER= AL16UTF16