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 7
• 3.2 Install the Oracle WebLogic Server
• 3.3 Install Oracle Application Developer and Apply Patches
  • 3.3.1 Install Oracle Application Developer Framework
  • 3.3.2 Apply Required Oracle Application Developer Framework Patches to Upgrade to 11.1.2.2.0
• 3.4 Create a WebLogic Server Domain for Oracle DMW
  • 3.4.1 Create a Machine
  • 3.4.2 Create a Managed Server and Assign it to the Machine
  • 3.4.3 Select Oracle Common Options
• 3.5 Apply the JSF Library to the Oracle DMW Domain
• 3.6 Copy runtime12.jar into the Domain's lib Directory
• 3.7 Edit setDomainEnv.sh
• 3.8 Restart the Computer
• 3.9 Enable E-Business Suite User Authentication
  • 3.9.1 Prepare the Oracle Applications Server to Receive Messages from Oracle DMW
    • 3.9.1.1 Copy the Database Connection File
    • 3.9.1.2 Download and Install the Software Development Kit for Java
    • 3.9.1.3 Register the External Node and Generate the Desktop DBC File
    • 3.9.1.4 Create the Required User [e-mail]
  • 3.9.2 Configure AppDataSource on the WebLogic Server
    • 3.9.2.1 Rebuild the fndext.jar file file for Oracle WebLogic Server on UNIX/LINUX
    • 3.9.2.2 Deploy AppsDataSource Code on the Oracle WebLogic Server
    • 3.9.2.3 Configure the Data Source in the Administration Console
    • 3.9.2.4 Enable CLOB Support
  • 3.9.3 Prepare a Security Realm on the WebLogic Server
• 3.10 Configure the DMWServer Managed Server
  • 3.10.1 Apply the JRF Template to DMWServer
  • 3.10.2 Deploy the JSF2.0 Library to DMWServer
  • 3.10.3 Change the Connection Pool Maximum Capacity on DMWServer
  • 3.10.4 Clear the Listen Address
  • 3.10.5 Set Up HTTPS
• 3.11 Stopping and Starting the WebLogic Servers

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

5 Integrate Oracle Health Sciences InForm

• 5.1 Use Character Semantics
• 5.2 Create Oracle Accounts for the Oracle DMW InForm Connector
  • 5.2.1 Create Directory on Each InForm Database
  • 5.2.2 Copy Scripts
  • 5.2.3 Run the Driver Script
  • 5.2.4 Create Users in InForm
• 5.3 Set Up the InForm Adapter
  • 5.3.1 Install the InForm Adapter
  • 5.3.2 Register the InFormServerAdapter
  • 5.3.3 Register Each Trial
• 5.4 Configure the WebLogic Server for Sending Discrepancies to InForm Supporting HTTPS
  • 5.4.1 Create Custom WebLogic Keystores
  • 5.4.2 Set Up Custom Keystores
  • 5.4.3 Generate a Private-Public Key Pair and Set the Validity Period
  • 5.4.4 Set the Alias
  • 5.4.5 Set SSL-Related Settings
  • 5.4.6 Restart the WebLogic Server

6 Configure File Watcher Support

• 6.1 Secure Files in Watched Locations
• 6.2 Configure Server Time Zone Settings
  • 6.2.1 Set the TZ Environment Variable Manually
  • 6.2.2 Set the TZ Environment Variable Automatically
  • 6.2.3 Use the tzselect Utility
  • 6.2.4 Verify the Time Zone Setting Used by Java Virtual Machine (JVM)

7 What's Next

• 7.1 Set Up System Security
• 7.2 Set Up User Security
• 7.3 Set Up Oracle LSH Services
  • 7.3.1 Distributed Processing Services for File Watcher
  • 7.3.2 PLSQL Service Instances for InForm Metadata and Data Loading and PL/SQL Jobs
• 7.4 Assign User Group to InForm Family Adapter
• 7.5 Set Required Profile Settings
  • 7.5.1 Use Character Semantics
  • 7.5.2 Increase the Maximum Number of Nested Domains
  • 7.5.3 Set Login-Related Profile Values
  • 7.5.4 DMW: Append Username to Discrepancy Text
• 7.6 Create Study and Library Categories in Oracle LSH
• 7.7 Integrate Other Applications (Optional)

8 Architecture

• 8.1 Client Tier
• 8.2 Application Tier
  • 8.2.1 Oracle Life Sciences Data Hub Application Tier
  • 8.2.2 Oracle Health Sciences Data Management Workbench Application Tier
• 8.3 Database Tier