Table of Contents

• Title and Copyright Information
• Preface
  • Documentation accessibility
  • Diversity and Inclusion
  • Related resources
  • Access to Oracle Support
• 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 3.3 Media Pack
    • Download Software to a Staging Area
  • Assemble the Documentation
    • Books
    • My Oracle Support Articles
      • System Requirements and Technology
      • Upgrading to Oracle Life Sciences Data Hub Release 3.3
      • 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
• 3 Installing and Patching Oracle Applications and Oracle Database
  • Install Oracle Applications 12.2.0
    • Oracle LSH UTF8 Requirements
  • Upgrade Oracle Applications from 12.2.0 to 12.2.9
  • Upgrade the Oracle Database from 12c to 19c
  • Perform Oracle Database 19c Post-Upgrade Tasks
    • Apply Patches for Oracle Database 19c
    • Update PDB GLOBAL_NAME to Uppercase
    • Unset optimizer_features_enable
    • Set FILESYSTEMIO_OPTIONS to SETALL
    • Check job_queue_processes
    • Set Parameter Values
    • Create New Indexes
    • Set the PL/SQL Service Instances Value
    • Gather Statistics
    • Compile Invalid Objects
  • Apply the Additional EBS Patches
  • Clone the Environment (Optional)
  • Create Tablespace CDR_BLOB_DATA_TS
  • Ensure Enough Space is Available in Tablespace APPS_TS_MEDIA
• 4 Installing the Oracle TMS Database Tier
• 5 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 Oracle Analytics Server 12.2.1.4 for Visualizations
      • Install Oracle Analytics Server
      • Disable Oracle Analytics Server 12c Enterprise Manager SSO authentication
      • Start the WebLogic Server
      • Install the Oracle LSH DP Server
        • Copy and Edit Execution Command Scripts
      • Deploy Repository File
      • Set Up Oracle Analytics Server Visualizations
• 6 Supported Upgrade Path
• 7 Upgrade the Thesaurus Management System Database (TMS) to Release 5.4
• 8 Upgrading to Oracle Life Sciences Data Hub Release 3.3
  • Run the Start Maintenance Script
  • Stop Server Processes
  • Back Up the Oracle E-Business Suite Database
  • Upgrade to Oracle Life Sciences Data Hub 3.3
    • Database Tier Preinstallation Steps
      • Abort the Long-Running Jobs
      • Cancel the Sessions Holding Locks on Application Objects
      • Disconnect Blocking Sessions
    • Install Oracle LSH 3.3
    • Install the CdrRuntime.jar File
  • Run the Post-Installation Programs
    • Log On to Oracle Applications
    • Load the Adapter Files
    • Run the Post-Installation Concurrent Program
    • Grant Security Rights to Seeded Adapters
  • Post-Upgrade Database Tasks
  • 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
    • Start the Message Queue
    • Restart and Enable the Job Queue
  • Run the Stop Maintenance Script
  • Start Server Processes
  • Run the Health Check Scripts
  • Migrate Secure File
    • Initiate the Secure File Migration of CDR_INSTALLATION_LOG
    • Monitor the Secure File Migration of CDR_INSTALLATION_LOG
    • Post Secure File Migration Task for CDR_INSTALLATION_LOG
    • Initiate the Secure File Migration of CDR_OUTPUT_BLOBS
    • Monitor the Secure File Migration of CDR_OUTPUT_BLOBS
    • Post Secure File Migration Task for CDR_OUTPUT_BLOBS
• 9 What's Next
• 10 Revision History
• 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