Create HDR FHIR Database Schema on ATP

If you want to use OCI Autonomous Transaction Processing Database, this section describes steps to configure the 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.

• 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 p36980569_HDR_82020_Generic.zip file is extracted.

Create HDR FHIR User

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

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

2. Run chmod 700 on create_hdr_fhir_user.sh

3. Run create_hdr_fhir_user.sh

Example

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

sh create_hdr_fhir_user.sh /scratch/app/oracle/product/19c admin hdrdevdb_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/db/fhir/atpdb

2. Run chmod 700 on create_hdr_fhir_database.sh

3. Run create_hdr_fhir_database.sh

Example

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

sh create_hdr_fhir_database.sh /scratch/app/oracle/product/19c hdrdevdb_tpurgent

The script prompts to enter 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.