Skip Headers
Oracle® Life Sciences Data Hub Installation Guide
Release 2.2.2
E51945-01
Home
Book List
Contact Us
Next
PDF
·
Mobi
·
ePub
1/15
Contents
List of Figures
List of Tables
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
Check for the Most Recent Information
Get Your Company ID from Oracle
Assemble the Software
Get the Required Oracle Life Sciences Data Hub Releases
Get the Required E-Business Suite Patches
Set Up a Staging Area
Assemble the Documentation
Books
My Oracle Support Articles
System Requirements and Technology
Installing Oracle Applications and Oracle Database
Installing the Oracle Life Sciences Data Hub
Upgrading to Oracle Life Sciences Data Hub Release 2.2.2
Installing Real Application Clusters (RAC)
Other Oracle LSH-Related Documents
2
System Requirements and Technology Stack
System Requirements
Operating Systems
Hardware
Technology Stack
Integrated External Systems
Character Encoding Settings
3
Installing and Patching Oracle Applications and Oracle Database
Install Oracle Applications 12.1.1
Upgrade Oracle Applications to Release 12.1.3
Upgrade the Oracle Database and Oracle Warehouse Builder to 11.2.0.4
Edit listener_ifile.ora
Change Default Password Settings
Increase JVM Memory
Clone the Environment (Optional)
Install Oracle Warehouse Builder on Oracle Database 11g Release 2
Create an Oracle Warehouse Builder Repository
4
Installing Oracle Thesaurus Management System
Set Up a Windows Computer for Launching the TMS Installation
Setting up the SQL*Net Connections for Existing Databases
Set Up Compatibility Mode
Install the TMS Server
Install the TMS Database
Apply TMS Patch
Check the def_instance_name Column Value
5
Installing the Oracle Life Sciences Data Hub
Apply the Oracle Life Sciences Data Hub AD Splicer Patch
Install Oracle LSH Release 2.2
Install Online Help
Grant Execute Privileges to the APPS Schema
Integrate Oracle LSH with the Oracle Warehouse Builder
Set Up Your Environment
Ensure that Oracle SID and Short Global Names Match
Edit init.ora
Restart the Database and Listener
Test Database Connectivity
Create Directories and Copy Files
Disable Application Server Authentication
Edit run_service.sh
Edit Runtime.properties
Edit owb.classpath
Edit Shell Scripts to Match Directory Structure
Run OWB Shell Scripts
Restart the OWB Service
Stop the OWB Service
Starting the OWB Service
Edit listener_ifile.ora
Create System Administrator and Security Administrator Users
Log on as sysadmin
Create a User Account for the Administrator
Assign a Role
Run Script
Run the Post-Installation Programs
Check That OWB Is Running Without Errors
Log On to Oracle Applications
Load the Adapter Files
Set the Tech Type Value
Run the Post-Installation Program
If You Must Change a Post-Installation Job Parameter Value
Synchronize the OWB Password
Gather Statistics on Schemas
Schedule the Context Index Refresh Program
Start Journaling Internal Tables
Set AuditTrail:Activate Profile to Yes
Define the Audit Installation
Run the Audit Trail Concurrent Program
Increase Memory Available for MetaData Reports
Grant Security Rights to Seeded Adapters
Set Up the Notification Mailer
Set Up the Distributed Processing Server
Create the Distributed Processing Server User Account
Install the Distributed Processing Server
Set NLS_LANG to UTF8
Windows
UNIX
Copy and Edit Files
Copy DP Server Files
Edit the DP Server Start Script
Copy RTF Template Files for XML Publisher
Copy and Edit Execution Command Files for Processing Engines
Define Service Locations and Services
Start the DP Server
Set Up Client Computers
Consumers and Administrators
Application Developers
Install the Client Plug-In
Set NLS_LANG to UTF8
Set Up Development Environments
Install Oracle LSH Release 2.2.2
Install Prerequisite Patches for Oracle LSH 2.2.1
Install Oracle LSH Release 2.2.1
Install Oracle LSH Release 2.2.2
6
Integrating Other Systems
Integrating Oracle Clinical with the Oracle Life Sciences Data Hub
Integrating SAS with the Oracle Life Sciences Data Hub
SAS Compatibility
Set Up SAS Job Execution
Integrate the SAS Server with Oracle LSH
Start SAS in UTF8 Mode
Set Up Loading Data from SAS
Set Up SAS as an Integrated Development Environment
Integrating Informatica with the Oracle Life Sciences Data Hub
Install Informatica PowerCenter
Set Up Informatica Job Execution
Set Up User Accounts
Create a Remote Location and Connection for the LSHAdmin User
Set Up Informatica PowerCenter Designer as an Integrated Development Environment (IDE)
Integrating Oracle SQL Developer or Oracle SQL*Plus with the Oracle Life Sciences Data Hub
Set the NLS_LANG Environment Variable to UTF8
Windows
UNIX
Integrating Oracle Business Intelligence Enterprise Editions (OBIEE) for Visualizations
Install OBIEE 11.1.1.7.0 for Visualizations
Install OBIEE 11.1.1.7.0
Install the Oracle LSH DP Server
Set Up OBIEE 11.1.1.7.0 Visualizations
Install OBIEE 10.1.3.4.1 for Visualizations
Install Oracle Business Intelligence Publisher 10.1.3.4.1
Apply Patch 12613341
Apply Patch 7642637 for Visualizations
Install the Oracle LSH DP Server
Set Up OBIEE 10.1.3.4.1 Visualizations
Integrating Oracle Business Intelligence Publisher for Programs
Install Oracle Business Intelligence Publisher 10.1.3.4.1 or Oracle Business Intelligence Publisher 11.1.1.7.0
Set Up Oracle Business Intelligence Publisher Programs
Enable Program Execution
Set Up Security
Set Up Business Intelligence Publisher Definer Tools
7
Upgrading to Oracle Life Sciences Data Hub Release 2.2.2
Supported Upgrade Paths
Stop Server Processes
Recommended Steps for a Smoother Upgrade Process
Install and Upgrade Oracle Applications
Install Oracle Applications Release 12.1.1
Monitor the Upgrade Process
Upgrade Oracle Applications to Release 12.1.3
Apply Patches
Upgrade and Configure the Oracle Database
Upgrade Informatica PowerCenter to 8.6.1 with HotFix 11, or to Informatica PowerCenter 9.0.1, or to Informatica PowerCenter 9.5.1
Oracle Business Intelligence Publisher Options
OBIEE Options
OBIEE 10.1.3.4.1
OBIEE 11.1.1.7.0
Install the Software
Copy and Edit Revised Execution Command Scripts
Upgrade and Deploy the Master Repository File
Set the Default Authenticator to Optional
Starting the WebLogic Server
Migrate Repository Files for Individual Business Areas
Migrate the Oracle Warehouse Builder Repository (Conditional)
Migrate the OWB Repository from CDR_RTREPOS to OWBSYS
Create the OWBSYS Schema and Grant Privileges
Create the Schema
Unlock Accounts and Change Passwords
Grant Required Privileges
Create New OWB Workspace for CDR_RTREPOS
Upgrade Oracle Life Sciences Data Hub
Integrate Oracle LSH with the 11g Release 2 Oracle Warehouse Builder (Conditional)
Set Up Your Environment
Create Directories and Copy Files
Disable Application Server Authentication
Edit run_service.sh
Edit Runtime.properties
Edit owb.classpath
Edit Shell Scripts to Match Directory Structure
Run OWB Shell Scripts
Restart the 11g Release 2 OWB Service
Stop the 10g Release 2 OWB Service
Upgrade the OWB Repository (Conditional)
Upgrading OWB from Oracle LSH 2.1.3 on 10g Release 2 to Oracle LSH 2.2
Upgrading OWB from Oracle LSH 2.1.3 on 11g Release 2 or Oracle LSH 2.1.4 on 11g Release 2 to Oracle LSH 2.2
Migrate the Oracle Warehouse Builder Stores (Conditional)
Migrate the Store Passwords and Audit Task ID
Upgrade the Workflow Store
Upgrade Other OWB Stores
Edit listener_ifile.ora
Upgrade the Distributed Processing Server
Perform the Remaining Post-Installation Tasks
Start Server Processes
8
What's Next
A
Architecture Overview
Client Tier
Application Tier
Database Tier
Adapters to External Systems
Source Data Systems
Data Transformation and Reporting Tools
Visualization Tools
Data Export Tools
B
Installing Real Application Clusters (RAC)