1 Before You Begin

This section includes the following topics:

Check for the Most Recent Information
Get Your Company ID from Oracle
Assemble the Software
Assemble the Documentation

Note:

If you are upgrading from a previous release, read:

Check for the Most Recent Information

Oracle LSH documentation is updated periodically. Therefore, it is critical that you check that you have the most current information before you begin the installation process.

To be sure you have the most recent version of the release notes, this installation guide, and all other Oracle LSH user documentation, download it from oracle.com; see "Finding Oracle Documentation".

Refer to the Change Record to track updates to this Oracle LSH 2.2 installation guide.

Get Your Company ID from Oracle

When you install the Oracle Life Sciences Data Hub (Oracle LSH Release 2.2) , you will need to enter a parameter value for Company ID. The company ID serves as part of the primary key for all the Oracle LSH objects you define in this instance of Oracle LSH. If your company ever merges with another company and your Oracle LSH data and meta-data are merged with the other company's, the company ID distinguishes the objects created in each original company and prevents duplicate object primary keys.

In order to ensure that you have a unique number relative to other Oracle LSH customers, Oracle recommends that you use a number assigned to you by Oracle. Company IDs are tracked in an Oracle bug that is not publicly viewable. Contact Oracle Support or ask your consultant to reserve a range of ten numbers for your company. You can use these numbers for:

Your company ID. If you have multiple instances of Oracle LSH, Oracle recommends using a different company ID for each instance.
The tech type ID of any adapters your company may create.

Assemble the Software

Note:

It is important to get the technology stack products from the Oracle LSH 2.2 media pack because, although newer versions of the technology stack products may have become available, they may not be compatible with Oracle LSH.

Get the Oracle Life Sciences Data Hub 2.2 Media Pack

Oracle LSH 2.2 and its technology stack are contained on the Oracle Life Sciences Data Hub 2.2 media pack for various platforms.

To receive a physical media pack with all the required DVDs, contact Oracle Support. To expedite your request you can either call Oracle Support directly or open a Service Request (SR) selecting problem category: Version Update Request.

To download the media pack from eDelivery:

Go to the Oracle Software Delivery Cloud, http://edelivery.oracle.com and sign in.
From the Select a Product Pack drop-down list, select Health Sciences.
From the Platform drop-down list, select the appropriate operating system.
Click Go.

Note:
If this media pack is the only one available in Health Sciences for the platform you selected, the system takes you immediately to the media pack page from which you can download the software disk by disk.
Select Oracle Life Sciences Data Hub 2.2 Media Pack for Your_Operating_System and click Continue.
Download the software. See "Set Up a Staging Area".

Download Additional Patches

Download the following patches:

8855023
10163753
10406817

Set Up a Staging Area

Creating a staging area is recommended but not required.

To set up the staging area successfully, create a directory for each disk in the media pack and then download and expand all the files that comprise a single disk in the media pack to the same location.

The media pack contains:

Oracle Life Sciences Data Hub 2.2 Documentation
Oracle Life Sciences Data Hub 2.2 and patches
Oracle Life Sciences Data Hub 2.2 for your_platform technology stack patches
Oracle Clinical 4.6
Oracle Thesaurus Management System 4.6.1
Oracle E-Business Suite Release 12.1.1
Oracle E-Business Suite Release 12.1.1 documentation
Oracle Application Server 10g (10.1.2.0.2)
Oracle SOA Suite 10g (10.1.3.1.0)
Oracle Business Intelligence Enterprise Edition 11g (11.1.1.5.1)
Oracle Fusion Middleware Repository Creation Utility 11g (11.1.1.5), which is required with Oracle Business Intelligence Enterprise Edition 11g.
Oracle 11g Database 11.2.0.2
Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (32-bit). This is provided in case you need to create an Oracle Home on Windows for the purpose of installing Oracle Thesaurus Management System.
Required patches. See the spreadsheet on the documentation disc for a list of patches and their location on the media pack.

Assemble the Documentation

Installing Oracle LSH is a complex process because it includes installing, upgrading, and patching a number of other products. This book guides you through the whole process, but refers you to the documentation for these other products along the way.

Oracle recommends that you gather all the documentation you will need and read it before you begin the process of installing Oracle LSH.

Books

The books you need to install the technology stack are included in the Oracle Life Sciences Data Hub media pack.

You can also find PDF copies online; see "Finding Oracle Documentation".

You need the following books:

Oracle® Life Sciences Data Hub Installation Guide Release 2.2 (this book)
Oracle® Life Sciences Data Hub System Administrator's Guide Release 2.2 (E22745-02)
Oracle E-Business Suite Release 12.1.1 Documentation Library (B53825-01) which includes:
- Oracle E-Business Suite Maintenance Utilities (E13676-03)
- Oracle E-Business Suite Maintenance Procedures (E13675-03)
- Oracle E-Business Suite Patching Procedures (E12148-04)
- Oracle E-Business Suite System Administrator's Guide - Configuration (E12893-04)
- Oracle E-Business Suite System Administrator's Guide - Maintenance (E12894-04)
- Oracle E-Business Suite System Administrator's Guide - Security (E12843-05)
- Oracle® Applications Upgrade Guide Release 11i to 12.1.1 (E16342)
Oracle E-Business Suite Installation Guide: Using Rapid Install Release 12 (E12842-04)
Oracle® Warehouse Builder Installation and Administration Guide 11g Release 2 (11.2) (E17130-03)
Oracle® Warehouse Builder Release Notes 11g Release 2 (11.2) (E10585-08)
Oracle® Thesaurus Management System Installation Guide Release 4.6.1 (A83780-11)
Oracle® Business Intelligence Publisher Installation Guide Release 10.1.3.4 (E12690-01)
Oracle® Fusion Middleware Installation Guide for Oracle Business Intelligence 11g Release 1 (11.1.1) (E10539-01)
Oracle® Fusion Middleware Upgrade Guide for Oracle Business Intelligence 11g Release 1 (11.1.1) (E16452-01)

In addition, if you plan to integrate Oracle Life Sciences Data Hub with any of the systems listed in Chapter 6, "Integrating Other Systems," you need the installation guide and user documentation for those systems.

The rest of the Oracle LSH user documentation is also included. However, you should check online for the most current versions; see "Finding Oracle Health Sciences Documentation". For a list of the user documentation, "Related Documents".

My Oracle Support Articles

The My Oracle Support Web site, formerly known as MetaLink, contains links to the most recent patches and updates for Oracle products. This section lists all the My Oracle Support articles listed in subsequent sections of this guide so that you can copy all of them to one place. See "Searching for Knowledge Articles by ID".

They are organized by the chapter where they are first required.

System Requirements and Technology

Chapter 2, "System Requirements and Technology Stack" references the following My Oracle Support articles:

180430.1, Oracle Life Sciences Applications Supported Technology Stacks

Installing Oracle Applications and Oracle Database

Chapter 3, "Installing and Patching Oracle Applications and Oracle Database" references the following My Oracle Support articles:

1138053.1, Oracle Life Sciences Data Hub and Oracle Clinical Development Analytics Known Install and Configuration Issues
1058763.1, Interoperability Notes Oracle E-Business Suite Release 12 with Oracle Database 11g Release 2 (11.2.0)
406982.1, Cloning Oracle Applications Release 12 with Rapid Clone
455999.1, How to Verify if OWB is Installed Correctly on RAC and Exadata

Installing the Oracle Life Sciences Data Hub

Chapter 5, "Installing the Oracle Life Sciences Data Hub" references the following My Oracle Support articles:

387859.1, Using AutoConfig to Manage System Configurations in Oracle E-Business Suite Release 12
164871.1, Configuring the Workflow Notification Mailer in Oracle Applications Manager 11i

Upgrading to Oracle Life Sciences Data Hub Release 2.2

Chapter 7, "Upgrading to Oracle Life Sciences Data Hub Release 2.2" references the following My Oracle Support articles:

1054417.1, Patch 6678700 Worker Fails On Applying MSDODPCODE.sql With ORA-33292 Insufficient Permissions To Access Analytic Workspace APPS.ODPCODE; ORA-33262: Analytic workspace ODPCODE does not exist.
1314218.1, ORA-37002: Oracle OLAP failed to initialize while applying patch 6678700
296187.1, How To Manually Install Oracle OLAP into a 9i, 10g or 11g database After the DB Has Been Created
1333659.1, Applying The Patch 6678700 Worker 1 Failed: File Cskbcat.Ldt. ERRORS: ORA-20000: Oracle Text error: DRG-50857: oracle error in textindexmethods.ODCIIndexUpdate, DRG-13201: KOREAN_LEXER is desupported
1281478.1, Script Czhist.Sql Fails During Application Of Patch 6678700
1083981.1, Script Pechktsk.Sql fails with, ORA-00979: Not A Group By Expression when applying Patch 6678700 or Patch 3500000
1322144.1, Error - ORA-54015 : biv_b_age_h_sum_mv.xdf Failes with Duplicate Column Expression was Specified
1284055.1, 12.1.1 Upgrade Fails on Fem_bal_nacc_hier_l2_mv.xdf with Oracle 11.2.0.2 Database
1106795.1, adapcctl.sh: exiting with status 150
1358564.1, OWB Import of Entire Repository Fails with ORA-00001: Unique Constraint (OWBSYS.ET_PK) Violated

Installing Real Application Clusters (RAC)

Appendix B, "Installing Real Application Clusters (RAC)" references the following My Oracle Support articles:

823587.1, Using Oracle 11g Release 2 Real Application Clusters with Oracle E-Business Suite Release 12
1331090.1, How To Configure Oracle Warehouse Builder on RAC database for LSH 2.1.4 and Later
455999.1, How to Verify if OWB is Installed Correctly on RAC and Exadata