Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Finding Information and Patches on My Oracle Support
• Finding Oracle Documentation
• Related Documents
• Conventions

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 and Patch Oracle WebLogic Server
  • 3.2.1 Install Oracle WebLogic 10.3.6
  • 3.2.2 Apply Patch 10.3.6.0.8
• 3.3 Install and Upgrade Oracle Application Developer Framework
  • 3.3.1 Install Oracle Application Developer Framework
  • 3.3.2 Upgrade ADF to 11.1.2.4
• 3.4 Create the Metadata Services Repository Schema in the Database
• 3.5 Create a WebLogic Server Domain for Oracle DMW
  • 3.5.1 Select Oracle Common Options
  • 3.5.2 Select Development Mode
  • 3.5.3 Create a WebLogic Server "Machine"
  • 3.5.4 Create a Managed Server and Assign it to the Machine
  • 3.5.5 Configure the JDBC Schema
  • 3.5.6 Support SSL Wildcards and SSL Web Services
  • 3.5.7 Restart the WebLogic Server
• 3.6 Upgrade ADF in the Oracle DMW Domain
• 3.7 Copy runtime12.jar into the Domain's lib Directory
• 3.8 Edit setDomainEnv.sh
• 3.9 Restart the WLS Server
• 3.10 Change the Default Timeout Period (Optional)
• 3.11 Start the Node Manager and Check Settings
• 3.12 Restart WebLogic Server and Check Settings
• 3.13 Change WebLogic Server to Production
• 3.14 Enable E-Business Suite User Authentication
  • 3.14.1 Prepare the Oracle Applications Server to Receive Messages from Oracle DMW
    • 3.14.1.1 Copy the Database Connection File
    • 3.14.1.2 Download and Install the Software Development Kit for Java
    • 3.14.1.3 Register the External Node and Generate the Desktop DBC File
    • 3.14.1.4 Create the Required User [e-mail]
  • 3.14.2 Configure AppDataSource on the WebLogic Server
    • 3.14.2.1 Rebuild the fndext.jar file file for Oracle WebLogic Server on UNIX/LINUX
    • 3.14.2.2 Deploy AppsDataSource Code on the Oracle WebLogic Server
    • 3.14.2.3 Configure the AppsDataSource in the Administration Console
    • 3.14.2.4 Enable CLOB Support
  • 3.14.3 Prepare a Security Realm on the WebLogic Server
• 3.15 Configure the DMWServer Managed Server
  • 3.15.1 Apply the JRF Template to DMWServer
  • 3.15.2 Apply the JSF Library to the Oracle DMW Domain
  • 3.15.3 Change the Connection Pool Maximum Capacity on DMWServer
  • 3.15.4 Clear the Listen Address
  • 3.15.5 Set Up HTTPS
• 3.16 Restart the WebLogic Server

4 Deploy Oracle DMW on the WebLogic Server

• 4.1 Deploy with Default Support for HTTPS
• 4.2 Alternative Oracle DMW Deployment Disabling HTTPS Support
• 4.3 Apply the Latest Patch Set
• 4.4 Check for and Install Oracle DMW Release 2.4.x Patches

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 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 Installing Oracle Thesaurus Management System (Optional)

• 7.1 Install Oracle Thesaurus Management System
• 7.2 Edit setDomainEnv.sh
• 7.3 Run Script dmetmsseeddata.sql

8 Internet Explorer Settings

9 Upgrading to Release 2.4

• 9.1 Upgrade Oracle Life Sciences Data Hub
• 9.2 Install the Latest Version of JDK
• 9.3 Apply WLS Patch 10.3.6.0.8
• 9.4 Enable WLS Policy Manager
  • 9.4.1 Create the Metadata Services Repository Schema in the Database
  • 9.4.2 Extend Your WebLogic Server Domain
  • 9.4.3 Support SSL Wildcards and SSL Web Services
• 9.5 Edit setDomainEnv.sh
• 9.6 Restart the WebLogic Server
• 9.7 Deploy Oracle DMW to the WebLogic Server
• 9.8 Update InForm Setup
• 9.9 Upgrade File Watcher to Support Archiving Files (Optional)
• 9.10 Install Oracle Thesaurus Management System (Optional)

10 What's Next

• 10.1 Set Up System Security
• 10.2 Set Up User Security
• 10.3 Set Up Oracle LSH Services
  • 10.3.1 Distributed Processing Services for File Watcher
  • 10.3.2 PLSQL Service Instances for InForm Metadata and Data Loading and PL/SQL Jobs
• 10.4 Assign User Group to InForm Family Adapter
• 10.5 Set Required Profile and Lookup Settings
• 10.6 Create Study and Library Categories in Oracle LSH
• 10.7 Set Up File Watcher
• 10.8 Integrate Other Applications (Optional)

11 Architecture

• 11.1 Client Tier
• 11.2 Application Tier
  • 11.2.1 Oracle Life Sciences Data Hub Application Tier
  • 11.2.2 Oracle Health Sciences Data Management Workbench Application Tier
• 11.3 Database Tier