1/28

Contents

Title and Copyright Information

Overview

• Software Requirements
• Media Pack Content
• General Guidelines for Installation
• Supported Upgrade Paths
• Where to Find the Product Documentation
• Documentation Accessibility

Part I Installation

1 Data Model Installation

• 1.1 Install the Data Model without Pre-created User Schemas
  • 1.1.1 Check Prerequisites
  • 1.1.2 Prepare the Installer
  • 1.1.3 Run the Installer
  • 1.1.4 Check the Installation
• 1.2 Install the Data Model with Pre-created User Schemas
  • 1.2.1 Check Prerequisites
  • 1.2.2 Create Default Tablespaces
  • 1.2.3 Create Temporary Tablespaces
  • 1.2.4 Prepare the Installation Files
  • 1.2.5 Create Database Roles
  • 1.2.6 Create User Schemas
  • 1.2.7 Run the Installation Scripts
  • 1.2.8 Start the Installer
  • 1.2.9 Run the Installer
  • 1.2.10 Check the Installation
  • 1.2.11 Revoke Privileges

2 Data Management Assembly for Oracle Data Integrator Installation

• 2.1 Installing the Data Management Assembly without Pre-Created User Schemas
  • 2.1.1 Check Prerequisites
  • 2.1.2 Prepare the Installer
  • 2.1.3 Run the Installer
  • 2.1.4 Check the Installation
  • 2.1.5 Create a New ODI Repository Login
• 2.2 Installing the Data Management Assembly with Pre-Created User Schemas
  • 2.2.1 Check Prerequisites
  • 2.2.2 Create Default and Temporary Tablespaces
  • 2.2.3 Create User Schemas
  • 2.2.4 Prepare the Installer
  • 2.2.5 Run the Installer
  • 2.2.6 Check the Installation
  • 2.2.7 Revoke Privileges

3 Data Management Assembly for Informatica Installation

• 3.1 Installing the Data Management Assembly without Pre-Created User Schemas
  • 3.1.1 Check Prerequisites
  • 3.1.2 Prepare the Installer
  • 3.1.3 Run the Installer
  • 3.1.4 Check the Installation
• 3.2 Installing the Data Management Assembly with Pre-Created User Schemas
  • 3.2.1 Check Prerequisites
  • 3.2.2 Create Default and Temporary Tablespaces
  • 3.2.3 Create User Schemas
  • 3.2.4 Prepare the Installer
  • 3.2.5 Run the Installer
  • 3.2.6 Check the Installation
  • 3.2.7 Revoke Privileges
• 3.3 Assigning the Integration Service

4 Middle-Tier Installation

• 4.1 Installing the Middle-Tier on the Primary Node
  • 4.1.1 Check Prerequisites
  • 4.1.2 Prepare the Installer
  • 4.1.3 Run the Installer
  • 4.1.4 Check the Installation
• 4.2 Installing the Middle-Tier on a Secondary Node
  • 4.2.1 Check Prerequisites
  • 4.2.2 Prepare the Installer
  • 4.2.3 Run the Installer
  • 4.2.4 Check the Installation

5 JDBC GridLink Data Source Configuration (optional)

• 5.1 Edit the Existing Generic Data Source
• 5.2 Create the JDBC GridLink Data Source

6 Oracle Healthcare Foundation Omics Data Bank Loaders Installation

• 6.1 Prerequisites
• 6.2 Installing the Oracle Healthcare Foundation Omics Data Bank Loaders

7 Oracle Healthcare Foundation Self-Service Analytics Installation

• 7.1 Installation Overview
• 7.2 Prerequisites
• 7.3 Install the Oracle Healthcare Foundation Self-Service Analytics
• 7.4 Deploy the Oracle Healthcare Foundation Catalog in OBIEE

Part II Upgrade

8 Data Model Upgrade

• 8.1 Check Prerequisites
• 8.2 Upgrading from Healthcare Data Warehouse Foundation or a Previous OHF Version
  • 8.2.1 Prepare the Installer
  • 8.2.2 Run the Installer
  • 8.2.3 Check the Installation
• 8.3 Data Migration (Not Applicable When Upgrading from OHF 7.1)
  • 8.3.1 Check the Migration Scripts
  • 8.3.2 Execute Schema Migration Scripts After Modifications

9 Data Management Assembly for Oracle Data Integrator Upgrade

• 9.1 Check Prerequisites
• 9.2 Prepare the Installer
• 9.3 Run the Installer
• 9.4 Check the Installation and Delete E$_tables
• 9.5 Create a New ODI Repository Login

10 Data Management Assembly for Informatica Upgrade

• 10.1 Check Prerequisites
• 10.2 Prepare the Installer
• 10.3 Run the Installer
• 10.4 Check the Installation

11 Middle-Tier Upgrade on the Primary Node

• 11.1 Check Prerequisites
• 11.2 Prepare the Installer
• 11.3 Run the Installer
• 11.4 Check the Installation

Part III Uninstall

12 Data Model Uninstall

13 Data Management Assembly for Oracle Data Integrator Uninstall

14 Data Management Assembly for Informatica Uninstall

15 Middle-Tier Uninstall

Part IV Troubleshooting

16 Data Model Troubleshooting

• 16.1 Installation Log Files
• 16.2 Seed Data Troubleshooting
  • 16.2.1 Error Logging and Debugging
  • 16.2.2 Seed Data Error Types

17 Data Management Assembly for Oracle Data Integrator Troubleshooting

• 17.1 Installation Log Files
• 17.2 Troubleshooting Guidelines

18 Data Management Assembly for Informatica Troubleshooting

• 18.1 Installation Log Files
• 18.2 Troubleshooting Guidelines
• 18.3 Troubleshooting

19 Middle-Tier Troubleshooting

• 19.1 Installation Log Files
• 19.2 Troubleshooting the Primary Node Installation
• 19.3 Troubleshooting the Secondary Node Installation
• 19.4 Troubleshooting Coherence Cluster Errors

A Configuration Guide for Exadata

• A.1 System Configuration
  • A.1.1 Exadata Component Configuration
  • A.1.2 Database Configuration
• A.2 Application Considerations
  • A.2.1 General Recommendations
  • A.2.2 Oracle Healthcare Foundation
  • A.2.3 Cohort Data Model
  • A.2.4 Omics Loaders

B Configuration Guide for Non-Exadata

• B.1 Database Configuration
  • B.1.1 Database I/O Calibration
  • B.1.2 Resource Manager
  • B.1.3 Database Parameters
  • B.1.4 Parallel Degree Policy
  • B.1.5 Oracle Automatic Stats Job
  • B.1.6 Tablespace and Redo Log Recommendations
  • B.1.7 ASM Recommendations
• B.2 Application Considerations
  • B.2.1 General Recommendations
  • B.2.2 Oracle Healthcare Foundation
  • B.2.3 Cohort Data Model
  • B.2.4 Omics Loaders