Upgrading HTB to HDR

This section contains the following topics:

"Upgrading HTB 5.3 to HDR 7.0"
"Upgrading HTB 6.1/6.1.1 to HDR 7.0"

Upgrading HTB 5.3 to HDR 7.0

This section contains the following topics:

"Prerequisites"
"Upgrading the HTB 5.3 Database Schema to HDR 7.0"
"Installing the HDR Middle-Tier using the Oracle Universal Installer"
"Running the HDR Terminology 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 Linux 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>
ORACLE_HOME_LISTENER - Oracle database listener home directory
PATH - $ORACLE_HOME/bin:$PATH
WL_HOME - WebLogic home directory

Upgrading the HTB 5.3 Database Schema to HDR 7.0

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

Download the Oracle Healthcare Data Repository 7.0 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/HDR70.
Navigate to the artifacts/migration_scripts/HTB5.3_HDR7.0/HTB5.3_HDR7.0_PARTITION_KEY directory.
Create the following tablespaces on the HDR70 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.1/6.1.1 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> 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> 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, 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 ENUS.
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.

Running the HDR Terminology Jobs

To run the HDR Terminology Jobs, perform the following:

Create gather statistics procedure for ETS jobs as mentioned in Creating Gather Statistics Procedure for ETS Jobs.
Navigate to artifacts/migration_scripts/ETS where the artifacts.zip is extracted.
Execute the execute_ets_job.sh shell script.

Upgrading HTB 6.1/6.1.1 to HDR 7.0

This section contains the following topics:

"Prerequisites"
"Upgrading the HTB 6.1/6.1.1 Database Schema to HDR 7.0"
"Installing the HDR Middle-Tier using the Oracle Universal Installer"
"Running the HDR Terminology Jobs"

Prerequisites

Take backup of the existing HTB 6.1/6.1.1 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 Linux 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>
ORACLE_HOME_LISTENER - Oracle database listener home directory
PATH - $ORACLE_HOME/bin :$PATH
WL_HOME - WebLogic home directory

Upgrading the HTB 6.1/6.1.1 Database Schema to HDR 7.0

To upgrade the HTB 6.1/6.1.1 database schema to HDR 7.0, perform the following:

Download the Oracle Healthcare Data Repository 7.0 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/HDR70.
Create the following tablespaces on the HDR70 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/HTB6.1_HDR7.0/ folder. Else, navigate to the artifacts/migration_scripts/HTB6.1_HDR7.0/HTB6.1_ HDR7.0_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.1/6.1.1 dump file is located:

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

Import the HCT objects from HTB 6.1/6.1.1 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.1/6.1.1 dump file name >.dmp logfile=htb_hct_import.log

Import the CTB objects from HTB 6.1/6.1.1 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.1/6.1.1 dump file name>.dmp logfile=htb_ctb_import.log

Import the following tables from APPLSYS from HTB 6.1/6.1.1 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.1/6.1.1 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:

Create gather statistics procedure for ETS jobs as mentioned in Creating Gather Statistics Procedure for ETS Jobs.
Navigate to artifacts/migration_scripts/ETS where the artifacts.zip is extracted.
Execute the execute_ets_job.sh shell script.