Upgrading HTB to HDR

This chapter contains the following topics:

"Upgrading HTB 5.3 to HDR 7.0.1"
"Upgrading HTB 6.X to HDR 7.0.1"

Upgrading HTB 5.3 to HDR 7.0.1

This section contains the following topics:

"Prerequisites"
"Upgrading the HTB 5.3 Database Schema to HDR 7.0.1"
"Installing the HDR Middle-Tier using the Oracle Universal Installer"
"Creating HDR Terminology Jobs"
"Creating the Bulk Data Loader Jobs"

Prerequisites

Take backup of the existing HTB 5.3 schemas for CTB and HCT. Export the CTB, HCT, and the following tables from the APPLSYS schema to a dump:

FND_PROFILE_OPTIONS
FND_PROFILE_OPTIONS_TL
FND_PROFILE_OPTION_VALUES
FND_USER
FND_LANGUAGES
FND_APPLICATION

Following is an example for an exporting dump:

expdp system/<password>@<SID> schemas=CTB,HCT,APPLSYS exclude=GRANT,USER,STATISTICS,TABLESPACE_QUOTA,DEFAULT_ROLEdirectory=htb_dmp_dir dumpfile=<dump file name>.dmplogfile=htb_dump.log

Set the following environment variables on the machine from where the HDR installer will be run:

JAVA_HOME - JDK1.7 install directory
ANT_HOME - Ant home path (Ant 1.7.1 or later)
ORACLE_HOME - Oracle database home directory
TWO_TASK - Oracle Service Name. If you are installing HDR on the Oracle 12c pluggable database (PDB), then set this variable before running the HDR installer.
ORACLE_HOME_LISTENER - Oracle database listener home directory
PATH - $ORACLE_HOME/bin:$PATH
HDR_HOME - Directory where HDR must be installed
WL_HOME - WebLogic home directory

If you are installing HDR on the Oracle 12c pluggable database (PDB), then perform the following:

Edit $ORACLE_HOME/network/admin/tnsnames.ora and add an entry for the PDB service name. The tnsname shall be same as the PDB service name.
Edit $ORACLE_HOME/network/admin/listener.ora and add the USE_SID_AS_SERVICE_listener=on line.

Upgrading the HTB 5.3 Database Schema to HDR 7.0.1

To upgrade the HTB 5.3 database schema to HDR 7.0.1, perform the following:

Download the Oracle Healthcare Data Repository 7.0.1 software from the Oracle E-Delivery website (https://edelivery.oracle.com/).
Extract the files from HDR_Installer.zip and artifacts.zip to the database machine folder, /home/HDR701.
Navigate to the artifacts/migration_scripts/HTB5.3_HDR7.0.1/HTB5.3_HDR7.0.1_PARTITION_KEY directory.
Create the following tablespaces on the HDR701 target database by connecting as the sys user:
1. Tablespace for HCT user
2. Tablespace for CTB user
3. Tablespace for Context
4. Tablespace for Indexes
For example, execute the following script to create the tablespaces:
```
Create TABLESPACE <tablespace name>
LOGGING
DATAFILE '<data file path>/hdr_hcttb.dbf' 
SIZE <100M>
AUTOEXTEND ON
NEXT <100M> MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;
```
Create the HCT and the CTB schema users by executing the following script:

sh create_hdr_user.sh
Execute the following script (by connecting as sys user) to create a directory, HTB_DUMP_DIR on the Oracle database where the HTB 6.X dump file is located:

CREATE OR REPLACE DIRECTORY HTB_DMP_DIR as '<path>';

Import the HCT objects from HTB 5.3 to the target HCT schema.

For example, execute the following script to import the HCT objects:

Notes:

Ensure that appropriate tablespace names, dump path, and log file path are mentioned in the script.

impdp system/<password> exclude=GRANT,USER,STATISTICS,TABLESPACE_QUOTA,DEFAULT_ROLE schemas=hct remap_schema=apps:hct
remap_schema=applsys:hct remap_tablespace=APPS_TS_SEED:hct_tbs
remap_tablespace=APPS_TS_TX_DATA:<hct_tbs>
remap_tablespace=APPS_TS_TX_IDX:<idx_tbs>
remap_tablespace=APPS_TS_NOLOGGING:<hct_tbs>
remap_tablespace=APPS_TS_MEDIA:<hct_tbs>
remap_tablespace=APPS_TS_INTERFACE:<hct_tbs>
remap_tablespace=APPS_TS_QUEUES:<hct_tbs>
remap_tablespace=APPS_TS_ARCHIVE:<hct_tbs>
remap_tablespace=APPS_TS_SUMMARY:<hct_tbs>
remap_tablespace=APPS_TS_TOOLS:<hct_tbs> directory=HTB_DMP_DIR
dumpfile=< HTB 5.3 dump file name >.dmp logfile=htb_hct_import.log

Import the CTB objects from HTB 5.3 to the target CTB schema.

For example, execute the following script to import the CTB objects:

Note:

Ensure that appropriate tablespace names, dump path, and log file path are mentioned in the script.

impdp system/<password> exclude=GRANT,USER,STATISTICS,TABLESPACE_QUOTA,DEFAULT_ROLE schemas=ctb remap_schema=apps:ctb
remap_schema=applsys:ctb remap_tablespace=APPS_TS_SEED:ctb_tbs
remap_tablespace=APPS_TS_TX_DATA:<ctb_tbs>
remap_tablespace=APPS_TS_TX_IDX:<idx_tbs>
remap_tablespace=APPS_TS_NOLOGGING:<ctb_tbs>
remap_tablespace=APPS_TS_MEDIA:<ctb_tbs>
remap_tablespace=APPS_TS_INTERFACE:<ctb_tbs>
remap_tablespace=APPS_TS_QUEUES:<ctb_tbs>
remap_tablespace=APPS_TS_ARCHIVE:<ctb_tbs>
remap_tablespace=APPS_TS_SUMMARY:<ctb_tbs>
remap_tablespace=APPS_TS_TOOLS:<ctb_tbs> directory=HTB_DMP_DIR
dumpfile=<HTB 5.3 dump file name>.dmp logfile=htb_ctb_import.log

Import the following tables from APPLSYS from HTB 5.3 to the HCT schema on target database:

For example, execute the following script to import the tables:

Notes:

Ensure that appropriate tablespace names, dump path, and log file path are mentioned in the script.
Before importing the dumps to the target database, ensure that there is enough tablespace available on the target database.

impdp system/<password>
tables=APPLSYS.FND_LANGUAGES,APPLSYS.FND_USER,APPLSYS.FND_APPLICATION,APPLSYS.FND_PROFILE_OPTIONS,APPLSYS.FND_PROFILE_OPTIONS_TL,APPLSYS.FND_PROFILE_OPTION_VALUES
remap_schema=apps:hct remap_schema=applsys:hct remap_tablespace=APPS_TS_SEED:<hct_tbs>
remap_tablespace=APPS_TS_TX_DATA:<hct_tbs>
remap_tablespace=APPS_TS_TX_IDX:<idx_tbs>
remap_tablespace=APPS_TS_NOLOGGING:<hct_tbs>
remap_tablespace=APPS_TS_MEDIA:<hct_tbs>
remap_tablespace=APPS_TS_INTERFACE:<hct_tbs>
remap_tablespace=APPS_TS_QUEUES:<hct_tbs>
remap_tablespace=APPS_TS_ARCHIVE:<hct_tbs>
remap_tablespace=APPS_TS_SUMMARY:<hct_tbs>
remap_tablespace=APPS_TS_TOOLS:<hct_tbs> directory=HTB_DMP_DIR
dumpfile=<HTB 5.3 dump file name>.dmp logfile=hct_fnd_import.log

Note:

Ignore the following errors while importing the dump:

ORA-01917: User or role <role/user> does not exist.
ORA-39083: Object type OBJECT_GRANT failed to create with error.
ORA-39146: The APPLSYS schema does not exist.

Specify the degree of parallelism (DOP) for running the migration scripts in parallel.
Execute the following script to upgrade the HCT schema to HDR:

> sh migrate_hct_db_objects.sh

The script prompts you to enter HCT user name, password, tablespace name, and ETS language.

Enter ENUS for ETS language.
Execute the following script to upgrade the CTB Schema to HDR:

> sh migrate_ctb_db_objects.sh

The script prompts you to enter CTB user name, password, and tablespace name.
Check the actual usage of all the preceding tablespaces and optimize the tablespace accordingly.

Installing the HDR Middle-Tier using the Oracle Universal Installer

For information on how to install the HDR middle-tier using the Oracle universal installer, see Running Installer for HDR Middle-Tier Installation.

For information on how to install the HDR middle-tier without using the Oracle Universal installer, see Installing HDR without using the Oracle Universal Installer.

Creating HDR Terminology Jobs

To create HDR Terminology Jobs, perform the following:

Extract the artifacts.zip.
Navigate to the /artifacts/db/hdr_cp_lib folder and edit bc4j.properties for database details.
Navigate to artifacts/migration_scripts/ETS where the artifacts.zip is extracted.
Execute the execute_ets_job.sh shell script.

Creating the Bulk Data Loader Jobs

To create the HDR Bulk Data Loader (BDL) jobs, perform the following:

Navigate to artifacts/migration_scripts/BDL where the artifacts.zip is extracted.
Execute the create_bdl_job.sh shell script to create the BDL log directory and jobs.

Upgrading HTB 6.X to HDR 7.0.1

This section contains the following topics:

"Prerequisites"
"Upgrading the HTB 6.X Database Schema to HDR 7.0.1"
"Installing the HDR Middle-Tier using the Oracle Universal Installer"
"Running the HDR Terminology Jobs"
"Creating the Bulk Data Loader Jobs"

Prerequisites

Take backup of the existing HTB 6.X schemas for CTB and HCT. Export the following tables from the APPLSYS schema to a dump:
- FND_PROFILE_OPTIONS
- FND_PROFILE_OPTIONS_TL
- FND_PROFILE_OPTION_VALUES
- FND_USER
- FND_LANGUAGES
- FND_APPLICATION

Following is an example of a dump:

expdp system/<password>@<SID> schemas=CTB,HCT,APPLSYS exclude=GRANT,USER,STATISTICS,TABLESPACE_QUOTA,DEFAULT_ROLE
directory=htb_dmp_dir dumpfile=<dump file name>.dmp
logfile=htb_dump.log

Set the following environment variables on the machine from where the HDR installer will be run:

JAVA_HOME - JDK1.7 install directory
ANT_HOME - Ant home path (Ant 1.7.1 or later)
ORACLE_HOME - Oracle database home directory
TWO_TASK - Oracle Service Name. If you are installing HDR on the Oracle 12c pluggable database (PDB), then set this variable before running the HDR installer.
ORACLE_HOME_LISTENER - Oracle database listener home directory
PATH - $ORACLE_HOME/bin :$PATH
HDR_HOME - Directory where HDR must be installed
WL_HOME - WebLogic home directory

If you are installing HDR on the Oracle 12c pluggable database (PDB), then perform the following:

Edit $ORACLE_HOME/network/admin/tnsnames.ora and add an entry for the PDB service name. The tnsname shall be same as the PDB service name.
Edit $ORACLE_HOME/network/admin/listener.ora and add the USE_SID_AS_SERVICE_listener=on line.

Upgrading the HTB 6.X Database Schema to HDR 7.0.1

To upgrade the HTB 6.X database schema to HDR 7.0.1, perform the following:

Download the Oracle Healthcare Data Repository 7.0.1 software from the Oracle E-Delivery website (https://edelivery.oracle.com/).
Extract the files from HDR_Installer.zip and artifacts.zip to the database machine folder, /home/HDR701.
Create the following tablespaces on the HDR701 target database by connecting as the sys user:
1. Tablespace for HCT user
2. Tablespace for CTB user
3. Tablespace for Context
4. Tablespace for Indexes
For example, execute the following script to create the tablespaces:
```
Create TABLESPACE <tablespace name>
LOGGING 
DATAFILE '<data file path>/hdr_hcttb.dbf' 
SIZE <100M>
AUTOEXTEND ON
NEXT <100M> MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;
```
If the CTB schema tables are already partitioned using the HTB partition patches, then navigate to the artifacts/migration_scripts/HTB6.1_HDR7.0.1/HTB6.1_HDR7.0.1/ folder. Else, navigate to the artifacts/migration_scripts/HTB6.1_HDR7.0.1/HTB6.1_ HDR7.0.1_PARTITION_KEY folder.
Create the HCT schema and the CTB schema users by executing the following script:

sh create_hdr_user.sh
Execute the following script (by connecting as the sys user) to create the HTB_DUMP_DIR directory on the Oracle database where the HTB 6.X dump file is located:

CREATE OR REPLACE DIRECTORY HTB_DMP_DIR as '<path>';

Import the HCT objects from HTB 6.X to the target HCT schema.

For example, execute the following script to import the HCT objects:

Note:

Ensure that appropriate tablespace names, dump path, and log file path are mentioned in the script.

impdp system/<password> schemas=hct remap_schema=apps:hct remap_schema=applsys:hct remap_tablespace=APPS_TS_SEED:hct_tbs
remap_tablespace=APPS_TS_TX_DATA:<hct_tbs>
remap_tablespace=APPS_TS_TX_IDX:<idx_tbs>
remap_tablespace=APPS_TS_NOLOGGING:<hct_tbs>
remap_tablespace=APPS_TS_MEDIA:<hct_tbs>
remap_tablespace=APPS_TS_INTERFACE:<hct_tbs>
remap_tablespace=APPS_TS_QUEUES:<hct_tbs>
remap_tablespace=APPS_TS_ARCHIVE:<hct_tbs>
remap_tablespace=APPS_TS_SUMMARY:<hct_tbs>
remap_tablespace=APPS_TS_TOOLS:<hct_tbs> directory=HTB_DMP_DIR
dumpfile=< HTB 6.X dump file name >.dmp logfile=htb_hct_import.log

Import the CTB objects from HTB 6.X to the target CTB schema.

For example, execute the following script to import the CTB objects:

Notes:

Ensure that appropriate tablespace names, dump path, and log file path are mentioned in the script.

impdp system/<password> schemas=ctb remap_schema=apps:ctb remap_schema=applsys:ctb remap_tablespace=APPS_TS_SEED:ctb_tbs
remap_tablespace=APPS_TS_TX_DATA:<ctb_tbs>
remap_tablespace=APPS_TS_TX_IDX:<idx_tbs>
remap_tablespace=APPS_TS_NOLOGGING:<ctb_tbs>
remap_tablespace=APPS_TS_MEDIA:<ctb_tbs>
remap_tablespace=APPS_TS_INTERFACE:<ctb_tbs>
remap_tablespace=APPS_TS_QUEUES:<ctb_tbs>
remap_tablespace=APPS_TS_ARCHIVE:<ctb_tbs>
remap_tablespace=APPS_TS_SUMMARY:<ctb_tbs>
remap_tablespace=APPS_TS_TOOLS:<ctb_tbs> directory=HTB_DMP_DIR
dumpfile=<HTB 6.X dump file name>.dmp logfile=htb_ctb_import.log

Import the following tables from APPLSYS from HTB 6.X to the HCT schema on the target database:

For example, execute the following script to import the tables:

Notes:

Ensure that appropriate tablespace names, dump path, and log file path are mentioned in the script.
Before importing the dumps to the target database, ensure that there is enough tablespace available for on the target database.

impdp system/<password>
tables=APPLSYS.FND_LANGUAGES,APPLSYS.FND_USER,APPLSYS.FND_APPLICATION,APPLSYS.FND_PROFILE_OPTIONS,APPLSYS.FND_PROFILE_OPTIONS_TL,APPLSYS.FND_PROFILE_OPTION_VALUES
remap_schema=apps:hct remap_schema=applsys:hct remap_tablespace=APPS_TS_SEED:<hct_tbs>
remap_tablespace=APPS_TS_TX_DATA:<hct_tbs>
remap_tablespace=APPS_TS_TX_IDX:<idx_tbs>
remap_tablespace=APPS_TS_NOLOGGING:<hct_tbs>
remap_tablespace=APPS_TS_MEDIA:<hct_tbs>
remap_tablespace=APPS_TS_INTERFACE:<hct_tbs>
remap_tablespace=APPS_TS_QUEUES:<hct_tbs>
remap_tablespace=APPS_TS_ARCHIVE:<hct_tbs>
remap_tablespace=APPS_TS_SUMMARY:<hct_tbs>
remap_tablespace=APPS_TS_TOOLS:<hct_tbs> directory=HTB_DMP_DIR
dumpfile=<HTB 6.X dump file name>.dmp logfile=hct_fnd_import.log

Note:

Ignore the following errors while importing the dump:

ORA-01917: User or role <role/user> does not exist.
ORA-39083: Object type OBJECT_GRANT failed to create with error.
ORA-39146: The APPLSYS schema does not exist.

Specify the degree of parallelism.
Execute the following script to upgrade the HCT schema to HDR.

> sh migrate_hct_db_objects.sh

The script prompts you to enter HCT user name, password, and tablespace name details.
Execute the following script to upgrade the CTB schema to HDR:

> sh migrate_ctb_db_objects.sh

The script prompts you to enter CTB user name, password, and tablespace name details. When the script prompts for the ETS language, enter the value as ENS.
Check the actual usage of all the preceding tablespaces and optimize the tablespace accordingly.

Installing the HDR Middle-Tier using the Oracle Universal Installer

For information on how to install the HDR middle-tier using the Oracle Universal Installer, see Running Installer for HDR Middle-Tier Installation.

For information on how to install the HDR middle -tier application without using the Oracle Universal installer, see Installing HDR without using the Oracle Universal Installer.

Running the HDR Terminology Jobs

To run the HDR Terminology Jobs, perform the following:

Navigate to artifacts/migration_scripts/ETS where the artifacts.zip is extracted.
Execute the execute_ets_job.sh shell script.

Creating the Bulk Data Loader Jobs

To create the HDR Bulk Data Loader (BDL) jobs, perform the following:

Navigate to artifacts/migration_scripts/BDL where the artifacts.zip is extracted.
Execute the create_bdl_job.sh shell script to create the BDL log directory and jobs.