Table of Contents

• Title and Copyright Information
• Preface
  • Documentation accessibility
  • Diversity and Inclusion
  • Related resources
  • Access to Oracle Support
• 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 3.0 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
      • 1.4.2.1 System Requirements and Technology
      • 1.4.2.2 Installing Oracle Applications and Oracle Database
      • 1.4.2.3 Installing Oracle Life Sciences Data Hub
      • 1.4.2.4 Upgrading to Oracle Life Sciences Data Hub Release 3.0
      • 1.4.2.5 Other Documents Related to Oracle Life Sciences Data Hub
• 2 System Requirements and Technology Stack
  • 2.1 System Requirements
    • 2.1.1 Operating Systems
      • 2.1.1.1 Database Tier
      • 2.1.1.2 Application Tier
      • 2.1.1.3 Clients
    • 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 to Oracle Database 11.2.0.4
  • 3.4 Change Default Password Settings
  • 3.5 Increase JVM Memory
  • 3.6 Secure the Oracle Applications Installation
  • 3.7 Clone the Environment (Optional)
  • 3.8 Upgrade to Oracle Database 19c (19.8)
    • 3.8.1 Perform Oracle Database 19c Post-Upgrade Tasks
      • 3.8.1.1 Apply Patches for Oracle Database 19c
      • 3.8.1.2 Update PDB GLOBAL_NAME to Uppercase
      • 3.8.1.3 Unset optimizer_features_enable
      • 3.8.1.4 Set FILESYSTEMIO_OPTIONS to SETALL
      • 3.8.1.5 Check job_queue_processes
      • 3.8.1.6 Set Parameter Values
      • 3.8.1.7 Create New Indexes
      • 3.8.1.8 Set the PL/SQL Service Instances Value
      • 3.8.1.9 Gather Statistics
      • 3.8.1.10 Compile Invalid Objects
      • 3.8.1.11 Restart and Enable the Job Queue
• 4 Installing the Oracle TMS Database Tier
• 5 Installing 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 3.0
  • 5.4 Apply Patch 32199023
  • 5.5 Install Online Help
  • 5.6 Install the CdrRuntime.jar File
  • 5.7 Check Non-Default Service
  • 5.8 Set CDR_DB_SERVICE_NAME
  • 5.9 Set CDR_SCAN_HOST_NAME
  • 5.10 Set CDR_SCAN_PORT_NUM
  • 5.11 Run the Health Check Scripts
  • 5.12 Create System Administrator and Security Administrator Users
    • 5.12.1 Log on as sysadmin
    • 5.12.2 Create a User Account for the Administrator
    • 5.12.3 Assign a Role
  • 5.13 Set Profile Values for Load Balancing and Service Name
  • 5.14 Run the Post-Installation Programs
    • 5.14.1 Log On to Oracle Applications
    • 5.14.2 Load the Adapter Files
    • 5.14.3 Set the Tech Type Value
    • 5.14.4 Run the Post-Installation Program
      • 5.14.4.1 Change a Post-Installation Job Parameter Value
  • 5.15 Gather Statistics on Schemas
  • 5.16 Schedule the Context Index Refresh Program
  • 5.17 Start Journaling Internal Tables
    • 5.17.1 Set AuditTrail:Activate Profile to Yes
    • 5.17.2 Define the Audit Installation
    • 5.17.3 Prevent Error
    • 5.17.4 Run the Audit Trail Update Tables Concurrent Program
  • 5.18 Increase Memory Available for MetaData Reports
  • 5.19 Grant Security Rights to Seeded Adapters
  • 5.20 Create CDR_USER Role
  • 5.21 Set Up the Notification Mailer
  • 5.22 Set Up the Distributed Processing Server
    • 5.22.1 Create the Distributed Processing Server User Account
    • 5.22.2 Install the Distributed Processing Server
    • 5.22.3 Secure Distributed Processing Server Files
    • 5.22.4 Set NLS_LANG to UTF8
      • 5.22.4.1 Windows
      • 5.22.4.2 UNIX
    • 5.22.5 Copy and Edit Files
      • 5.22.5.1 Copy DP Server Files
      • 5.22.5.2 Edit the DP Server Start Script
      • 5.22.5.3 Make Scripts Executable
      • 5.22.5.4 Copy RTF Template Files for XML Publisher
      • 5.22.5.5 Copy, Edit, and Grant Permissions to Execution Command Files for Processing Engines
    • 5.22.6 Define Service Locations and Services
    • 5.22.7 Start the DP Server
    • 5.22.8 Start the Message Queue
  • 5.23 Set Up Client Computers
    • 5.23.1 Consumers and Administrators
    • 5.23.2 Application Developers
      • 5.23.2.1 Install the Client Plug-In
      • 5.23.2.2 Set NLS_LANG to UTF8
      • 5.23.2.3 Set Up Development Environments
  • 5.24 Install and Configure Java Web Start in Oracle E-Business Suite
  • 5.25 Register Scheduler Job Events to Scheduler Queue
  • 5.26 Mark the OWBSYS Job as Broken
• 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.2.1 Integrate the SAS Server with Oracle LSH
      • 6.2.2.2 Start SAS in UTF8 Mode
    • 6.2.3 Set Up Loading Data from SAS
    • 6.2.4 Set Up SAS as an Integrated Development Environment
  • 6.3 Integrating Oracle SQL Developer or Oracle SQL*Plus with the Oracle Life Sciences Data Hub
    • 6.3.1 Set the NLS_LANG Environment Variable to UTF8
      • 6.3.1.1 Windows
      • 6.3.1.2 UNIX
  • 6.4 Integrating Oracle Business Intelligence Enterprise Editions (OBIEE) for Visualizations
    • 6.4.1 Install Oracle Business Intelligence Enterprise Edition 12.2.1.4 for Visualizations
      • 6.4.1.1 Install Oracle Business Intelligence Enterprise Edition
      • 6.4.1.2 Disable Oracle Business Intelligence Enterprise Edition 12c Enterprise Manager SSO authentication
      • 6.4.1.3 Start the WebLogic Server
      • 6.4.1.4 Install the Oracle LSH DP Server
        • 6.4.1.4.1 Copy and Edit Execution Command Scripts
      • 6.4.1.5 Deploy Repository File
      • 6.4.1.6 Set Up Oracle Business Intelligence Enterprise Edition Visualizations
• 7 Upgrading to Oracle Life Sciences Data Hub Release 3.0
  • 7.1 Supported Upgrade Path
  • 7.2 Run the Start Maintenance Script
  • 7.3 Stop Server Processes
  • 7.4 Back Up the Oracle E-Business Suite Database
  • 7.5 Upgrade to Oracle Database 19c
  • 7.6 Upgrade the Thesaurus Management System Database (TMS) to Release 5.3.1
  • 7.7 Oracle Business Intelligence Enterprise Edition 12c
    • 7.7.1 Install the Software
    • 7.7.2 Copy and Edit Revised Execution Command Scripts
    • 7.7.3 Starting the WebLogic Server
  • 7.8 Upgrade to Oracle Life Sciences Data Hub 3.0
    • 7.8.1 Database Tier Preinstallation Steps
      • 7.8.1.1 Abort the Long-Running Jobs
      • 7.8.1.2 Cancel the Sessions Holding Locks on Application Objects
      • 7.8.1.3 Disconnect Blocking Sessions
    • 7.8.2 Install Oracle Life Sciences Data Hub 3.0
    • 7.8.3 Reinstall Existing Oracle LSH Workflows
    • 7.8.4 Change Your FND_Validation_Level Profile
    • 7.8.5 Check Non-Default Service
    • 7.8.6 Turn off EXE DEBUG
    • 7.8.7 Set CDR_DB_SERVICE_NAME
    • 7.8.8 Set CDR_SCAN_HOST_NAME
    • 7.8.9 Set CDR_SCAN_PORT_NUM
  • 7.9 Set Profile Values for Load Balancing and Service Name
  • 7.10 Upgrade the Distributed Processing Server User Account
  • 7.11 Upgrade the Distributed Processing Server
  • 7.12 Perform the Remaining Post-Installation Tasks
  • 7.13 Set the Profile Value for DMW_SEND_BATCHSIZE
  • 7.14 Set the Required Profile Values for Sending Discrepancies to External Systems
    • 7.14.1 Change the Value of the Profile Options
  • 7.15 Register Scheduler Job Events to Scheduler Queue
  • 7.16 Mark the OWBSYS Job as Broken
  • 7.17 Run the Stop Maintenance Script
  • 7.18 Start Server Processes
  • 7.19 Run the Health Check Scripts
• 8 What's Next
• 9 Change Record
• 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