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

Run the Installer

Start the Oracle Universal Installer by running the following command:

  • If the Informatica repository schemas to be created are on the database instance of the installation server, execute:

    sh runInstaller.sh -local

  • If the Informatica 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 Informatica 8.1.0.0.0 option.

Checkbox

Select the Informatica Home Location

Enter or select the installation home path.

Checkbox

Verify Installation Prerequisites

Verify if all the prerequisites are met before proceeding.

Checkbox

Oracle Home Configuration

Specify the Oracle client home path.

Checkbox

Select the Informatica Home Location

Specify the Informatica home location.

The Informatica home should be one level above the /server directory. For example, path/Informatica/961/.

Checkbox

Specify the Information Shared Path location

The Informatica Shared Path should be one level above the SrcFiles folder. For example, path/Informatica/961/server/infa_shared.

Note:

Before installation ensure that all required subfolders are created under infa_shared folder.

For example: SrcFiles, TgtFiles, SessLogs, WorkflowLogs, and so forth.

Checkbox

Select Database Server for Informatica Repository Schemas

Select one of the following options for the Informatica repository schemas:

  • If the Informatica repository database server is on the installation server, select the Installation database server option, and skip the next step.
  • For remote installations, select the Remote database server option, and go to the next step.

Checkbox

Specify Mount Path Details (applicable only for remote installations)

Enter the following mounted directory configuration details in which the remote server directory is mounted:

  • Mount path in the repository database server - Remote server path
  • Mount path in the installation server - Path on the installation server where the mounting is performed

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

  • The (datapump) 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).
  • Make sure that the remote directories are accessible after mounting from the installation server.
  • If the remote server mounted path is displayed as /, provide the absolute mounted path of the remote server.
  • The remote server Linux user that executes the Oracle process must have minimum privileges of 755 to the directory.

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 Informatica repository schema creation.

Checkbox

Specify Informatica 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

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

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

  • Enterprise schema name
  • Enterprise schema password.

Checkbox

Specify Warehouse Integration Loader Details

Enter values for the following fields:

  • Configuration schema name
  • Configuration schema password
  • Repository name
  • Repository schema name
  • Repository schema password

Provide an existing HMC schema.

Provide the new Repository schema name.

Checkbox

Specify Healthcare Common Data Mart Loader Details

Enter values for the following fields:

  • Configuration schema name
  • Configuration schema password
  • Repository name
  • Repository schema name
  • Repository schema password

Specify an existing HMC schema.

Provide the new Repository schema name.

Checkbox

Specify Healthcare Cohort Data Mart Loader Details

If you are upgrading the Informatica repository schemas from Enterprise Healthcare Analytics (EHA) 6.1 and Oracle Healthcare Foundation 7.0.1 to Oracle Healthcare Foundation 8.1, the repository name, tablespace, and temp space name should be the same as in the previous version.

Enter values for the following fields:

  • Repository name
  • Repository schema name
  • Repository schema password

Provide the new Repository schema name.

The configuration schema is not required for CDM.

Checkbox

Specify Tablespace Details (if prompted)

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 Tablespace Details (if prompted)

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

  • Repository schema default tablespace name
  • Repository schema temporary tablespace name

Checkbox

Specify Tablespace Location for Configuration Schema (if prompted)

Specify the tablespace location for the Configuration schema.

The location should be present in the Oracle Healthcare Foundation 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 Schema (if prompted)

Specify the tablespace location for the repository schemas.

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

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

Checkbox

Specify Informatica Domain Details

Specify the following parameters:

  • Domain name
  • Domain code page ID
  • Node name
  • License name
  • Informatica host name
  • Informatica port number
  • Informatica administrator user name
  • Informatica administrator password

Contact your Informatica Administrator for the Domain Code Page ID and provide a valid Code Page ID. Make sure that the code page is compatible with the domain code page for creating the Integration Service. For a domain compatible code page, see any existing and active integration service code pages from the Informatica admin console. A list of sample code pages and their IDs are as follows:

  • US-ASCII (ID 1) - 7-bit ASCII
  • Latin1 (ID 4) - ISO 8859-1 Western European
  • JapanEUC (ID 18) - Japanese Extended Unix Code (including JIS X 0212)
  • UTF-8 (ID 106) - Unicode Transformation Format, multibyte
  • MS932 (ID 2024) - MS Windows Japanese, Shift-JIS
  • MS1252 (ID 2252) - MS Windows Latin1 (ANSI), superset of Latin1

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 Informatica Upgrade