This chapter describes security considerations and the installation process for the database tier. It contains the following topics:
The following list mentions the prerequisites for installing OHPM on the database tier:
Make sure that Oracle® Healthcare Foundation 7.1.1 Data Model is installed on the database server where you will be installing OHPM. For details on installing the OHF Data Model, see the Oracle Healthcare Foundation Installation Guide 7.1.1.
Apply patch 19710102 available on My Oracle Support.
Perform the following steps to install OHPM in Typical Mode on the database tier:
Download the OHPM installation package from the Media Pack and extract the files into a directory.
Navigate to the <media_pack_location>/ folder.
Using the following command, unzip the opm_Linux-x64.zip file to the folder where you want to launch the installer:
unzip -a OPM_Linux-x64.zip
Navigate to the Disk1/install folder.
Change the protection on files using the following command:
chmod 755 *
Start the Oracle Universal Installer (OUI) using the following command:
If the database server is on the machine where the installer is running, execute:
sh runInstaller.sh -local
If the database server is on a different machine, execute:
sh runInstaller.sh -local remote_installation=true
If the database server is on Exadata, execute:
sh runInstaller.sh -local remote_installation=true db_platform=exadata
where, the -local
option is to install on the local node irrespective of the cluster nodes specified on the installer machine.
The Welcome screen appears.
Click Next. The Select a Product to Install screen appears.
Select the Oracle Healthcare Precision Medicine DB Tier 1.1.0.0.0 option and click Next.
The Specify Home Details screen appears.
Enter the installation home name and location.
Click Next. The Verify Installation Prerequisites screen appears.
Verify if all the prerequisites are met before proceeding.
Click Next. The Oracle Client Home Configuration screen appears.
Specify the Oracle client home path. The installer validates this path.
Click Next. The DB Connection screen appears.
Enter values for the following fields:
Hostname - By default, the system host name appears
Port - By default, the port number is 1521. You can edit this field if required.
Service name
System password
Sys password
Click Next. The Schema Details screen appears.
Enter values for the following fields:
Omics data bank schema name (odb)
Omics data bank schema password
Cohort data mart schema name (cdm)
Cohort data mart schema password
Enterprise schema name
Enterprise schema password
Click Next. The Job Engine and Service Schema details screen appears.
Enter values for the following fields:
Job engine schema name
Job engine schema password
Services schema name
Services schema password
Click Next. The OPM Database details screen appears.
Enter values for the following fields:
OPM schema name
OPM schema password
Default tablespace for OPM schema
LOB tablespace for OPM schema
Index tablespace for OPM schema
Temp tablespace for OPM schema
Click Next. The OPM Database Verification screen appears.
Verify all the details. To make any changes, click Back.
If all the details are correct, click Next. The Tablespace Data File Location screen appears.
Specify the location of the tablespace data files. This is the directory on the database server where data files are created during installation.
Click Next. The Summary screen appears.
Click Install.
After the installation is complete, the End of Installation screen appears.
Click Exit after reviewing the installation information.
At the confirmation prompt, click Yes to exit the installer.
Review the generated installation log files for errors. Contact Oracle support, if necessary, to resolve any errors.