1. Installation Guide
  2. Upgrade
  3. Data Management Assembly for Oracle Data Integrator Upgrade
  4. Run the Installer

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

  • 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

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.1.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:Remove server path
total size used up space Available space use% Path in installation server where mounting was done

For example:

abc:/scratch/dump
191G 138G 44G 76% / installation server

Note: 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
  • System user password
  • 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
  • System user password

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 following fields:

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

Specify the new schema names for the Master and Work repositories. The installer creates the Master and Work repository schemas, and imports loaders into them.

Checkbox

Specify Warehouse Integration Loader Details

Enter values for the following fields:

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

Enter the existing Configuration schema name to upgrade it.

Specify the new schema names for the Master and Work repositories. The installer creates the Master and Work repository schemas, and imports loaders into them.

Checkbox

Specify Healthcare Common Data Mart Loader Details

Enter values for the following fields:

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

Enter the existing Configuration schema name to upgrade it.

Specify the new schema names for the Master and Work repositories. The installer creates the Master and Work repository schemas, and imports loaders into them.

Checkbox

Specify Healthcare Cohort Data Mart Loader Details

Enter values for the following fields:

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

Specify the new schema names for the Master and Work repositories. The installer creates the Master and Work repository schemas, and imports loaders into them.

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 RCU schemas created using the Oracle Data Integrator Repository.

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 the Tablespace Details

Specify the tablespace names for the configuration schemas. The installer creates these tablespaces if they do not exist.

  • Configuration schema default tablespace name
  • Configuration schema temporary tablespace name

Checkbox

Specify the Tablespace Details

Specify the tablespace names for the repository schemas:

  • wil_odi_ts - Default tablespace for Oracle Data Integrator temporary objects for Warehouse Integration Loaders
  • hcd_odi_ts - Default tablespace for Oracle Data Integrator temporary objects for Healthcare Common Data mart Loaders
  • cdm_odi_ts - Default tablespace for Oracle Data Integrator temporary objects for Cohort Data mart Loaders
  • tl_odi_ts - Default tablespace for Oracle Data Integrator temporary objects for Terminology Loaders

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

Specify Tablespace Location for Configuration Schemas

Specify the tablespace location for the configuration schemas.

The location should be present in the data model database server with write privileges.

If the Oracle Healthcare Foundation data model database is not on the installation server, you must enter the location manually.

Checkbox

Specify Tablespace Location for Repository Schemas

Specify the tablespace location for the Oracle Data Integrator repository schema.

The location should be present in the repository database server with write privileges.

If the repository database is not on the installation server, you must enter the location manually.

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: Data Management Assembly for Oracle Data Integrator Upgrade