Skip Headers
Oracle® Life Sciences Data Hub Installation Guide
Release 2.3
Part Number E35295-01
Home
Book List
Contact Us
Next
View PDF
Contents
List of Figures
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Finding Information and Patches on My Oracle Support
Finding Oracle Documentation
How to Use AutoPatch
Oracle CPU Security Updates
Related Documents
Conventions
1
Before You Begin
1.1
Check for the Most Recent Information
1.2
Get Your Company ID from Oracle
1.3
Assemble the Software
1.3.1
Get the Oracle Life Sciences Data Hub 2.3 Media Pack
1.3.2
Set Up a Staging Area
1.4
Assemble the Documentation
1.4.1
Books
1.4.2
My Oracle Support Articles
1.4.2.1
System Requirements and Technology
1.4.2.2
Installing Oracle Applications and Oracle Database
1.4.2.3
Installing the Oracle Life Sciences Data Hub
1.4.2.4
Upgrading to Oracle Life Sciences Data Hub Release 2.3
1.4.2.5
Other Oracle LSH-Related Documents
2
System Requirements and Technology Stack
2.1
System Requirements
2.1.1
Operating Systems
2.1.1.1
Application Tier
2.1.1.2
Database Tier
2.1.2
Hardware
2.2
Technology Stack
2.3
Integrated External Systems
2.4
Character Encoding Settings
3
Installing and Patching Oracle Applications and Oracle Database
3.1
Install Oracle Applications 12.1.1
3.1.1
Oracle LSH UTF8 Requirements
3.2
Upgrade Oracle Applications to R12.1.3
3.3
Upgrade the Oracle Database and OWB to 11.2.0.3 and Apply Patches
3.4
Edit listener_ifile.ora
3.5
Change Default Password Settings
3.6
Increase JVM Memory
3.7
Secure the Oracle Applications Installation
3.8
Clone the Environment (Optional)
3.9
Install Oracle Warehouse Builder on Oracle Database 11gR2
3.10
Create an Oracle Warehouse Builder Repository
4
Installing Oracle Thesaurus Management System
4.1
Set Up a Windows Computer for Launching the TMS Installation
4.2
Setting up the SQL*Net Connections for Existing Databases
4.3
Set Up Compatibility Mode
4.4
Install the TMS Server
4.5
Install the TMS Database
4.6
Apply TMS Patch
4.7
Check the def_instance_name Column Value
5
Installing the Oracle Life Sciences Data Hub
5.1
Apply the Oracle Life Sciences Data Hub AD Splicer Patch
5.2
Install Oracle LSH Release 2.3
5.3
Install Online Help
5.4
Grant Execute Privileges to the APPS Schema
5.5
Integrate Oracle LSH with the Oracle Warehouse Builder
5.5.1
Set Up Your Environment
5.5.1.1
Ensure that Oracle SID and Short Global Names Match
5.5.1.2
Edit init.ora
5.5.1.3
Restart the Database and Listener
5.5.1.4
Test Database Connectivity
5.5.2
Create Directories and Copy Files
5.5.3
Disable Application Server Authentication
5.5.4
Edit run_service.sh
5.5.5
Edit Runtime.properties
5.5.6
Edit owb.classpath
5.5.7
Edit Shell Scripts to Match Directory Structure
5.5.8
Run OWB Shell Scripts
5.5.9
Restart the OWB Service
5.5.9.1
Stop the OWB Service
5.5.9.2
Starting the OWB Service
5.5.10
Edit listener_ifile.ora
5.6
Create System Administrator and Security Administrator Users
5.6.1
Log on as sysadmin
5.6.2
Create a User Account for the Administrator
5.6.3
Assign a Role
5.7
Run Script
5.8
Run the Post-Installation Programs
5.8.1
Check That OWB Is Running Without Errors
5.8.2
Log On to Oracle Applications
5.8.3
Load the Adapter Files
5.8.4
Set the Tech Type Value
5.8.5
Run the Post-Installation Program
5.8.5.1
If You Must Change a Post-Installation Job Parameter Value
5.8.6
Synchronize the OWB Password
5.9
Gather Statistics on Three Schemas
5.10
Schedule the Context Index Refresh Program
5.11
Start Journaling Internal Tables
5.11.1
Set AuditTrail:Activate Profile to Yes
5.11.2
Define the Audit Installation
5.11.3
Run the Audit Trail Concurrent Program
5.12
Increase Memory Available for MetaData Reports
5.13
Grant Security Rights to Seeded Adapters
5.14
Create CDR_USER Role
5.15
Set Up the Notification Mailer
5.16
Set Up the Distributed Processing Server
5.16.1
Create the Distributed Processing Server User Account
5.16.2
Install the Distributed Processing Server
5.16.3
Secure Distributed Processing Server Files
5.16.4
Set NLS_LANG to UTF8
5.16.4.1
Windows
5.16.4.2
UNIX
5.16.5
Copy and Edit Files
5.16.5.1
Copy DP Server Files
5.16.5.2
Edit the DP Server Start Script
5.16.5.3
Copy RTF Template Files for XML Publisher
5.16.5.4
Copy and Edit Execution Command Files for Processing Engines
5.16.6
Define Service Locations and Services
5.16.7
Start the DP Server
5.17
Set Up Client Computers
5.17.1
Consumers and Administrators
5.17.2
Application Developers
5.17.2.1
Install the Client Plug-In
5.17.2.1.1
System Administrator Tasks
5.17.2.1.2
Definer Task
5.17.2.1.3
Enabling Using 7-Zip
5.17.2.2
Set NLS_LANG to UTF8
5.17.2.3
Set Up Development Environments
6
Integrating Other Systems
6.1
Integrating Oracle Clinical with the Oracle Life Sciences Data Hub
6.2
Integrating SAS with the Oracle Life Sciences Data Hub
6.2.1
SAS Compatibility
6.2.2
Set Up SAS Job Execution
6.2.2.1
Integrate the SAS Server with Oracle LSH
6.2.2.2
Start SAS in UTF8 Mode
6.2.3
Set Up Loading Data from SAS
6.2.4
Set Up SAS as an Integrated Development Environment
6.3
Integrating Informatica with the Oracle Life Sciences Data Hub
6.3.1
Install Informatica PowerCenter
6.3.2
Set Up Informatica Job Execution
6.3.3
Set Up User Accounts
6.3.4
Create a Remote Location and Connection for the LSHAdmin User
6.3.5
Set Up Informatica PowerCenter Designer as an Integrated Development Environment (IDE)
6.4
Integrating Oracle SQL Developer or Oracle SQL*Plus with the Oracle Life Sciences Data Hub
6.4.1
Set the NLS_LANG Environment Variable to UTF8
6.4.1.1
Windows
6.4.1.2
UNIX
6.5
Integrating Oracle Business Intelligence Enterprise Editions (OBIEE) for Visualizations
6.5.1
Install OBIEE 11.1.1.x for Visualizations
6.5.1.1
Install OBIEE
6.5.1.2
Install the Oracle LSH DP Server
6.5.1.3
Set Up OBIEE Visualizations
6.5.2
Install OBIEE 10.1.3.4.1 for Visualizations
6.5.2.1
Install Oracle Business Intelligence Publisher 10.1.3.4.1
6.5.2.2
Apply Patch 12613341
6.5.2.3
Apply Patch 7642637 for Visualizations
6.5.2.4
Install the Oracle LSH DP Server
6.5.2.5
Set Up OBIEE Visualizations
6.6
Integrating Oracle Business Intelligence Publisher for Programs
6.6.1
Install Oracle Business Intelligence Publisher 10.1.3.4.1
6.6.2
Set Up Oracle Business Intelligence Publisher Programs
6.6.2.1
Enable Program Execution
6.6.2.2
Set Up Security
6.6.2.3
Set Up Business Intelligence Publisher Definer Tools
7
Upgrading to Oracle Life Sciences Data Hub Release 2.3
7.1
Supported Upgrade Paths
7.2
Stop Server Processes
7.3
Upgrade and Configure Oracle Database and Oracle Warehouse Builder
7.4
Upgrade Oracle Warehouse Builder
7.5
Upgrade Informatica PowerCenter to 8.6.1 with HotFix 11 or Informatica PowerCenter 9.0.1 with HotFix 2
7.6
OBIEE 10g and 11g Options
7.6.1
OBIEE 11.1.1.3.0, 11.1.1.5.0 or 11.1.1.6.4
7.6.1.1
Install the Software
7.6.1.2
Copy and Edit Revised Execution Command Scripts
7.6.1.3
Upgrade and Deploy the Master Repository File
7.6.1.3.1
Copy the Master RPD File to a New Location
7.6.1.3.2
Migrate the Master RPD File to 11g
7.6.1.3.3
Edit Before Query Block in Connection Scripts
7.6.1.3.4
Manually Add the InitGroup Initialization Block
7.6.1.3.5
Manually Deploy the Master RPD File
7.6.1.4
Set the Default Authenticator to Optional
7.6.1.5
Starting the WebLogic Server
7.6.1.6
Migrate Repository Files for Individual Business Areas
7.7
Upgrade Integration with Oracle Business Intelligence Publisher
7.8
Upgrade Oracle Life Sciences Data Hub
7.8.1
Install Oracle Life Sciences Data Hub 2.3
7.8.2
Change Your FND_Validation_Level Profile
7.8.3
Create CDR_USER Role
7.9
Integrate Oracle LSH with Oracle Warehouse Builder
7.9.1
Set Up Your Environment
7.9.2
Migrate OWB Repository to 11.2.0.3
7.9.3
Create Directories and Copy Files
7.9.4
Disable Application Server Authentication
7.9.5
Edit run_service.sh
7.9.6
Edit Runtime.properties
7.9.7
Edit owb.classpath
7.9.8
Restart the 11gR2 OWB Service
7.10
Upgrade the Distributed Processing Server User Account
7.11
Upgrade the Distributed Processing Server
7.12
Perform the Remaining Post-Installation Tasks
7.13
Start Server Processes
8
What's Next
A
Architecture Overview
A.1
Client Tier
A.2
Application Tier
A.3
Database Tier
A.4
Adapters to External Systems
A.4.1
Source Data Systems
A.4.2
Data Transformation and Reporting Tools
A.4.3
Visualization Tools
A.4.4
Data Export Tools