Create HDR 8.2 Database schemas – CTB and HCT

To setup HDR 8.2 Database schemas (CTB and HCT) on DB version 19c, perform the following:

Create Tablespaces

Execute create_tablespace.sh script to create the tablespaces for both CTB and HCT schemas.

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

2. Run chmod 700 on create_tablespace.sh

3. Run create_tablespace.sh

Example:

sh $HDR_HOME/database/db/hct/create_tablespace.sh <ORACLE_HOME> <SYS_USER_NAME> <DB_HOST> <DB_SERVICE_NAME> <DB_PORT> <TABLESPACE_LOCAION> <CTB_TABLESPACE_NAME> <HCT_TABLESPACE_NAME> <INDEX_TABLESPACE_NAME> <CTX_TABLESPACE_NAME>

sh create_tablespace.sh /scratch/app/oracle/product/19c sys localhost servicename 1521 /scratch/app/oracle/oradata CTB_TBS HCT_TBS IDX_TBS CTX_TBS

The script prompts you to enter SYS user password, provide valid value and hit enter.

Required tablespaces are created for both CTB and HCT schemas.

Create HCT User

Execute create_hct_user.sh script to create the HCT user.

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

2. Run chmod 700 on create_hct_user.sh

3. Run create_hct_user.sh

Example:

sh $HDR_HOME/database/db/hct/create_hct_user.sh <ORACLE_HOME> <SYS_USER> <DB_HOST> <DB_SERVICE_NAME> <DB_PORT> <HCT_TABLESPACE_NAME> <INDEX_TABLESPACE_NAME> <CTX_TABLESPACE_NAME>

sh create_hct_user.sh /scratch/app/oracle/product/19c sys localhost servicename 1521 HCT_TBS IDX_TBS CTX_TBS

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

Create HCT user Database Objects

If you want you want to create HCT schema with all required seed data then execute create_hct_database.sh script to create the HCT schema required database object like tables, indexes, seed data etc.

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

2. Run chmod 700 on create_hct_database.sh

3. Run create_hct_database.sh

Example:

sh $HDR_HOME/database/db/hct/create_hct_database.sh <ORACLE_HOME> <SYS_USER_NAME> <DB_HOST> <DB_SERVICE_NAME> <DB_PORT> <HCT_TABLESPACE_NAME> <INDEX_TABLESPACE_NAME> <CTX_TABLESPACE_NAME> <BASE_LANG_CODE> <JAVA_EXECUTABLE_PATH> <ETS_LIB_PATH>

sh create_hct_database.sh /scratch/app/oracle/product/19c sys localhost servicename 1521 HCT_TBS IDX_TBS CTX_TBS ENUS /scratch/java/jdk11/bin/java $HDR_HOME/database/hdr_cp_lib

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

OR

If you want you want to create HCT schema without seed data then execute create_hct_empty_database.sh script to create the HCT schema required database object like tables, indexes etc. No seed data will be inserted.

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

2. Run chmod 700 on create_hct_empty_database.sh

3. Run create_hct_empty_database.sh

Example:

sh $HDR_HOME/database/db/hct/create_hct_empty_database.sh <ORACLE_HOME> <SYS_USER> <DB_HOST> <DB_SERVICE_NAME> <DB_PORT> <HCT_TABLESPACE_NAME> <INDEX_TABLESPACE_NAME> <CTX_TABLESPACE_NAME> <BASE_LANG_CODE> <JAVA_EXECUTABLE_PATH> <ETS_LIB_PATH>

sh create_hct_empty_database.sh /scratch/app/oracle/product/19c sys localhost servicename 1521 HCT_TBS IDX_TBS CTX_TBS ENUS /scratch/java/jdk11/bin/java $HDR_HOME/database/hdr_cp_lib

The script prompts you to enter SYS user and HCT user password, provide valid values and hit enter. Required HCT schema database objects are created without seed data.

Create CTB User

Execute create_ctb_user.sh script to create the CTB user.

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

2. Run chmod 700 on create_ctb_user.sh

3. Run create_ctb_user.sh

Example:

sh $HDR_HOME/database/db/ctb/create_ctb_user.sh <ORACLE_HOME> <SYS_USER> <DB_HOST> <DB_SERVICE_NAME> <DB_PORT> <CTB_TABLESPACE_NAME> <INDEX_TABLESPACE_NAME>

sh create_hct_user.sh /scratch/app/oracle/product/19c sys localhost servicename 1521 CTB_TBS IDX_TBS

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

Create CTB User Database Objects

If you want you want to create CTB schema with all required seed data then execute create_ctb_database.sh script to create the CTB schema required database object like tables, indexes, seed data etc.

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

2. Run chmod 700 on create_ctb_database.sh

3. Run create_ctb_database.sh

Example:

sh $HDR_HOME/database/db/ctb/create_ctb_database.sh <ORACLE_HOME> <SYS_USER> <DB_HOST> <DB_SERVICE_NAME> <DB_PORT> <CTB_TABLESPACE_NAME> <INDEX_TABLESPACE_NAME> <JAVA_EXECUTABLE_PATH> <CTB_LIB_PATH>

sh create_ctb_database.sh /scratch/app/oracle/product/19c sys localhost servicename 1521 CTB_TBS IDX_TBS /scratch/java/jdk11/bin/java $HDR_HOME/database/hdr_cp_lib

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

OR

If you want you want to create CTB schema without seed data then execute create_ctb_empty_database.sh script to create the CTB schema required database object like tables, indexes etc. No seed data will be inserted.

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

2. Run chmod 700 on create_ctb_empty_database.sh

3. Run create_ctb_empty_database.sh

Example:

sh $HDR_HOME/database/db/ctb/create_ctb_empty_database.sh <ORACLE_HOME> <SYS_USER> <DB_HOST> <DB_SERVICE_NAME> <DB_PORT> <CTB_TABLESPACE_NAME> <INDEX_TABLESPACE_NAME> <JAVA_EXECUTABLE_PATH> <CTB_LIB_PATH>

sh create_ctb_empty_database.sh /scratch/app/oracle/product/19c sys localhost servicename 1521 CTB_TBS IDX_TBS /scratch/java/jdk11/bin/java $HDR_HOME/database/hdr_cp_lib

The script prompts you to enter SYS user and CTB user password, provide valid values and hit enter. Required CTB schema database objects are created without seed data.