Create HDR 8.2 and HDR FHIR Database Schemas on ATP

If you want to use OCI Autonomous Transaction Processing Database, this section describes steps to configure the CTB, HCT, and HDR FHIR schemas on Autonomous Database system.

Prerequisites

• Ensure that the Autonomous Transaction Processing Database is already set up and configured in the user Tenancy.
• The wallet file is (Wallet_<DBNAME>.zip) downloaded to your local instance.
• Ensure your local SQL client (e.g., SQL*Plus) is able to connect to ATP using the downloaded Wallet file.
• Set HDR_HOME environment variable to a directory where hdr82_artifacts.zip file is extracted.

Create HCT User

Once the SQL*Plus client is connected to an Oracle ATP instance successfully, execute create_hct_user.sh script to create the HCT User.

1. Navigate to $HDR_HOME/database/atpdb/hct

2. Run chmod 700 on create_hdr_user.sh

3. Run create_hct_user.sh

Example:

sh $HDR_HOME/database/atpdb/hct/create_hct_user.sh <ORACLE_HOME> <ADMIN_USER_NAME> <TNS_NAME>

sh create_hct_user.sh /scratch/app/oracle/product/19c admin hdiphdrdevdb_tpurgent

The script prompts you to enter Admin user and HCT user passwords, provide valid value and hit enter. HCT database user is created.

Create HCT Database Objects

Execute create_hct_database.sh script to create the HCT schema required database object like tables, sequences, indexes, seed data, packages etc.

1. Navigate to $HDR_HOME/database/atpdb/hct

2. Run chmod 700 on create_hct_database.sh

3. Run create_hct_database.sh

Example:

sh $HDR_HOME/database/atpdb/hct/create_hct_database.sh <ORACLE_HOME> <ADMIN_USER_NAME> <TNS_NAME>

sh create_hct_database.sh /scratch/app/oracle/product/19c admin hdiphdrdevdb_tpurgent

The script prompts you to enter ADMIN user and HCT user passwords and HCT terminology base language code (Ex: ENUS), provide valid values and hit enter. Required database objects like tables, sequences, indexes, seed data, packages etc. are created for HCT user.

Create CTB User

Execute create_ctb_user.sh script to create the CTB user.

1. Navigate to $HDR_HOME/database/atpdb/ctb

2. Run chmod 700 on create_ctb_user.sh

3. Run create_ctb_user.sh

Example:

sh $HDR_HOME/database/atpdb/ctb/create_ctb_user.sh <ORACLE_HOME> <ADMIN_USER_NAME> <TNS_NAME>

sh create_ctb_user.sh /scratch/app/oracle/product/19c admin hdiphdrdevdb_tpurgent

The script prompts you to enter ADMIN user and CTB user passwords, provide valid values and hit enter. CTB user is created.

Create CTB Database Objects

Execute create_ctb_database.sh script to create the CTB schema required database object like tables, sequences, indexes, seed data, packages etc.

1. Navigate to $HDR_HOME/database/atpdb/ctb

2. Run chmod 700 on create_ctb_database.sh

3. Run create_ctb_database.sh

Example:

sh $HDR_HOME/database/atpdb/ctb/create_ctb_database.sh <ORACLE_HOME> <ADMIN_USER_NAME> <TNS_NAME>

sh create_ctb_database.sh /scratch/app/oracle/product/19c admin hdiphdrdevdb_tpurgent

The script prompts you to enter ADMIN user and CTB user passwords, provide valid values and hit enter. Required database objects like tables, sequences, indexes, seed data, packages etc. are created for CTB user.

Create HDR FHIR User

Execute create_hdr_fhir_user.sh script to create the HDR FHIR user.

1. Navigate to $HDR_HOME/database/atpdb/fhir

2. Run chmod 700 on create_hdr_fhir_user.sh

3. Run create_hdr_fhir_user.sh

Example:

sh $HDR_HOME/database/atpdb/fhir/create_hdr_fhir_user.sh <ORACLE_HOME> <ADMIN_USER_NAME> <TNS_NAME>

sh create_hdr_fhir_user.sh /scratch/app/oracle/product/19c admin hdiphdrdevdb_tpurgent

The script prompts you to enter ADMIN user password, HDR FHIR user name (eg: HDR_FHIR) and HDR FHIR user password, provide valid values and hit enter.

HDR FHIR database user is created.

Create HDR FHIR Database Objects

Execute create_hdr_fhir_database.sh script to create the HDR FHIR schema required database object like tables, sequences, indexes, seed data, packages etc.

1. Navigate to $HDR_HOME/database/atpdb/fhir

2. Run chmod 700 on create_hdr_fhir_database.sh

3. Run create_hdr_fhir_database.sh

Example

sh $HDR_HOME/database/atpdb/fhir/create_hdr_fhir_database.sh <ORACLE_HOME> <ADMIN_USER_NAME> <TNS_NAME>

sh create_hdr_fhir_database.sh /scratch/app/oracle/product/19c admin hdiphdrdevdb_tpurgent

The script prompts to enter Admin user password, HDR FHIR username and password, provide valid values and hit enter. Required database objects like tables, sequences, indexes, seed data, packages etc. are created for HDR FHIR user.