Table of Contents

• Title and Copyright Information
• Preface
  • Documentation accessibility
  • Related resources
  • Access to Oracle Support
• 1 System Requirements and Technology Stack
  • System Requirements
    • Operating Systems
      • Database Tier
      • Middle Tier
    • Hardware
  • Technology Stack
    • Supported Browsers
• 2 Install Oracle Life Sciences Data Hub
• 3 Install Oracle WebLogic Server
  • Install Oracle Java Development Kit
  • Install Oracle WebLogic Server
    • Install Oracle WebLogic Server 12.2.1.3
  • Create Database Schemas to Use with Oracle Fusion Middleware
  • Create a WebLogic Server Domain for Oracle DMW
    • Advanced Configuration
    • Select Oracle Common Options
    • Select Templates
    • Select Development Mode
    • Create a WebLogic Server "Machine"
    • Create a Managed Server and Assign it to the Machine
    • Deployment Targeting
    • Services Targeting
    • Support SSL Wildcards and SSL Web Services
    • Restart the WebLogic Server
  • Copy runtime12.jar into the Domain's lib Directory
  • Edit setDomainEnv.sh
  • Change the Default Timeout Period (Optional)
  • Restart the WebLogic Server
  • Start the Node Manager and Check Settings
  • Restart WebLogic Server and Check Settings
  • Change WebLogic Server to Production
  • Enable E-Business Suite User Authentication
    • Prepare the Oracle Applications Server to Receive Messages from Oracle DMW
      • Copy the Database Connection File
      • Download and Install the Software Development Kit for Java
      • Register the External Node and Generate the Desktop DBC File
      • Create the Required User [e-mail]
    • Configure AppDataSource on the WebLogic Server
      • Rebuild the fndext.jar file file for Oracle WebLogic Server on UNIX/LINUX
      • Deploy AppsDataSource Code on the Oracle WebLogic Server
      • Configure the AppsDataSource in the Administration Console
        • Create Data Source lswdbBC4JDS
        • Create Data Source lswdbDS
        • Create Data Source lswExtSysDS
        • Create Data Source lswdbRestDS
      • Enable CLOB Support
    • Prepare a Security Realm on the WebLogic Server
      • Create Users and Assign Groups in the Realm
      • Set the Default Realm
  • Configure the DMWServer Managed Server
    • Apply the JRF Template to DMWServer
    • Apply the JSF Library to the Oracle DMW Domain
    • Change the Connection Pool Maximum Capacity on DMWServer
    • Clear the Listen Address
    • Change Targets for "em" Deployment
    • Open port 47632
  • Apply Oracle ADF Patch 26834987
• 4 Deploy Oracle DMW on the WebLogic Server
  • Deploy Oracle DMW with Default Support for HTTPS
  • Deploy Oracle DMW and Disable HTTPS Support
  • Check for and Install Any Oracle DMW 2.5.x Patches
  • Run the Health Check Scripts
• 5 Integrate Oracle Health Sciences InForm
  • Get a CA Certificate if You Use HTTPS
  • Use Character Semantics
  • Create Oracle Accounts for the Oracle DMW InForm Connector
    • Create Directory on Each InForm Database
    • Copy Scripts
    • Run the Driver Script
  • Set Up the InForm Adapter
    • Install the InForm Adapter
    • Register the InForm Server Adapter
    • Register Each Trial
    • Check the InForm Integration
    • Create InForm Users
• 6 Configure File Watcher Support
  • Set Up the Distributed Processing Server
  • Create Directories
    • Create Watched Folders
    • Create Archive Folders (Optional)
  • Secure Files in Folders
  • Configure Server Time Zone Settings
    • Set the TZ Environment Variable Manually
    • Set the TZ Environment Variable Automatically
    • Use the tzselect Utility
    • Verify the Time Zone Setting Used by Java Virtual Machine (JVM)
  • Complete Your File Watcher Configuration
• 7 Install Oracle Thesaurus Management System (Optional)
  • Install Oracle Thesaurus Management System
  • Edit setDomainEnv.sh
  • Run Script dmetmsseeddata.sql
• 8 Upgrade to Release 2.5
  • Upgrade Oracle Life Sciences Data Hub
  • Run the Oracle DMW Scripts
    • Run the Populate Validation Checks Script
    • Run the Transformation Upgrade Script
    • Run the Last Modification Column Script
  • Install the Latest Version of JDK
  • Apply WLS Patch 12.2.1.3
  • Enable WLS Policy Manager
    • Create the Metadata Services Repository Schema in the Database
    • Extend Your WebLogic Server Domain
    • Support SSL Wildcards and Web Services
  • Edit setDomainEnv.sh
  • Restart WebLogic Server
  • Run the Health Check Scripts
  • Deploy Oracle DMW to the WebLogic Server
  • Update InForm Setup
  • Upgrade File Watcher to Support Archiving Files (Optional)
  • Install Oracle Thesaurus Management System (Optional)
• 9 What's Next
  • Set Up System Security
  • Set Up User Security
  • Set Up Oracle LSH Services
    • Distributed Processing Services for File Watcher
    • PLSQL Service Instances for InForm Metadata and Data Loading and PL/SQL Jobs
  • Assign User Group to InForm Family Adapter
  • Set Required Profile and Lookup Settings
  • Create Study and Library Categories in Oracle LSH
  • Set Up File Watcher
  • Set Up Logging
  • Integrate Other Applications (Optional)
• 10 Architecture
  • Client Tier
  • Application Tier
    • Oracle Life Sciences Data Hub Application Tier
    • Oracle Health Sciences Data Management Workbench Application Tier
  • Database Tier