Table of Contents

• Title and Copyright Information
• Access to Oracle Support
• Preface
  • Documentation accessibility
  • Related resources
• 1 Before You Begin
  • Check for the Most Recent Information
  • Get Your Company ID from Oracle
  • Assemble the Software
    • Get the Oracle Life Sciences Warehouse 2.5 Media Pack
    • Download Software to a Staging Area
  • Assemble the Documentation
    • Books
    • My Oracle Support Articles
      • System Requirements and Technology
      • Installing Oracle Applications and Oracle Database
      • Installing Oracle Life Sciences Data Hub
      • Upgrading to Oracle Life Sciences Data Hub Release 2.5
      • Other Documents Related to Oracle Life Sciences Data Hub
• 2 System Requirements and Technology Stack
  • System Requirements
    • Operating Systems
      • Database Tier
      • Application Tier
      • Clients
    • 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 and Apply Patches
    • Install Patches Using Autopatch
    • Download and Install the Software Development Kit for Java
  • Upgrade the Oracle Database and Oracle Warehouse Builder to 11.2.0.4
  • Edit listener_ifile.ora
  • Change Default Password Settings
  • Increase JVM Memory
  • Secure the Oracle Applications Installation
  • Clone the Environment (Optional)
  • Install Oracle Warehouse Builder on Oracle Database 11gR2
  • Create an Oracle Warehouse Builder Repository
• 4 Installing the Oracle TMS Database Tier
• 5 Installing Oracle Life Sciences Data Hub
  • Apply the Oracle Life Sciences Data Hub AD Splicer Patch
  • Grant Execute Privileges to the APPS Schema
  • Install Oracle LSH 2.5
  • Install Online Help
  • Run the Health Check Scripts
  • 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 APPS Password in OWB
  • Gather Statistics on Schemas
  • Schedule the Context Index Refresh Program
  • Start Journaling Internal Tables
    • Set AuditTrail:Activate Profile to Yes
    • Define the Audit Installation
    • Prevent Error
    • Run the Audit Trail Update Tables Concurrent Program
  • Increase Memory Available for MetaData Reports
  • Grant Security Rights to Seeded Adapters
  • Create CDR_USER Role
  • Set Up the Notification Mailer
  • Set Up the Distributed Processing Server
    • Create the Distributed Processing Server User Account
    • Install the Distributed Processing Server
    • Secure Distributed Processing Server Files
    • Set NLS_LANG to UTF8
      • Windows
      • UNIX
    • Copy and Edit Files
      • Copy DP Server Files
      • Edit the DP Server Start Script
      • Make Scripts Executable
      • Copy RTF Template Files for XML Publisher
      • Copy, Edit, and Grant Permissions to 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 and Configure Java Web Start in Oracle E-Business Suite
• 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 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.x for Visualizations
      • Install OBIEE
      • Install the Oracle LSH DP Server
      • Set Up OBIEE 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 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.5
  • Supported Upgrade Path
  • Upgrade to Oracle LSH 2.4, then 2.4.7, then 2.4.8 or 2.4.9
  • Stop Server Processes
  • Upgrade and Configure Oracle Database and Oracle Warehouse Builder 11.2.0.4
  • Upgrade Oracle Thesaurus Management System Database to 5.3
    • Upgrade the TMS Database to Release 5.3
  • OBIEE 10g and 11g Options
    • OBIEE 11g
      • 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
  • Upgrade Integration with Oracle Business Intelligence Publisher
  • Upgrade to Oracle Life Sciences Data Hub 2.5
    • Database Tier Preinstallation Steps
      • Stop the Message and Job Queues
      • Abort the Long-Running Jobs
      • Cancel the Sessions Holding Locks on Application Objects
      • Disconnect Blocking Sessions
    • Apply the Oracle Warehouse Builder (OWB) Patch
    • Install Oracle Life Sciences Data Hub 2.5
    • Change Your FND_Validation_Level Profile
  • Complete the Oracle Warehouse Builder Update
    • Restart OWB
    • Reset the Store Passwords
  • Upgrade the Distributed Processing Server User Account
  • Upgrade the Distributed Processing Server
  • Perform the Remaining Post-Installation Tasks
  • Run the Script for RFID 27629203
  • Set the Profile Value for DMW_SEND_BATCHSIZE
  • Set the Required Profile Values for Sending Discrepancies to External Systems
    • Change the Value of the Profile Options
  • Start Queues
    • Start the Message Queue
    • Restart and Enable the Job Queue
  • Start Server Processes
  • Run the Health Check Scripts
• 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