1/25

Contents

Title and Copyright Information

Preface

• Documentation Accessibility
• Where to Find the Product Documentation
• Related Documents

1 Overview

• 1.1 Software Requirements
• 1.2 Media Pack Content
• 1.3 General Guidelines for Installation
• 1.4 Supported Upgrade Paths

Part I Installation

2 Data Model Installation

• 2.1 Installing the Data Model 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.2 Installing the Data Model with Pre-created User Schemas
  • 2.2.1 Check Prerequisites
  • 2.2.2 Create Default Tablespaces
  • 2.2.3 Create Temporary Tablespaces
  • 2.2.4 Prepare the Installation Files
  • 2.2.5 Create Database Roles
  • 2.2.6 Create User Schemas
  • 2.2.7 Run the Installation Scripts
  • 2.2.8 Start the Installer
  • 2.2.9 Run the Installer
  • 2.2.10 Check the Installation
  • 2.2.11 Revoke Privileges

3 Data Management Assembly for Oracle Data Integrator 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.1.5 Create a New ODI Repository Login
• 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

4 Data Management Assembly for Informatica Installation

• 4.1 Installing the Data Management Assembly without Pre-Created User Schemas
  • 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 Data Management Assembly with Pre-Created User Schemas
  • 4.2.1 Check Prerequisites
  • 4.2.2 Create Default and Temporary Tablespaces
  • 4.2.3 Create User Schemas
  • 4.2.4 Prepare the Installer
  • 4.2.5 Run the Installer
  • 4.2.6 Check the Installation
  • 4.2.7 Revoke Privileges
• 4.3 Assigning the Integration Service

5 Middle-Tier Installation

• 5.1 Installing the Middle-Tier on the Primary Node
  • 5.1.1 Check Prerequisites
  • 5.1.2 Prepare the Installer
  • 5.1.3 Run the Installer
  • 5.1.4 Check the Installation
• 5.2 Installing the Middle-Tier on a Secondary Node
  • 5.2.1 Check Prerequisites
  • 5.2.2 Prepare the Installer
  • 5.2.3 Run the Installer
  • 5.2.4 Check the Installation
• 5.3 Troubleshooting
  • 5.3.1 Installation Log Files
  • 5.3.2 Troubleshooting the Primary Node Installation
  • 5.3.3 Troubleshooting the Secondary Node Installation
  • 5.3.4 Troubleshooting Coherence Cluster Errors

6 JDBC GridLink Data Source Configuration (optional)

• 6.1 Edit the Existing Generic Data Source
• 6.2 Create the JDBC GridLink Data Source

7 Oracle Healthcare Foundation Omics Data Bank Loaders Installation

• 7.1 Prerequisites
• 7.2 Installing the Oracle Healthcare Foundation Omics Data Bank Loaders

8 Oracle Healthcare Foundation Self-Service Analytics Installation

• 8.1 Installation Overview
• 8.2 Prerequisites
• 8.3 Installing the Oracle Healthcare Foundation Self-Service Analytics

Part II Upgrade

9 Data Model Upgrade

• 9.1 Check Prerequisites
• 9.2 Upgrading from Healthcare Data Warehouse Foundation or a Previous OHF Version
  • 9.2.1 Prepare the Installer
  • 9.2.2 Run the Installer
  • 9.2.3 Check the Installation
• 9.3 Data Migration (Not Applicable When Upgrading from OHF 7.1)
  • 9.3.1 Check the Migration Scripts
  • 9.3.2 Execute Schema Migration Scripts After Modifications

10 Data Management Assembly for Oracle Data Integrator Upgrade

• 10.1 Check Prerequisites
• 10.2 Prepare the Installer
• 10.3 Run the Installer
• 10.4 Check the Installation and Delete E$_tables

11 Data Management Assembly for Informatica Upgrade

• 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