Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• How to Use AutoPatch
• Oracle CPU Security Updates
• Finding More Information

1 Before You Begin

• 1.1 Check for the Most Recent Information
• 1.2 Get Your Company ID from Oracle
• 1.3 Assemble the Software
  • 1.3.1 Get the Oracle Life Sciences Warehouse 2.4 Media Pack
  • 1.3.2 Download Software to a Staging Area
• 1.4 Assemble the Documentation
  • 1.4.1 Books
  • 1.4.2 My Oracle Support Articles

2 System Requirements and Technology Stack

• 2.1 System Requirements
  • 2.1.1 Operating Systems
  • 2.1.2 Hardware
• 2.2 Technology Stack
• 2.3 Integrated External Systems
• 2.4 Character Encoding Settings

3 Installing and Patching Oracle Applications and Oracle Database

• 3.1 Install Oracle Applications 12.1.1
  • 3.1.1 Oracle LSH UTF8 Requirements
• 3.2 Upgrade Oracle Applications to R12.1.3 and Apply Patches
  • 3.2.1 Install Patches Using Autopatch
  • 3.2.2 Download and Install the Software Development Kit for Java
• 3.3 Upgrade the Oracle Database and Oracle Warehouse Builder to 11.2.0.4
• 3.4 Edit listener_ifile.ora
• 3.5 Change Default Password Settings
• 3.6 Increase JVM Memory
• 3.7 Secure the Oracle Applications Installation
• 3.8 Clone the Environment (Optional)
• 3.9 Install Oracle Warehouse Builder on Oracle Database 11gR2
• 3.10 Create an Oracle Warehouse Builder Repository

4 Installing the Oracle TMS Database Tier

5 Installing the Oracle Life Sciences Data Hub

• 5.1 Apply the Oracle Life Sciences Data Hub AD Splicer Patch
• 5.2 Grant Execute Privileges to the APPS Schema
• 5.3 Install Oracle LSH Release 2.4
• 5.4 Install Online Help
• 5.5 Integrate Oracle LSH with the Oracle Warehouse Builder
  • 5.5.1 Set Up Your Environment
  • 5.5.2 Create Directories and Copy Files
  • 5.5.3 Disable Application Server Authentication
  • 5.5.4 Edit run_service.sh
  • 5.5.5 Edit runtime.properties
  • 5.5.6 Edit owb.classpath
  • 5.5.7 Edit Shell Scripts to Match Directory Structure
  • 5.5.8 Run OWB Shell Scripts
  • 5.5.9 Restart the OWB Service
  • 5.5.10 Edit listener_ifile.ora
• 5.6 Create System Administrator and Security Administrator Users
  • 5.6.1 Log on as sysadmin
  • 5.6.2 Create a User Account for the Administrator
  • 5.6.3 Assign a Role
• 5.7 Run Script
• 5.8 Run the Post-Installation Programs
  • 5.8.1 Check That OWB Is Running Without Errors
  • 5.8.2 Log On to Oracle Applications
  • 5.8.3 Load the Adapter Files
  • 5.8.4 Set the Tech Type Value
  • 5.8.5 Run the Post-Installation Program
  • 5.8.6 Synchronize the APPS Password in OWB
• 5.9 Gather Statistics on Schemas
• 5.10 Schedule the Context Index Refresh Program
• 5.11 Start Journaling Internal Tables
  • 5.11.1 Set AuditTrail:Activate Profile to Yes
  • 5.11.2 Define the Audit Installation
  • 5.11.3 Prevent Error
  • 5.11.4 Run the Audit Trail Update Tables Concurrent Program
• 5.12 Increase Memory Available for MetaData Reports
• 5.13 Grant Security Rights to Seeded Adapters
• 5.14 Create CDR_USER Role
• 5.15 Set Up the Notification Mailer
• 5.16 Set Up the Distributed Processing Server
  • 5.16.1 Create the Distributed Processing Server User Account
  • 5.16.2 Install the Distributed Processing Server
  • 5.16.3 Secure Distributed Processing Server Files
  • 5.16.4 Set NLS_LANG to UTF8
  • 5.16.5 Copy and Edit Files
  • 5.16.6 Define Service Locations and Services
  • 5.16.7 Start the DP Server
• 5.17 Set Up Client Computers
  • 5.17.1 Consumers and Administrators
  • 5.17.2 Application Developers

6 Integrating Other Systems

• 6.1 Integrating Oracle Clinical with the Oracle Life Sciences Data Hub
• 6.2 Integrating SAS with the Oracle Life Sciences Data Hub
  • 6.2.1 SAS Compatibility
  • 6.2.2 Set Up SAS Job Execution
  • 6.2.3 Set Up Loading Data from SAS
  • 6.2.4 Set Up SAS as an Integrated Development Environment
• 6.3 Integrating Informatica with the Oracle Life Sciences Data Hub
  • 6.3.1 Install Informatica PowerCenter
  • 6.3.2 Set Up Informatica Job Execution
  • 6.3.3 Set Up User Accounts
  • 6.3.4 Create a Remote Location and Connection for the LSHAdmin User
  • 6.3.5 Set Up Informatica PowerCenter Designer as an Integrated Development Environment (IDE)
• 6.4 Integrating Oracle SQL Developer or Oracle SQL*Plus with the Oracle Life Sciences Data Hub
  • 6.4.1 Set the NLS_LANG Environment Variable to UTF8
• 6.5 Integrating Oracle Business Intelligence Enterprise Editions (OBIEE) for Visualizations
  • 6.5.1 Install OBIEE 11.1.1.x for Visualizations
  • 6.5.2 Install OBIEE 10.1.3.4.1 for Visualizations
• 6.6 Integrating Oracle Business Intelligence Publisher for Programs
  • 6.6.1 Install Oracle Business Intelligence Publisher 10.1.3.4.1
  • 6.6.2 Set Up Oracle Business Intelligence Publisher Programs

7 Upgrading to Oracle Life Sciences Data Hub Release 2.4

• 7.1 Supported Upgrade Path
• 7.2 Upgrade to Release 2.3, then 2.3.1
• 7.3 Stop Server Processes
• 7.4 Upgrade and Configure Oracle Database and Oracle Warehouse Builder 11.2.0.4
• 7.5 Upgrade Oracle Thesaurus Management System Database to 5.0.1
• 7.6 Upgrade Informatica PowerCenter to 8.6.1 with HotFix 11 or Informatica PowerCenter 9.0.1 with HotFix 2
• 7.7 OBIEE 10g and 11g Options
  • 7.7.1 OBIEE 11g
• 7.8 Upgrade Integration with Oracle Business Intelligence Publisher
• 7.9 Upgrade Oracle Life Sciences Data Hub
  • 7.9.1 Install Oracle Life Sciences Data Hub 2.4
  • 7.9.2 Change Your FND_Validation_Level Profile
• 7.10 Complete the Oracle Warehouse Builder Update
  • 7.10.1 Create Directory and Copy Files
  • 7.10.2 Edit runtime.properties
  • 7.10.3 Edit owb.classpath
  • 7.10.4 Restart OWB
  • 7.10.5 Reset the Store Passwords
• 7.11 Upgrade the Distributed Processing Server User Account
• 7.12 Upgrade the Distributed Processing Server
• 7.13 Perform the Remaining Post-Installation Tasks
• 7.14 Start Server Processes

8 What's Next

A Architecture Overview

• A.1 Client Tier
• A.2 Application Tier
• A.3 Database Tier
• A.4 Adapters to External Systems
  • A.4.1 Source Data Systems
  • A.4.2 Data Transformation and Reporting Tools
  • A.4.3 Visualization Tools
  • A.4.4 Data Export Tools