Assemble the Software

Use the technology stack product versions mentioned in this document. Even if newer versions of the technology stack products become available, they may not be compatible with Oracle LSH.

Get the Oracle Life Sciences Warehouse 2.5 Media Pack

Oracle LSH, Oracle Health Sciences Data Management Workbench, and their technology stacks are contained on the Oracle Health Sciences Data Management Workbench 2.5 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 call Oracle Support directly or open a Service Request (SR) selecting problem category: Version Update Request.

To download the media pack from eDelivery:

  1. Go to Oracle Software Delivery Cloud, http://edelivery.oracle.com, click Sign In, and log in with your user ID.
  2. Select Download Package from the All Categories drop-down list (or leave All Categories selected). Enter Oracle Health Sciences Data Management Workbench in the Search field and click Search.
  3. Select DLP: Oracle Health Sciences Data Management Workbench 2.5.0.0.0 and click Add to Cart.
  4. Click Checkout. You see a list of the selected software:
    • Oracle Health Sciences Data Management Workbench 2.5.0.0.0 (Oracle Standard Terms and Conditions)
    • Oracle Life Sciences Data Hub 2.5.0.0.0
    • Oracle Health Sciences Data Management Workbench 2.5.0.0.0
  5. From the Platform drop-down list, select the appropriate operating system.
  6. Click Continue.
  7. Review the Terms and Restrictions and select I accept the terms in the license agreement to continue. (Click Print from the top-right corner of the screen to print the agreement.) Click Continue. You see a list of zipped files for the Oracle Life Sciences Data Hub <your operating system> 2.5 release and Oracle Health Sciences Data Management Workbench <your operating system> 2.5 release:
    • Oracle Life Sciences Data Hub 2.5.0 (V988589-01.zip)
    • Oracle Health Sciences Data Management Workbench 2.5.0 (V986465-01.zip)
    • Oracle Thesaurus Management System 5.3.0 (V988638-01.zip)
  8. Leave the list of zipped files selected to download the package of Oracle Health Sciences Data Management Workbench 2.5.0.0.0 files or only select the files you need.
  9. Click Download. Then browse to the location where you want to save the Oracle executable.
  10. Double-click the Oracle executable (Oracle_SSN_DLM_02251701.exe). Leave the default destination or click Browse to select another one. Click Next. Oracle downloads the zipped files.
  11. Move the zipped files to a staging area and unzip them. The full release contains a software folder for Oracle DMW (p30560848_25000_Generic.zip), Oracle LSH (p6114439_R12_GENERIC.zip, p17269917_R12_GENERIC.zip, p28529507_R12_GENERIC.zip) and Oracle TMS (p20311744_53000_Generic.zip).
  12. See Download Software to a Staging Area for details on downloading the software.

Download Software to 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.

See the spreadsheet on the documentation disk for a list of patches and their location on the media pack.

To download patches from My Oracle Support, go to https://support.oracle.com.

Note:

See My Oracle Support article 1138053.1, Oracle Life Sciences Data Hub and Oracle Clinical Development Analytics Known Install and Configuration Issues for the latest information.

Table 1-1 Software to Download for Oracle LSH and Oracle DMW

Disk or Patch Name Source ID Number

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

Media pack

15 disks

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 Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (64-bit) (to establish an Oracle Home for installing Oracle TMS)

Media Pack

V20609-01

Oracle Thesaurus Management System 5.3

Media Pack

20311744

Oracle LSH Splicer patch for Applications R12

Media Pack

6114439

Oracle Life Sciences Data Hub 2.5.0

Media Pack

28529507

Oracle Life Sciences Data Hub 2.5 online help

Media Pack

18551089

Oracle E-Business Suite SDK patch

Media Pack

17269917

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

API TO PREVALIDATE EBS USERS for Oracle LSH (This patch is only required if you perform a full install of Oracle LSH 2.5 [not an upgrade to 2.5 from a previous version].)

My Oracle Support

19357286
FND PRODUCT INSTALLATION IS NOT EXECUTING FOR GHR, OTL, IREC PRODUCTS (This patch is only required if you perform a full install of Oracle LSH 2.5 [not an upgrade to 2.5 from a previous version].)

My Oracle Support

16263414

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

My Oracle Support

1058763.1

If you use Oracle Health Sciences Data Management Workbench, download the following software to a separate application server. For system requirements, see the Oracle Health Sciences Data Management Workbench Installation Guide.

Table 1-2 Software to Download for Oracle DMW

Disk or Patch Name Source ID Number

Oracle WebLogic Server 12.2.1.3 and Coherence for Linux x86

Media Pack

p26269885_122130_Generic.zip

ADF patch

My Oracle Support

16546129

ADF patch

My Oracle Support

16546157

Oracle Health Sciences Data Management Workbench 2.5

Media Pack

30560848