- Installation Guide
- Install the Database Tier
- Install the Database Tier
Install the Database Tier
Note:
Ensure that all prerequisites (Check prerequisites) have been fulfilled.To install the Oracle Healthcare Translational Research database framework:
- 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
- If the database server is on the machine where the
Installer is running, execute:
- The Welcome screen appears. Click Next.
- In the Select a Product to Install screen, select the Oracle Healthcare Translational Research DB Tier 3.4 option, and click Next.
- In the Specify Home Details screen, enter the installation home name and location, and click Next.
- In the Verify Installation Prerequisites screen, verify if all the prerequisites are met before proceeding. Click Next.
- In the Oracle Client Home Configuration screen, specify the Oracle client home path. The installer validates this path. Click Next.
- 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
- 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
- In the Enter OHF Schema Details screen, enter values for
the following fields and click Next.
- Services schema name
- Services schema password
- In the Enter Schema Details screen, enter values for the
following fields and click Next.
- OHTR application schema name
- OHTR application schema password
- 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
- In the Database Verification screen, verify all the
details.
- Click Back to make any changes.
- After verifying that all details are correct, click Next.
- 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.
- In the Summary screen, take one last look at the details. If everything is alright, click Install.
- When the installation is complete, the End of Installation screen appears. Review the information and click Exit.
- At the confirmation prompt, click Yes to exit the Installer.
- Review the generated installation log files for errors. If necessary, contact Oracle support to fix any errors.
Parent topic: Install the Database Tier