Prepare the Installer

- Steps

Checkbox

Extract the contents of the OHF media pack to ODI 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_82_Linux-x64.zip file where you want to launch the installer using the following command:

unzip -a OHF_82_Linux-x64.zip

Checkbox

The following zip is available:

dma_odi_master_install_adw.zip

Checkbox

Copy the dma_odi_master_install_adw.zip file to OHF installation home.

cp dma_odi_master_install_adw.zip <OHF_INSTALL_HOME>/dma_odi_master_install_adw

Checkbox

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

unzip -a dma_odi_master_install_adw.zip

Checkbox

Change the protection on files as follows:

chmod 755 *

Checkbox

Update the following user parameters in the <OHF_INSTALL_HOME>/dma_odi_master_install_adw/ODI_SETENV_CREATE.ksh script.

ORAHOME

Oracle home directory

BASEDIR

Installation home directory

ODIHOME

ODI home directory

ODICREDFILE

ODI ADW wallet credential file location

ODIDBSRVNM

OHF data model ADW service name

HDIUSR

HDI schema name

HDMUSR

HDM schema name

HCDUSR

HCD schema name

CDMUSR

CDM schema name

ENTUSR

ENT schema name

WILHMCUSR

WIL_HMC schema name

ATHMCUSR

AT_HMC schema name

OHFODIREPUSR

ODI repository schema created during ODI marketplace installation

NAMESPACE

OCI Namespace

OCIOBJSTRSHORTURL

OCI Object Storage short URI

OHFBUCKETNAME

OCI Bucket name to upload ODI repository dump

OHFCREDNAME

Unique name for credential to store your Cloud Object Storage credential by using DBMS_CREDENTIAL.CREATE_CREDENTIAL

CREDUSERNAME

Credential user name for object storage access. Refer to:

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbbk/#articletitle

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

Apply the following grants to the ODI repository schema (created during the ODI marketplace installation):

grant execute on DBMS_CLOUD to <OHFODIREPUSR>;
grant read, write on directory data_pump_dir to <OHFODIREPUSR>;

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/122010 
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME

Checkbox

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

sqlplus admin/<admin_pwd>@<ADW-servicename>