Check prerequisites

Install or upgrade the Oracle Healthcare Foundation (OHF) database tier to the release required for the Oracle Healthcare Translational Research release you are installing or upgrading to. See the release notes for more information.

Install the latest RDBMS patch set onto the Oracle Healthcare Foundation database before installing the Oracle Healthcare Translational Research database tier. The minimal recommended patch set is Database Patch 30116802 - GI Oct 2019 Release Update 12.2.0.1.191015.

The installation environment can be either:

• the database server (Exadata computing node) where the Oracle Healthcare Foundation database is installed
• a stand-alone Linux server that has the following additional software available:
  • Python 2x (2.6.6 or later)
  • Oracle 12c client with net services configured to access the Oracle Healthcare Foundation database

The following five database schemas are required by the Oracle Healthcare Translational Research application. They are installed during the Oracle Healthcare Foundation database installation. Each schema and tablespace may have the default name or a name provided during Oracle Healthcare Foundation installation. Note these details, which you will need when you run the Oracle Healthcare Translational Research Installer.

• CDM - Cohort Data Mart (CDM) schema stores the clinical information that is refreshed by ETLs.
• ODB - Omics Data Bank (ODB) schema stores the omics data linked to patients as well as genetic reference data to link.
• SVC - Services schema is used by ODB loader APIs.
• ENT - The Enterprise (ENT) schema stores system-wide configuration information like product version.
• JOB_ENGINE - Job Engine (JOB) schema tracks all jobs executed and provides templates for jobs.

Two additional database schemas, APP and DATA_STUDIO, are required by Oracle Healthcare Translational Research. The APP schema stores metadata information used in the user interface. The DATA_STUDIO schema stores metadata for Oracle Healthcare Translational Research notebooks. If desired, these schemas and their associated tablespaces can be created earlier in the Oracle Healthcare Foundation database by a DBA. If either of these schemas exist, the Oracle Healthcare Translational Research installer uses it to store the application. Otherwise, it creates the tablespaces and schemas first.