Table of Contents

• Title and Copyright Information
• Preface
  • Documentation accessibility
  • Related resources
  • Access to Oracle Support
• 1 System Requirements and Technology Stack
  • 1.1 System Requirements
    • 1.1.1 Operating Systems
      • 1.1.1.1 Database Tier
      • 1.1.1.2 Middle Tier
    • 1.1.2 Hardware
  • 1.2 Technology Stack
    • 1.2.1 Supported Browsers
• 2 Install Oracle Life Sciences Data Hub
• 3 Install Oracle WebLogic Server
  • 3.1 Install Oracle Java Development Kit
  • 3.2 Install Oracle WebLogic Server
    • 3.2.1 Install Oracle WebLogic Server 12.2.1.4
    • 3.2.2 Create Database Schemas to Use with Oracle Fusion Middleware
  • 3.3 Create a WebLogic Server Domain for Oracle DMW
    • 3.3.1 Select Templates
    • 3.3.2 Select Development Mode
    • 3.3.3 Advanced Configuration
    • 3.3.4 Create a WebLogic Server "Machine"
    • 3.3.5 Create a Managed Server and Assign it to the Machine
    • 3.3.6 Deployment Targeting
    • 3.3.7 Services Targeting
    • 3.3.8 Support SSL Wildcards and SSL Web Services
    • 3.3.9 Restart the WebLogic Server
  • 3.4 Copy runtime12.jar into the Domain's lib Directory
  • 3.5 Edit setDomainEnv.sh
  • 3.6 Change the Default Timeout Period (Optional)
  • 3.7 Restart the WebLogic Server
  • 3.8 Start the Node Manager and Check Settings
  • 3.9 Restart WebLogic Server and Check Settings
  • 3.10 Change WebLogic Server to Production
  • 3.11 Enable E-Business Suite User Authentication
    • 3.11.1 Prepare the Oracle Applications Server to Receive Messages from Oracle DMW
      • 3.11.1.1 Copy the Database Connection File
      • 3.11.1.2 Download and Install the Software Development Kit for Java
      • 3.11.1.3 Register the External Node and Generate the Desktop DBC File
      • 3.11.1.4 Create the Required User [e-mail]
    • 3.11.2 Configure AppDataSource on the WebLogic Server
      • 3.11.2.1 Rebuild the fndext.jar file file for Oracle WebLogic Server on UNIX/LINUX
      • 3.11.2.2 Deploy AppsDataSource Code on the Oracle WebLogic Server
      • 3.11.2.3 Configure the AppsDataSource in the Administration Console
        • 3.11.2.3.1 Create Data Source lswdbBC4JDS
        • 3.11.2.3.2 Create Data Source lswdbDS
        • 3.11.2.3.3 Create Data Source lswExtSysDS
        • 3.11.2.3.4 Create Data Source lswdbRestDS
        • 3.11.2.3.5 Run the Script to Create User CDRBC4JINTERNAL
        • 3.11.2.3.6 Run the Script to Grant Rights to the DMWMON User
      • 3.11.2.4 Enable CLOB Support
    • 3.11.3 Prepare a Security Realm on the WebLogic Server
      • 3.11.3.1 Create Users and Assign Groups in the Realm
      • 3.11.3.2 Set the Default Realm
  • 3.12 Configure the DMWServer Managed Server
    • 3.12.1 Apply the JRF Template to DMWServer
    • 3.12.2 Apply the JSF Library to the Oracle DMW Domain
    • 3.12.3 Change the Connection Pool Maximum Capacity on DMWServer
    • 3.12.4 Clear the Listen Address
    • 3.12.5 Change Targets for "em" Deployment
    • 3.12.6 Open port 47632
• 4 Deploy Oracle DMW on the WebLogic Server
  • 4.1 Download the Oracle DMW Folder
  • 4.2 Deploy Oracle DMW with Default Support for HTTPS
  • 4.3 Deploy Oracle DMW and Disable HTTPS Support
  • 4.4 Check for and Install Any Oracle DMW 3.0.x Patches
  • 4.5 Run the Health Check Scripts
• 5 Integrate Oracle Health Sciences InForm
  • 5.1 Get a CA Certificate if You Use HTTPS
  • 5.2 Use Character Semantics
  • 5.3 Create Oracle Accounts for the Oracle DMW InForm Connector
    • 5.3.1 Create Directory on Each InForm Database
    • 5.3.2 Copy Scripts
    • 5.3.3 Run the Driver Script
  • 5.4 Set Up the InForm Adapter
    • 5.4.1 Install the Oracle InForm Adapter
    • 5.4.2 Register the InForm Server Adapter
    • 5.4.3 Register Each Trial
    • 5.4.4 Check the InForm Integration
    • 5.4.5 Create InForm Users
• 6 Configure File Watcher Support
  • 6.1 Set Up the Distributed Processing Server
  • 6.2 Create Directories
    • 6.2.1 Create Watched Folders
    • 6.2.2 Create Archive Folders (Optional)
  • 6.3 Secure Files in Folders
  • 6.4 Configure Server Time Zone Settings
    • 6.4.1 Set the TZ Environment Variable Manually
    • 6.4.2 Set the TZ Environment Variable Automatically
    • 6.4.3 Use the tzselect Utility
    • 6.4.4 Verify the Time Zone Setting Used by Java Virtual Machine (JVM)
  • 6.5 Complete Your File Watcher Configuration
• 7 Install Oracle Thesaurus Management System (Optional)
  • 7.1 Install Oracle Thesaurus Management System
  • 7.2 Edit setDomainEnv.sh
  • 7.3 Run Script dmetmsseeddata.sql
• 8 Upgrade to Release 3.0
  • 8.1 Upgrade Oracle Life Sciences Data Hub
  • 8.2 Upgrade Oracle WebLogic Server
    • 8.2.1 Create a Backup of the Existing Environment
    • 8.2.2 Install Oracle Java Development Kit
    • 8.2.3 Install Oracle WebLogic Server 12.2.1.4
    • 8.2.4 Run the Upgrade Assistant for Readiness Check
    • 8.2.5 Run the Upgrade Assistant to Upgrade Database Schemas
    • 8.2.6 Run the Reconfiguration Wizard
    • 8.2.7 Run the Upgrade Assistant to Upgrade Domain Configurations
    • 8.2.8 Perform the Post-Upgrade Tasks
    • 8.2.9 Restart the Administration and Managed Servers
    • 8.2.10 Verfiy the Upgrade
    • 8.2.11 Support SSL Wildcards and SSL Web Services
  • 8.3 Run the Oracle DMW Scripts
    • 8.3.1 Run the Populate Validation Checks Script
    • 8.3.2 Run the Transformation Upgrade Script
    • 8.3.3 Run the Last Modification Column Script
  • 8.4 Apply WLS Patch 12.2.1.4
  • 8.5 Restart WebLogic Server
  • 8.6 Run the Health Check Scripts
  • 8.7 Deploy Oracle DMW to the WebLogic Server
  • 8.8 Upgrade File Watcher to Support Archiving Files (Optional)
  • 8.9 Install Oracle Thesaurus Management System (Optional)
• 9 What's Next
  • 9.1 Set Up System Security
  • 9.2 Set Up User Security
  • 9.3 Set Up Oracle LSH Services
    • 9.3.1 Distributed Processing Services for File Watcher
    • 9.3.2 PLSQL Service Instances for InForm Metadata and Data Loading and PL/SQL Jobs
  • 9.4 Assign User Group to InForm Family Adapter
  • 9.5 Set Required Profile and Lookup Settings
  • 9.6 Create Study and Library Categories in Oracle LSH
  • 9.7 Set Up File Watcher
  • 9.8 Set Up Logging
  • 9.9 Integrate Other Applications (Optional)
• 10 Architecture
  • 10.1 Client Tier
  • 10.2 Application Tier
    • 10.2.1 Oracle Life Sciences Data Hub Application Tier
    • 10.2.2 Oracle Health Sciences Data Management Workbench Application Tier
  • 10.3 Database Tier
• 11 Change Record