Oracle® Life Sciences Data Hub Installation Guide Release 2.2.2 E51945-01 |
|
|
PDF · Mobi · ePub |
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:
Required Expertise. For information on the expertise required to install Oracle Life Sciences Data Hub, see "Audience".
New Features and Fixes. For information on what is included in Oracle LSH Release 2.2.2 see the Release Notes, posted at:
Known Installation and Configuration Issues. For up-to-date information, see My Oracle Support article 1138053.1, Oracle Life Sciences Data Hub and Oracle Clinical Development Analytics Known Install and Configuration Issues; see "Searching for Knowledge Articles by ID".
Installation Verification. After you have installed Oracle LSH, see My Oracle Support article 1063225.1, Oracle Life Sciences Data Hub Installation Verification Test (also called the "smoke test") to verify that all basic features are functioning properly.
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".
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.
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.
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.
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
.
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.
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.
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.
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.
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.
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.
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".
Download the following patches from My Oracle Support:
8855023
10163753
10406817
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 |
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.
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".
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.
Chapter 2, "System Requirements and Technology Stack" references the following My Oracle Support articles:
180430.1, Oracle Life Sciences Applications Supported Technology Stacks
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
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
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.
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
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)