Skip Headers
Oracle® Life Sciences Data Hub Installation Guide
Release 2.2.2

E51945-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

1 Before You Begin

This section includes the following topics:

Note:

If you are installing Oracle LSH for the first time, go through Chapters 1 to 5, in order.

If you are upgrading from a previous release, read:

See also:

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".

Get Your Company ID from Oracle

When you install the Oracle Life Sciences Data Hub (Oracle LSH Release 2.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

If you are using an Oracle LSH version prior to Release 2.2, you need to update your installation to Release 2.2, then upgrade it to Release 2.2.1, before installing LSH 2.2.2.

Ensure you get the technology stack products from the sources recommended in this guide and use the versions indicated. Although newer versions of the technology stack products may have become available, they may not be compatible with Oracle LSH.

Get the Required Oracle Life Sciences Data Hub Releases

If you are performing a fresh installation or intend to perform an upgrade from a version earlier than 2.2, download all the software below.

If you intend to perform an upgrade from a version later than 2.2, download only the releases needed.

  1. 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 download or 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) on My Oracle Support at https://support.oracle.com.

  2. Get Oracle LSH 2.2.0.1 from My Oracle Support. The patch number is 12972887.

    For more information, see 1376926.1, Oracle LSH 2.2.0.1 Release Notes.

  3. Get Oracle LSH 2.2.0.2 from My Oracle Support. The patch number is 13247999.

    For more information, see 1390140.1, Oracle LSH 2.2.0.2 Release Notes.

  4. Get Oracle LSH 2.2.0.3 from My Oracle Support. The patch number is 13867144.

    For more information, see 1451898.1, Oracle LSH 2.2.0.3 Release Notes.

  5. Get Oracle LSH 2.2.0.4 from My Oracle Support. The patch number is 14708988.

    For more information, see 1534881.1, Oracle LSH 2.2.0.4 Release Notes.

  6. Get Oracle LSH 2.2.0.5 from My Oracle Support. The patch number is 7017290.

    For more information, see 1569100.1, Oracle LSH 2.2.0.5 Release Notes.

  7. Get Oracle LSH 2.2.1 from My Oracle Support. The patch number is 17869441.

    For more information, see 1608877.1, Oracle LSH 2.2.1 Release Notes.

  8. Get Oracle LSH 2.2.2 from My Oracle Support. The patch number is 19310436.

    For more information, see 1924662.1, Oracle LSH 2.2.2 Release Notes.

    For more information, see "Finding Information and Patches on My Oracle Support".

Get the Required E-Business Suite Patches

Download the following patches from My Oracle Support:

  • 8855023

  • 10163753

  • 10406817

Set Up a Staging Area

Creating a staging area is recommended but not required.

To download patches from My Oracle Support, see "Finding Information and Patches on My Oracle Support".

Table 1-1 Software to Download for Oracle LSH

Disk or Patch Name Source ID Number

Oracle E-Business Suite Release 12.1.3 operating_system x86-64 Rapid Install: Databases, Tools, APPL_TOP, and documentation

LSH 2.2 Media Pack

-

Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (64-bit) (to establish an Oracle Home for installing Oracle TMS)

LSH 2.2 Media Pack or Request from Oracle Support

V20609-01

Oracle Database 11.2.0.4; for a list of patches required, see My Oracle Support article 1058763.1.

My Oracle Support

1058763.1

Oracle Thesaurus Management System 4.6.1

Request from Oracle Support

-

Oracle LSH Splicer patch for Applications R12

My Oracle Support

6114439

Oracle Life Sciences Data Hub 2.2

Request from Oracle Support

-

Oracle Life Sciences Data Hub 2.2.0.1

My Oracle Support

12972887

Oracle Life Sciences Data Hub 2.2.0.2

My Oracle Support

13247999

Oracle Life Sciences Data Hub 2.2.0.3

My Oracle Support

13867144

Oracle Life Sciences Data Hub 2.2.0.4

My Oracle Support

14708988

Oracle Life Sciences Data Hub 2.2.0.5

My Oracle Support

17017290

Oracle Life Sciences Data Hub 2.2.1

My Oracle Support

17869441

Oracle Life Sciences Data Hub 2.4 online help

My Oracle Support

18551089

Oracle Applications DBA 12.1.3 Product Release Update Pack

My Oracle Support

9239089

Oracle E-Business Suite 12.1.3 Release Update Pack

My Oracle Support

9239090

Oracle Applications Framework patch

My Oracle Support

10222869

Compatibility with Internet Explorer 8

My Oracle Support

12661509

NOT ABLE TO ADD HTTPS URL TO FAVORITES LINK IN 12.1.2. HTTP IS PRE-PENDED TO URL

My Oracle Support

11781531

FND_NO_DATABASE_CONNECTION

My Oracle Support

11832737


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.2 (this book)

  • 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® Business Intelligence Publisher Installation Guide Release 10.1.3.4 (E12690-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 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.2

Chapter 7, "Upgrading to Oracle Life Sciences Data Hub Release 2.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

Other Oracle LSH-Related Documents

The following related documents are available on My Oracle Support. See "Searching for Knowledge Articles by ID"

  • Oracle Life Sciences Data Hub 2.2 Installation Verification Test (1063225.1)

  • Guide to Using Oracle VM Templates in an Oracle Life Sciences Data Hub 2.2 Installation (1450700.1)