Upgrade HDR FHIR Database Schema to HDR 8.2.0.2

If you are already using HDR FHIR 8.2/8.2.0.1 schema, you can upgrade to HDR FHIR 8.2.0.2 schema.

To upgrade HDR FHIR 8.2/8.2.0.1 Database schema to HDR8.2.0.2, perform the following:

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

2. Run chmod 700 on upgrade_fhir_schema_from_82_to_8202.sh

3. Run upgrade_fhir_schema_from_82_to_8202.sh

Example

sh $HDR_HOME/db/fhir/upgrade-hdr-fhir-schema-to-8202/upgrade_fhir_schema_from_82_to_8202.sh <ORACLE_HOME> <SYS_USER_NAME>
<DB_HOST> <DB_SERVICE_NAME> <DB_PORT> <HDR_FHIR_USER_NAME>

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

The script prompts you to enter SYS user password, HDR FHIR user password, HDR FHIR user current data tablespace name and HDR FHIR user current index tablespace name, provide valid values and hit enter. Required database objects like tables, sequences, indexes etc. are upgraded to HDR FHIR 8.2.0.2 schema.

Note:

The upgrade is not a data migration, it’s only a FHIR schema upgrade to HAPI 6.8.8 version compatible.