Check Prerequisites

- Steps

Checkbox

The user is familiar with Oracle Database (DB), Oracle Data Integrator, and Linux OS.

Checkbox

The Oracle Healthcare Foundation Data Model is installed.

Follow the instructions in Data Model Installation or Data Model Upgrade.

Checkbox

The Data Management Assembly installer is run on the system where the Oracle Data Integrator server is installed.

Checkbox

Make sure that the database compatible parameter is set to 12.2.0.1.0 or higher by connecting to the DBA user and running the query below:

select * from v$parameter where name = 'compatible';

If the parameter is not set to 12.2.0.1.0 or higher, ask your database administrator to set it.

Checkbox

Be sure to backup all custom database objects and custom ETL objects before initiating the Oracle Healthcare Foundation upgrade. Import the custom database objects and custom ETLs into the upgraded environment.

Checkbox

Oracle Healthcare Foundation uses separate HMC schemas for the WIL and HCD loaders. If you have a common HMC schema for OHADI (WIL) and HCD, designate different HMC schemas for WIL (the existing HMC) and HCD (the new HMC_HCD) by performing the following steps:

  1. Create a new HMC schema for HCD loaders. For example: HMC_HCD.
  2. Provide the newly created HMC_HCD schema with the same privileges as the existing HMC schema.
  3. Move the HCD* tables from the existing HMC schema to the new HMC_HCD schema and remove them from the existing HMC schema.

Checkbox

Oracle Data Integrator services can connect to the Data Model 7.3 database mentioned in the Oracle TNS file (TNS entries of the required database must be available in the installation server tnsnames.ora file).

Checkbox

The password expiry notification message does not display for the system user or existing schemas.

Checkbox

The terminology loaders source file location exists. The installer creates an archive directory. For example,

/scratch/home/oemora/TL_Source is the source file location specified during installation, which already exists.

/scratch/home/oemora/TL_Archive_Files is created by the installer as the archive directory.

Checkbox

The path of the data file (Configuration schema/Repository schema tablespace) mentioned when creating the tablespace is correct. Make sure that the database user has write privileges.

Checkbox

Enough space is available in the installation directory and the Oracle Home directory.

Checkbox

The Sqlplus utility is available on the installation server.

Checkbox

The impdp utility is available on the repository database server.

Checkbox

The installation user has read, write, and execute privileges to the $ODI_HOME/odi/agent/bin folder. The installer creates product-specific files under this location.

Checkbox

For remote installations, where the installation server and the Oracle Data Integrator Repository Database server are different machines, make sure that:

  • A directory from the remote database server is mounted to the installation server with appropriate read and write privileges.
  • The remote directory is accessible from the installation server upon mounting.
  • The user that owns Oracle db services on the remote server has privilege 755 for the directory that has been mounted on the installation server.
  • If the database is on an Exadata machine, provide the database single node (the node which is mounted) as the host name when prompted during installation.

Checkbox

GLOBAL_NAMES database initialization parameter is set to false.

Checkbox

Back up the following csv files under $ODI_HOME/odi/agent/bin if it exists:

  • bus_susp_day.csv
  • daylght_svngs_day.csv
  • hosp_hol_day.csv
  • time_odi.csv

Checkbox

If the Terminology Loaders source folder is shared, make a backup of the following files:

  • Code Axes.txt
  • Code Descriptions.txt
  • Code Hierarchy.txt
  • Code.txt
  • Related Entity.txt
  • Relations Type.txt
  • Relations.txt
  • Relationship Type.txt
  • time.txt

The installer will overwrite any existing files from the list above.

Checkbox

If any previous ETLs are in the failed status, make sure that they execute successfully before upgrading.

Checkbox

Make sure that the data models are upgraded to Oracle Healthcare Foundation 8.0.

Checkbox

The OUI displays default configuration schema (hmc) names. You must change these schema names to the existing hmc schema names.

The installer upgrades the configuration schemas to Oracle Healthcare Foundation 8.0.

Checkbox

Back up the existing hmc schemas.

Note:

The installer auto-populates some of the user parameters and lets you edit them.