1. Installation Guide
  2. Installation
  3. Oracle Healthcare Foundation Installation on ADW (ODI)
  4. Data Management Assembly for OCI Marketplace Oracle Data Integrator Installation
  5. Prerequisites

Prerequisites

- Prerequisites

Checkbox

Install ODI from OCI marketplace by selecting option - Create new ODI Repository in an Autonomous Database (such as OHADW00) and provide schema prefix as OHF. This creates a default empty ODI repository and a default standalone agent.

This is required to install the OHF DMA components. Refer to: https://docs.oracle.com/en/middleware/fusion-middleware/data-integrator/12.2.1.4/dimgs/getting-started-oracle-cloud-marketplace.html#GUID-1793F6A6-8581-465D-BBE3-8F0C8ADD6536

Checkbox

Log in to the ODI marketplace VM instance and Install Oracle instant client (including Basic Package (ZIP), SQL*Plus Package (ZIP), Tools Package (ZIP).

  1. Copy tnsnames.ora and sqlnet.ora from wallet location (for example: /u01/oracle/mwh/wallets/wallet_OHADW00/) to <Oracle Client Home>/network/admin/ location.
  2. Update sqlnet.ora file in the <Oracle Client Home>/network/admin/ with the wallet directory (for example: /u01/oracle/mwh/wallets/wallet_OHADW00).

Note:

If ODI repositories and OHF schemas resides in different autonomous datawarehouse then add OHF ADW wallet file (for e.g. wallet_OHFADW01.zip) to /u01/oracle/mwh/wallets/ location and unzip the wallet to its corresponding folder /wallet_OHFADW01.

Add tns entry of OHF schemas ADW connections in <Oracle Client Home>/network/admin/tnsnames.ora and update the wallet directory in the TNS entry as below.

For example:

ohadw01_low = (description= (retry_count=20)(retry_delay=3)
(address=(protocol=tcps)(port=1522)(host=adb.uk-london-1.oraclecloud.com))
(connect_data=(service_name=xyzxyzxyzhhyhy_ohadw00_low.adb.oraclecloud.com))
(security=(ssl_server_cert_dn="CN=adwc.eucom-central-1.oraclecloud.com,
OU=Oracle BMCS FRANKFURT,O=Oracle Corporation,L=Redwood City,ST=California,C=US")
(MY_WALLET_DIRECTORY=/u01/oracle/mwh/wallets/wallet_OHADW01)))

Checkbox

Log in to the ODI marketplace VM instance as the opc user and install the ksh and oci cli using opc as the root user if these are not already installed. 

yum install ksh
yum install python36-oci-cli (check the latest version)

Checkbox

Log in to the ODI marketplace VM instance as the oracle user and perform oci config by running below command: 

oci setup config

Refer to the following: https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/cliinstall.htm

Parent topic: Data Management Assembly for OCI Marketplace Oracle Data Integrator Installation