1. Installation Guide
  2. Installation
  3. Oracle Healthcare Foundation Installation on ADW DMA (Informatica)
  4. DMA Repository Installation on Informatica server
  5. Prerequisites

Prerequisites

- Prerequisites

Checkbox

Log in to the Database on the Informatica server.

Checkbox
Create OHF DMA Repository schemas (pre-created) with the ohf_dma_rep_schemas.sql script.

Note:

See the following section for an example of creating users: Create Users in Repository Database.

Checkbox

Log in to the Informatica server and go to <Oracle Client Home>/network/admin path.

  1. Copy content of tnsnames.ora and sqlnet.ora from wallet location (for example: /u01/oracle/mwh/wallets/wallet_OHADW00/) to <Oracle Client Home>/network/admin/ for tnsnames.ora and sqlnet.ora 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)

    For example:

     WALLET_LOCATION = (SOURCE = (METHOD = file) 
(METHOD_DATA = (DIRECTORY=/u01/app/Oracle/product/12.2.0/dbhome_1/network/admin/Wallet_OHADW00)))
 SSL_SERVER_DN_MATCH=yes

Checkbox

Update tnsnames.ora file in the <Oracle Client Home>/network/admin/ by adding the ADW tnsnames.ora file values or content.

Parent topic: DMA Repository Installation on Informatica server