Create HDR FHIR Database Schema

To setup HDR FHIR Database schema on DB version 19c, perform the following.

Create Tablespaces

Execute create_tablespace.sh script to create the tablespaces for HDR FHIR schema.

1. Navigate to $HDR_HOME/db/fhir/create-hdr-fhir-schema

2. Run chmod 700 on create_tablespace.sh

3. Run create_tablespace.sh

Example

sh $HDR_HOME/db/fhir/create-hdr-fhir-schema/create_tablespace.sh <ORACLE_HOME> <SYS_USER> <DB_HOST> <DB_SERVICE_NAME> <DB_PORT> <TABLESPACE_LOCAION> <FHIR_TABLESPACE_NAME> <INDEX_TABLESPACE_NAME>

sh create_tablespace.sh /scratch/app/oracle/product/19c sys localhost servicename 1521 /scratch/app/oracle/oradata OHF_FHIR_DATA_TBS OHF_FHIR_IDX_TBS

The script prompts you to enter SYS user password, provide valid values and hit enter. Required tablespaces are created for HDR FHIR user.

Create HDR FHIR User

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

1. Navigate to $HDR_HOME/db/fhir/create-hdr-fhir-schema

2. Run chmod 700 on create_hdr_fhir_user.sh

3. Run create_hdr_fhir_user.sh

Example

sh $HDR_HOME/db/fhir/create-hdr-fhir-schema/create_hdr_fhir_user.sh <ORACLE_HOME> <SYS_USER> <DB_HOST> <DB_SERVICE_NAME> <DB_PORT> <HDR_FHIR_USER_NAME>

sh create_hdr_fhir_user.sh /scratch/app/oracle/product/19c sys localhost servicename 1521 HDR_FHIR

The script prompts you to enter SYS user and HDR FHIR user password, provide valid values and hit enter. HDR FHIR user is created.

Create HDR FHIR user Database Objects

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

1. Navigate to $HDR_HOME/db/fhir/create-hdr-fhir-schema

2. Run chmod 700 on create_hdr_fhir_database.sh

3. Run create_hdr_fhir_database.sh

Example

sh $HDR_HOME/db/fhir/create-hdr-fhir-schema/create_hdr_fhir_database.sh <ORACLE_HOME> <SYS_USER> <DB_HOST> <DB_SERVICE_NAME> <DB_PORT> <HDR_FHIR_USER_NAME>

sh create_hdr_fhir_database.sh /scratch/app/oracle/product/19c sys localhost servicename 1521 HDR_FHIR

The script prompts you to enter SYS user and HDR FHIR user password, provide valid values and hit enter. Required database objects like tables, sequences, indexes etc. are created for HDR FHIR user.