Contents

List of Figures

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Finding Information and Patches on My Oracle Support
• Finding Oracle Documentation
• How to Use AutoPatch
• Oracle CPU Security Updates
• Related Documents
• Conventions

Change Record

• Sections Updated in Version 6
• Sections Updated in Version 5

1 Before You Begin

• Check for the Most Recent Information
• Get Your Company ID from Oracle
• Assemble the Software
  • Get the Oracle Life Sciences Data Hub 2.2 Media Pack
  • Download Additional Patches
  • Set Up a Staging Area
• Assemble the Documentation
  • Books
  • My Oracle Support Articles
    • System Requirements and Technology
    • Installing Oracle Applications and Oracle Database
    • Installing the Oracle Life Sciences Data Hub
    • Upgrading to Oracle Life Sciences Data Hub Release 2.2
    • Installing Real Application Clusters (RAC)
    • Other Oracle LSH-Related Documents

2 System Requirements and Technology Stack

• System Requirements
  • Operating Systems
  • Hardware
• Technology Stack
• Integrated External Systems
• Character Encoding Settings

3 Installing and Patching Oracle Applications and Oracle Database

• Install Oracle Applications 12.1.1
  • Oracle LSH UTF8 Requirements
• Upgrade Oracle Applications to R12.1.3
• Upgrade the Oracle Database to 11.2.0.2
• Edit listener_ifile.ora
• Change Default Password Settings
• Increase JVM Memory
• Clone the Environment (Optional)
• Install Oracle Warehouse Builder on Oracle Database 11gR2
• Create an Oracle Warehouse Builder Repository

4 Installing Oracle Thesaurus Management System

• Set Up a Windows Computer for Launching the TMS Installation
• Setting up the SQL*Net Connections for Existing Databases
• Set Up Compatibility Mode
• Install the TMS Server
• Install the TMS Database
• Apply TMS Patch
• Check the def_instance_name Column Value

5 Installing the Oracle Life Sciences Data Hub

• Apply the Oracle Life Sciences Data Hub AD Splicer Patch
• Install Oracle LSH Release 2.2
• Install Online Help
• Grant Execute Privileges to the APPS Schema
• Integrate Oracle LSH with the Oracle Warehouse Builder
  • Set Up Your Environment
    • Ensure that Oracle SID and Short Global Names Match
    • Edit init.ora
    • Restart the Database and Listener
    • Test Database Connectivity
  • Create Directories and Copy Files
  • Disable Application Server Authentication
  • Edit run_service.sh
  • Edit Runtime.properties
  • Edit owb.classpath
  • Edit Shell Scripts to Match Directory Structure
  • Run OWB Shell Scripts
  • Restart the OWB Service
    • Stop the OWB Service
    • Starting the OWB Service
  • Edit listener_ifile.ora
• Create System Administrator and Security Administrator Users
  • Log on as sysadmin
  • Create a User Account for the Administrator
  • Assign a Role
• Run Script
• Run the Post-Installation Programs
  • Check That OWB Is Running Without Errors
  • Log On to Oracle Applications
  • Load the Adapter Files
  • Set the Tech Type Value
  • Run the Post-Installation Program
    • If You Must Change a Post-Installation Job Parameter Value
  • Synchronize the OWB Password
• Schedule the Context Index Refresh Program
• Start Journaling Internal Tables
  • Set AuditTrail:Activate Profile to Yes
  • Define the Audit Installation
  • Run the Audit Trail Concurrent Program
• Increase Memory Available for MetaData Reports
• Grant Security Rights to Seeded Adapters
• Set Up the Notification Mailer
• Set Up the Distributed Processing Server
  • Create the Distributed Processing Server User Account
  • Install the Distributed Processing Server
  • Set NLS_LANG to UTF8
    • Windows
    • UNIX
  • Copy and Edit Files
    • Copy DP Server Files
    • Edit the DP Server Start Script
    • Copy RTF Template Files for XML Publisher
    • Copy and Edit Execution Command Files for Processing Engines
  • Define Service Locations and Services
  • Start the DP Server
• Set Up Client Computers
  • Consumers and Administrators
  • Application Developers
    • Install the Client Plug-In
    • Set NLS_LANG to UTF8
    • Set Up Development Environments

6 Integrating Other Systems

• Integrating Oracle Clinical with the Oracle Life Sciences Data Hub
• Integrating SAS with the Oracle Life Sciences Data Hub
  • SAS Compatibility
  • Set Up SAS Job Execution
    • Integrate the SAS Server with Oracle LSH
    • Start SAS in UTF8 Mode
  • Set Up Loading Data from SAS
  • Set Up SAS as an Integrated Development Environment
• Integrating Informatica with the Oracle Life Sciences Data Hub
  • Install Informatica PowerCenter
  • Set Up Informatica Job Execution
  • Set Up User Accounts
  • Create a Remote Location and Connection for the LSHAdmin User
  • Set Up Informatica PowerCenter Designer as an Integrated Development Environment (IDE)
• Integrating Oracle SQL Developer or Oracle SQL*Plus with the Oracle Life Sciences Data Hub
  • Set the NLS_LANG Environment Variable to UTF8
    • Windows
    • UNIX
• Integrating Oracle Business Intelligence Enterprise Editions (OBIEE) for Visualizations
  • Install OBIEE 11.1.1.5.0 for Visualizations
    • Install OBIEE 11.1.1.5.0
    • Install the Oracle LSH DP Server
    • Set Up OBIEE 11.1.1.5.0 Visualizations
  • Install OBIEE 10.1.3.4.1 for Visualizations
    • Install Oracle Business Intelligence Publisher 10.1.3.4.1
    • Apply Patch 12613341
    • Apply Patch 7642637 for Visualizations
    • Install the Oracle LSH DP Server
    • Set Up OBIEE 10.1.3.4.1 Visualizations
• Integrating Oracle Business Intelligence Publisher for Programs
  • Install Oracle Business Intelligence Publisher 10.1.3.4.1
  • Set Up Oracle Business Intelligence Publisher Programs
    • Enable Program Execution
    • Set Up Security
    • Set Up Business Intelligence Publisher Definer Tools

7 Upgrading to Oracle Life Sciences Data Hub Release 2.2

• Supported Upgrade Paths
• Set the Tech Type Value
• Stop Server Processes
• Recommended Steps for a Smoother Upgrade Process
• Upgrade Oracle Applications
  • Install Oracle Applications R12.1.1
  • Monitor the Upgrade Process
  • Upgrade Oracle Applications to R12.1.3
  • Apply Patches
• Upgrade and Configure the Oracle Database
• Upgrade Oracle Thesaurus Management System to 4.6.1
• Upgrade Informatica PowerCenter to 8.6.1 with HotFix 11 or Informatica PowerCenter 9.0.1
• Oracle Business Intelligence Publisher 10.1.3.4.1
• OBIEE 10g and 11g Options
  • OBIEE 10.1.3.4.1
  • OBIEE 11.1.1.5.0
    • Install the Software
    • Copy and Edit Revised Execution Command Scripts
    • Upgrade and Deploy the Master Repository File
    • Set the Default Authenticator to Optional
    • Starting the WebLogic Server
    • Migrate Repository Files for Individual Business Areas
• Migrate the Oracle Warehouse Builder Repository
  • Migrate the OWB Repository from CDR_RTREPOS to OWBSYS
  • Create the OWBSYS Schema and Grant Privileges
    • Create the Schema
    • Unlock Accounts and Change Passwords
    • Grant Required Privileges
  • Create New OWB Workspace for CDR_RTREPOS
• Upgrade Oracle Life Sciences Data Hub
• Integrate Oracle LSH with the 11gR2 Oracle Warehouse Builder
  • Set Up Your Environment
  • Create Directories and Copy Files
  • Disable Application Server Authentication
  • Edit run_service.sh
  • Edit Runtime.properties
  • Edit owb.classpath
  • Edit Shell Scripts to Match Directory Structure
  • Run OWB Shell Scripts
  • Restart the 11gR2 OWB Service
  • Stop the 10gR2 OWB Service
• Upgrade the OWB Repository
  • Upgrading OWB from Oracle LSH 2.1.3 on 10gR2 to Oracle LSH 2.2
  • Upgrading OWB from Oracle LSH 2.1.3 on 11gR2 or Oracle LSH 2.1.4 on 11gR2 to Oracle LSH 2.2
• Migrate the Oracle Warehouse Builder Stores
  • Migrate the Store Passwords and Audit Task ID
  • Upgrade the Workflow Store
  • Upgrade Other OWB Stores
  • Edit listener_ifile.ora
• Upgrade the Distributed Processing Server
• Perform the Remaining Post-Installation Tasks
• Start Server Processes

8 What's Next

A Architecture Overview

• Client Tier
• Application Tier
• Database Tier
• Adapters to External Systems
  • Source Data Systems
  • Data Transformation and Reporting Tools
  • Visualization Tools
  • Data Export Tools

B Installing Real Application Clusters (RAC)