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

1 Before You Begin

• Get Your Company ID from Oracle
• Check My Oracle Support
• Assemble the Software
  • Get the Oracle Life Sciences Data Hub 2.1.4 Media Pack
  • Set Up a Staging Area
• Assemble the Documentation
  • Books
  • My Oracle Support Articles
    • System Requirements and Technology
    • Installing Oracle Applications
    • Upgrading the Database and Patching Applications
    • Installing the Oracle Thesaurus Management System
    • Installing the Oracle Life Sciences Data Hub
    • Installing Real Application Clusters (RAC)
    • Configuration Information

2 System Requirements and Technology Stack

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

3 Installing Oracle Applications

• Install Oracle Applications 11.5.10.2
  • Oracle LSH UTF8 Requirements
• Edit oraenv (HP-UX Only)
• Increase JVM Memory
• Migrate from JInitiator to J2SE 5

4 Upgrading the Database and Patching Oracle Applications

• Upgrade the Database to 9.2.0.8
• Apply Required Oracle Applications Patches
• Upgrade to J2SE 6
• Upgrade the Database to 11.2.0.1
• Apply Database Patches
• Edit listener_ifile.ora
• Change Default Password Settings
• Clone the Environment (Optional)

5 Patching Oracle Warehouse Builder

• Apply OWB Patches
• Create Tablespaces
• Create the OWBSYS Schema
• Point to the 11gR2 Oracle Home
• Create New OWB Workspace for CDR_RTREPOS
• Set Up Your Environment
• (Optional) Install Oracle Warehouse Builder 10.2.0.1

6 Installing Oracle Thesaurus Management System

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

7 Installing the Oracle Life Sciences Data Hub

• Install the AD Splicer
  • Check for the APPS_TS_TOOLS Tablespace
  • Apply the AD Splicer Patch
• Install Oracle LSH Release 2.1.4
• 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
  • Stop and Start 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
  • 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

8 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
• Installing Oracle Discoverer 10.1.2.3
• 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 with the Oracle Life Sciences Data Hub
  • Install Oracle Business Intelligence Enterprise Edition
    • Install OBIEE
    • Install the Oracle LSH DP Server
  • Set Up Oracle Business Intelligence Publisher (Oracle BIP) Programs
    • Enable Program Execution
    • Set Up Security
    • Set Up Business Intelligence Publisher Definer Tools
  • Set Up OBIEE Visualizations
    • Install Presentation Services on the Same Computer
    • (Optional) Install Presentation Services on Another Computer
    • Set Up OBIEE Service Locations and Services
    • Set Up Database Connectivity
    • Assign Repository Filename(s) to each Oracle BI Presentation Services Instance
    • Set Up Oracle Business Intelligence Administration Tool

9 Upgrading to Oracle Life Sciences Data Hub Release 2.1.4

• Supported Upgrade Paths
• Stop Server Processes
• Patch Oracle Applications
  • Apply Oracle Applications 11i Rollup Patch 7
  • Apply Oracle Applications Patches
• Upgrade the Database to 11.2.0.1
• Change Default Password Settings
• Upgrade Oracle Warehouse Builder
• Upgrade Oracle Thesaurus Management System to 4.6.1
• (Optional) Upgrade Informatica PowerCenter to 8.6.1, Hotfix 11
• (Optional) Install OBIEE 10.1.3.4.1
• Migrate the Oracle Warehouse Builder Repository
  • Create the OWBSYS Schema and Grant Privileges
    • Create the Schema
    • Grant Required Privileges
  • Point to the 11gR2 Oracle Home
  • 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
    • 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
  • Stop and Start the OWB Service
    • Stop the OWB Service
    • Start the OWB Service
  • Run the Migration Script
  • Export the OWB Repository Owned by User CDR_RTREPOS
  • Stop the 10g OWB Service
  • Import the OWB Repository
• 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
• Do the Remaining Post-Installation Tasks
• Start Server Processes

10 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 Patching the OWB Service

C Installing Real Application Clusters (RAC)

• Required Setup
• Installing RAC