Prepare the Installer for OHF INFA Repository Install

- Steps

Checkbox

Extract the contents of the OHF media pack to INFORMATICA VM instance.

Checkbox

Make a new directory for the OHF installation home: <OHF_INSTALL_HOME>.

Checkbox

Copy the OHF media pack to <OHF_INSTALL_HOME>/.

Checkbox

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

unzip -a OHF_822_Linux-x64.zip
Checkbox

Open the Disk1\stage\Components\oracle.hsgbu.hc.dma.infa\8.2.2.0.0\1\DataFiles\Expanded\filegroup1 folder.

Checkbox

The following zip is available:

dma_infa_master_install.zip

Checkbox

Copy the dma_infa_master_install.zip file to OHF installation home.

cp dma_infa_master_install.zip <OHF_INSTALL_HOME>/dma_infa_master_install

Checkbox

Unzip dma_infa_master_install.zip in the <OHF_INSTALL_HOME>/dma_infa_master_install folder:

unzip -a dma_infa_master_install.zip

Checkbox

Change the protection on files as follows:

chmod 755 *

Checkbox

Update the following user parameters in the <OHF_INSTALL_HOME>/dma_infa_master_install/dmascripts /ADW_REP_INFA_SETENV_CREATE.ksh script.

Table 10-2 Parameters

Parameter Description
HDWFCRDFILE OHF ADW wallet credential file location. The same as OHFCRDFILE given in Prepare the Installer for OHF DMA Install.
HDWFDBASID OHF data model ADW service name. The same as OHFDBSRVNM given in Prepare the Installer for OHF DMA Install.
HDIUSR HDI schema name
HDMUSR HDM schema name
WILHMCUSR WIL_HMC schema name
ATHMCUSR AT_HMC schema name
HCDUSR HCD schema name
ORAHOME Oracle home directory on Informatica server
BASEDIR Installation home directory
INFAHOME Informatica home directory
DOMAINNAME Informatica server Domain name
NODENAME Informatica server Node name
DOMAINCDPGE Informatica server Domain code page id ex.106
INFALISCENSE Informatica License
INFAHOSTSVR Informatica HOST server name
INFAPORTNO Informatica server port number
INFAADMINUSER Informatica Administration user name
INFAREPDBSID Informatica Repository (database) connection string host:port/servicename Example:

‘locathost.oraclevcn.com:1521/orclpdb’

WILREPNAME Informatica WIL repository name
ATREPNAME Informatica AT or HCD repository name
WILINTSRVC Informatica WIL repository Integration service name
ATINTSRVC Informatica AT or HCD repository Integration service name
WILINFAREPDBUSER WIL repository data base schema username
ATINFAREPDBUSER AT or HCD repository data base schema username
WILINFATBSP WIL repository data base schema user table space name
ATINFATBSP AT or HCD repository data base schema user table space name
CDMINFATBSP CDM repository data base schema user table space name
WILINFATMPTBSP WIL repository data base schema user temporary table space name
ATINFATMPTBSP AT or HCD repository data base schema user temporary table space name
CDMINFATMPTBSP CDM repository data base schema user temporary table space name
CDMUSR CDM schema user name
CDMINFAREPDBUSER CDM repository data base schema username
CDMREPNAME Informatica CDM repository name
CDMINTSRVC Informatica CDM repository Integration service name
HLISRCFILDIR HLI source files path or TL_SRC_FILES path
REP_SCHEMA_TBSP_LOC Repository schema user table space path on Informatica server
LOGFILNAM Log file name
ENTUSR ENT / enterprise schema user name
INFA_SHARED_NEW_PATH Path for Informatica share folder path ex. INFA_SHARED folder path

The remainder of the parameters have fixed values and Oracle recommends that you do not change these values. Schema passwords are prompted while running the script.

Checkbox

Before running the installer, make sure that the ORACLE_HOME, PATH and LD_LIBRARY_PATH environment variables are setup in your session. For example:

export ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1 
export LD_LIBRARY_PATH=$ORACLE_HOME/lib  
export PATH=$PATH:$ORACLE_HOME/bin

Checkbox

Verify the database connectivity through adw service names, such as:

sqlplus system/<system_pwd>@<Infa_server_DB-servicename>