1. Installation Guide
  2. Installation
  3. Data Management Assembly for Oracle Data Integrator Installation
  4. Installing the Data Management Assembly with Pre-Created User Schemas

Installing the Data Management Assembly with Pre-Created User Schemas

Complete the following:

Parent topic: Data Management Assembly for Oracle Data Integrator Installation

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

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 pre-created schemas or system user.

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

Check write permissions on oraInventory is granted to “others”. If write permissions are not granted then add the user that the oracle software being installed to the group of the inventory owner (for instance - oinstall) as root:

usermod -a -G <ORA inventory owner> <installation_user>

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 Database 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

In the case of an Oracle Healthcare Foundation upgrade, 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

In the case of an Oracle Healthcare Foundation upgrade, 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.

Note:

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

Parent topic: Installing the Data Management Assembly with Pre-Created User Schemas

Create Default and Temporary Tablespaces

Create the following default and temporary tablespaces with appropriate quotas. You can use different tablespace names than the ones listed below.

Note:

The hmc_ts and hmc_temp tablespaces must be created in the Data Model database instance.
- Tablespace Name Big File Tablespace Description

Checkbox

odirep_ts

Yes

Default tablespace for the Repository schema.

Checkbox

odirep_temp

Yes

Temporary tablespace for the Repository schema.

Checkbox

hmc_ts

Yes

Default tablespace for the Configuration schema.

Checkbox

hmc_temp

Yes

Temporary tablespace for the Configuration schema.

Checkbox

wil_odi_ts

Yes

Default tablespace for Oracle Data Integrator temporary objects for Warehouse Integration loaders.

Checkbox

hcd_odi_ts

Yes

Default tablespace for Oracle Data Integrator temporary objects for Healthcare Common Data mart loaders.

Checkbox

cdm_odi_ts

Yes

Default tablespace for Oracle Data Integrator temporary objects for Cohort Data mart loaders.

Checkbox

tl_odi_ts

Yes

Default tablespace for Oracle Data Integrator temporary objects for terminology loaders.

Parent topic: Installing the Data Management Assembly with Pre-Created User Schemas

Create User Schemas

Create the following user schemas and assign the appropriate default and temporary tablespaces. Refer to Create Default and Temporary Tablespaces for details. If you created tablespaces with different names, use those instead.

- Schema Name Schema Description Default Tablespace Temporary Tablespace

Checkbox

wil_hmc

Warehouse Integration Loader Configuration schema

hmc_ts

hmc_temp

Checkbox

hcd_hmc

Healthcare Common Data Mart Configuration schema

hmc_ts

hmc_temp

Checkbox

tl_master_rep_80

Terminology Loader Master Repository schema

odirep_ts

odirep_temp

Checkbox

tl_work_rep_80

Terminology Loader Work Repository schema

odirep_ts

odirep_temp

Checkbox

wil_master_rep_80

Warehouse Integration Loader Master Repository schema

odirep_ts

odirep_temp

Checkbox

wil_work_rep_80

Warehouse Integration Loader Work Repository schema

odirep_ts

odirep_temp

Checkbox

hcd_master_rep_80

Healthcare Common Data Mart Master Repository schema

odirep_ts

odirep_temp

Checkbox

hcd_work_rep_80

Healthcare Common Data Mart Work Repository schema

odirep_ts

odirep_temp

Checkbox

cdm_master_rep_80

Healthcare Cohort Data Mart Master Repository schema

odirep_ts

odirep_temp

Checkbox

cdm_work_rep_80

Healthcare Cohort Data Mart Work Repository schema

odirep_ts

odirep_temp

Parent topic: Installing the Data Management Assembly with Pre-Created User Schemas

Prepare the Installer

- Steps

Checkbox

Extract the contents of the Oracle Healthcare Foundation media pack to your system.

Checkbox

Navigate to media_pack_location/ folder.

Checkbox

Unzip the OHF_V81_Linux-x64.zip file where you want to launch the installer using the following command:

unzip -a OHF_V81_Linux-x64.zip

Checkbox

Navigate to the media_pack_location/Disk2/stage/Components/oracle.hsgbu.hc.dma.odi/8.1.0.0.0/1/DataFiles/Expanded/filegroup1 directory.

Checkbox

Unzip the dma_odi_master_install.zip file.

Checkbox

Navigate to the dma_odi_master_install/hmc_odi_install/ directory.

Checkbox

Connect to the system user and execute the following scripts:

  • @odi_hdi_user_privilege.sql HDI_SCHEMA_NAME
  • @odi_hmc_user_privilege.sql WIL_HMC_SCHEMA_NAME HCD_HMC_SCHEMA_NAME

  • @odi_rep_user_privilege.sql HLI_MASTER_REP_USR WIL_MASTER_REP_USR AT_MASTER_REP_USR HLI_WORK_REP_USR WIL_WORK_REP_USR AT_WORK_REP_USR CDM_MASTER_REP_USR CDM_WORK_REP_USR

Checkbox

Navigate to the media_pack_location/Disk1/install folder.

Checkbox

Change the protection on the files as follows:

chmod 755 *

Parent topic: Installing the Data Management Assembly with Pre-Created User Schemas

Run the Installer

Start the Oracle Universal Installer by running the following command:

  • If the Oracle Data Integrator repository schemas (master and work) to be created are on the database instance of the installation server, execute:

    sh runInstaller.sh -local dba_tasks=false

  • If the Oracle Data Integrator repository database or Oracle Healthcare Foundation data model database is on the database instance of another server, execute:

    sh runInstaller.sh -local remote_installation=true dba_tasks=false

where, the -local option is to install on the local node irrespective of the cluster nodes specified on the installer machine.

- Screen Action

Checkbox

Welcome

Click Next.

Checkbox

Select a Product to Install

Select the Oracle Healthcare Foundation Data Management Assembly for ODI 8.0.0.0.0 option.

Checkbox

Specify Home Details

Enter the installation home path.

Checkbox

Verify Installation Prerequisites

Verify if all of the prerequisites are met before proceeding.

Checkbox

Select the Oracle Home Configuration

Specify the Oracle client home path.

Checkbox

Select the Oracle Data Integrator Home Location

Specify the Oracle Data Integrator home location.

The Oracle Data Integrator home should be one level above the /oracle_common directory. For example, /u01/app/oracle/Oracle_ODI1.

Checkbox

Select Database Server for Oracle Data Integrator Repository Schemas

Select one of the following options for the Oracle Data Integrator repository schemas:

  • If the Oracle Data Integrator repository database server is on the installation server, select the Installation database server option.
  • Else, select the Remote database server option.

Checkbox

Specify Mount Path Details (applicable only for remote installations)

Enter the configuration details for the mounted remote server directory:

  • Mounted directory path on the remote server.
  • Mount path on the installation server.

To obtain the available storage drives, on the Linux machine, execute the df -h command. If the remote server directory is mounted on the installation server, the mounting is displayed as follows: 

Remote Server name:Remote server path
total size Available space use% Path in installation server where mounting was done

For example:

abc:/scrath/dump
191g 138g 44g 76% / installation server

Note:

  • The directory of the remote database server should be mounted to the installation server with appropriate read and write privileges for the IMPDB utility (folder with dba group).
  • If the remote server mounted path is displayed as /, provide the absolute mounted path of the remote server.

Checkbox

Specify Healthcare Data Model Database Instance Details

Enter values for the following fields:

  • Host name - By default, the system host name appears. For remote installations, set this value to the host name of the remote machine.
  • Port number
  • Service name
  • Select this database instance for repository schema creation

    If you select Yes, the installer uses the same Data Model database instance for Oracle Data Integrator repository schema creation.

Checkbox

Specify Oracle Data Integrator Repository Database Instance Details (applicable only if you selected No in the previous screen for Select this database instance for repository schema creation)

Enter values for the following fields:

  • Host name - By default, the system host name appears. For remote installations, set this value to the host name of the remote machine.
  • Port
  • Service name

Checkbox

Specify Oracle Data Integrator Supervisor Password

Specify the supervisor password used for the Oracle Data Integrator console login.

Checkbox

Select Terminology Loaders Source Location

Specify the Terminology loaders source file location.

This location is used to read the terminology loaders source data files. You can change this location when required.

The installer creates an archive directory at the same level as the source directory. Make sure that the create directory privileges exist for the installation user.

Checkbox

Specify Healthcare Data Model Schema Details

Enter values for the pre-created schemas:

  • Interface table schema name
  • Interface table schema password
  • Data warehouse schema name
  • Data warehouse schema password
  • Common data mart (hcd) schema name
  • Common data mart (hcd) schema password
  • Cohort data mart (cdm) schema name
  • Cohort data mart (cdm) schema password

Checkbox

Specify Healthcare Data Model Schema Details

Enter values for the pre-created schemas:

  • Enterprise schema name
  • Enterprise schema password.

Checkbox

Specify Terminology Loader Details

Enter values for the pre-created schemas:

  • Master repository schema name
  • Master repository schema password
  • Work repository schema name
  • Work repository schema password

The installer imports loaders into the pre-created terminology loaders repository schemas.

Checkbox

Specify Warehouse Integration Loader Details

Enter values for the pre-created schemas:

  • Configuration schema name
  • Configuration schema password
  • Master repository schema name
  • Master repository schema password
  • Work repository schema name
  • Work repository schema password

The installer imports loaders into the pre-created warehouse integration loaders repository schemas.

Checkbox

Specify Healthcare Common Data Mart Loader Details

Enter values for the pre-created schemas:

  • Configuration schema name
  • Configuration schema password
  • Master repository schema name
  • Master repository schema password
  • Work repository schema name
  • Work repository schema password

The installer imports loaders into the pre-created common data mart loaders repository schemas.

Checkbox

Specify Healthcare Cohort Data Mart Loader Details

Enter values for the pre-created schemas:

  • Master repository schema name
  • Master repository schema password
  • Work repository schema name
  • Work repository schema password

The installer imports loaders into the pre-created cohort data mart loaders repository schemas.

The configuration schema is not required for CDM.

Checkbox

Specify RCU Prefix and Password

Specify an RCU prefix to be prepended to the schemas created by the Oracle Data Integrator Repository Creation Utility (RCU). The RCU creates 3 schemas:

  • RCU Prefix_STB
  • RCU Prefix_WLS
  • RCU Prefix_WLS_RUNTIME

Note: The RCU Prefix must be unique. The prefix should be alphabetic only. It cannot have special characters and cannot start with a number. The length of the prefix must not exceed 8 characters.

Specify a password for schemas created using the Oracle Data Integrator Repository Creation Utility (RCU).

Note: The password must be between 8 and 12 alphanumeric characters long and must include at least one number. The password cannot start with a number.

Checkbox

Specify Tablespace for Creation of Oracle Data Integrator Temporary Objects

Specify tablespace names for the creation of temporary objects used by the Oracle Data Integrator loaders. The installer creates the following tablespaces if they do not exist:

  • Warehouse Integration Loaders
  • Healthcare Common Datamart Loaders
  • Cohort Datamart Loaders
  • Terminology Loaders

Oracle recommends that you provide different tablespace names for each component.

Checkbox

Verify Configuration Parameters

Click Next.

Checkbox

Summary

Click Install.

Checkbox

End of Installation

Click Exit after reviewing the installation information. At the confirmation prompt, click Yes to exit the installer.

Parent topic: Installing the Data Management Assembly with Pre-Created User Schemas

Check the Installation

- Steps

Checkbox

Review the generated installation log files for errors. For details, see Installation Log Files.

Checkbox

Contact Oracle support, if necessary, to resolve any errors.

Parent topic: Installing the Data Management Assembly with Pre-Created User Schemas

Revoke Privileges

After the Data Management Assembly for Oracle Data Integrator installation, run the following scripts from a user with DBA privileges:

@OHF_Install_Home/dma_odi_master_install/hmc_odi_install/dma_directory_drop.sql

@@OHF_Install_Home/dma_odi_master_install/hmc_odi_install/dma_revoke_privilege.sql WIL_MASTER_REP_USR HCD_MASTER_REP_USR CDM_MASTER_REP_USR HLI_MASTER_REP_USR

where,

OHF_Install_Home - Oracle Healthcare Foundation installation home directory

WIL_MASTER_REP_USR - Warehouse integration loader master repository schema name

HCD_MASTER_REP_USR - Healthcare common data mart loader master repository schema name

CDM_MASTER_REP_USR - Cohort data mart loader master repository schema name

HLI_MASTER_REP_USR - Terminology loader master repository schema name

Parent topic: Installing the Data Management Assembly with Pre-Created User Schemas