Skip Headers
Oracle® Health Sciences Data Management Workbench Installation Guide
Release 2.3
E35223-01
Next
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 dmwebs@oracle.com
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