Install the Database Tier

Note:

Ensure that all prerequisites (Check prerequisites) have been fulfilled.

To install the Oracle Healthcare Translational Research database framework:

1. 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
   • If the database server is on a different machine, execute: sh runInstaller.sh remote_installation=true
   • If you are executing the Installer on Linux, change the directory to Disk1/install and run the following command:

     bash$  chmod +x unzip runInstaller runInstaller.sh
     

   If the schema name provided here already exists in the Oracle Healthcare Foundation database, then that schema is used to install Oracle Healthcare Translational Research objects. If it does not exist, the schema is created.

   While creating the Oracle Healthcare Translational Research application schema, the Installer prompts for the default and temporary tablespaces for this user. If these tablespaces already exist, they are assigned to the user and quota unlimited is granted on them. Otherwise these tablespaces are created with the datafile located in the user-supplied file destinations:

   Database Schema	Default Tablespace	Temporary Tablespace
   APP	APP_DATA	TRC_TEMP_TS
   DATA_STUDIO	DS_DATA	TRC_TEMP_TS

2. The Welcome screen appears. Click Next.
3. In the Select a Product to Install screen, select the Oracle Healthcare Translational Research DB Tier 3.4 option, and click Next.
4. In the Specify Home Details screen, enter the installation home name and location, and click Next.
5. In the Verify Installation Prerequisites screen, verify if all the prerequisites are met before proceeding. Click Next.
6. In the Oracle Client Home Configuration screen, specify the Oracle client home path. The installer validates this path. Click Next.
7. In the Enter DB Connection details screen, enter values for the following fields and click Next:
   • 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 user password
   • Sys user password
8. In the Enter OHF Schema Details screen, enter values for the following fields and click Next:

   Note:

   Make sure that the user names and passwords are not the same for all entered schemas.

   • Omics data bank schema name
   • Omics data bank schema password
   • Common data mart schema name
   • Common data mart schema password
   • Enterprise schema name
   • Enterprise schema password
   • Job Engine schema name
   • Job Engine schema password
9. In the Enter OHF Schema Details screen, enter values for the following fields and click Next.
   • Services schema name
   • Services schema password
10. In the Enter Schema Details screen, enter values for the following fields and click Next.
    • OHTR application schema name
    • OHTR application schema password
11. In the Specify Tablespace details screen, enter values for the following fields and click Next.
    • Default tablespace for APP schema
    • Temp tablespace for APP schema
12. In the Database Verification screen, verify all the details.
    • Click Back to make any changes.
    • After verifying that all details are correct, click Next.
13. In the Verify Configuration Parameters screen, verify all the details.
    • Click Back to make any changes.
    • After verifying that all details are correct, click Next.
14. In the Summary screen, take one last look at the details. If everything is alright, click Install.
15. When the installation is complete, the End of Installation screen appears. Review the information and click Exit.
16. At the confirmation prompt, click Yes to exit the Installer.
17. Review the generated installation log files for errors. If necessary, contact Oracle support to fix any errors.