1/15

Contents

List of Figures

List of Tables

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

1 Before You Begin

• Check for the Most Recent Information
• Get Your Company ID from Oracle
• Assemble the Software
  • Get the Required Oracle Life Sciences Data Hub Releases
  • Get the Required E-Business Suite 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.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
• Upgrade Oracle Applications to Release 12.1.3
• Upgrade the Oracle Database and Oracle Warehouse Builder to 11.2.0.4
• Edit listener_ifile.ora
• Change Default Password Settings
• Increase JVM Memory
• Clone the Environment (Optional)
• Install Oracle Warehouse Builder on Oracle Database 11g Release 2
• 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
• Gather Statistics on Schemas
• 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
• Install Oracle LSH Release 2.2.2
  • Install Prerequisite Patches for Oracle LSH 2.2.1
  • Install Oracle LSH Release 2.2.1
  • Install Oracle LSH Release 2.2.2

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.7.0 for Visualizations
    • Install OBIEE 11.1.1.7.0
    • Install the Oracle LSH DP Server
    • Set Up OBIEE 11.1.1.7.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 or Oracle Business Intelligence Publisher 11.1.1.7.0
  • 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.2

• Supported Upgrade Paths
• Stop Server Processes
• Recommended Steps for a Smoother Upgrade Process
• Install and Upgrade Oracle Applications
  • Install Oracle Applications Release 12.1.1
  • Monitor the Upgrade Process
  • Upgrade Oracle Applications to Release 12.1.3
  • Apply Patches
• Upgrade and Configure the Oracle Database
• Upgrade Informatica PowerCenter to 8.6.1 with HotFix 11, or to Informatica PowerCenter 9.0.1, or to Informatica PowerCenter 9.5.1
• Oracle Business Intelligence Publisher Options
• OBIEE Options
  • OBIEE 10.1.3.4.1
  • OBIEE 11.1.1.7.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 (Conditional)
  • 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 11g Release 2 Oracle Warehouse Builder (Conditional)
  • 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 11g Release 2 OWB Service
  • Stop the 10g Release 2 OWB Service
• Upgrade the OWB Repository (Conditional)
  • Upgrading OWB from Oracle LSH 2.1.3 on 10g Release 2 to Oracle LSH 2.2
  • Upgrading OWB from Oracle LSH 2.1.3 on 11g Release 2 or Oracle LSH 2.1.4 on 11g Release 2 to Oracle LSH 2.2
• Migrate the Oracle Warehouse Builder Stores (Conditional)
  • 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)