Install and Configure Oracle Data Integrator 12c on Non-GUI Platforms

Purpose

This tutorial covers install and configuration of Oracle Data Integration (ODI) 12.1.3 from command line on platforms where Graphical User Interface (GUI) is not available.

Time to Complete

Approximately 30 minutes.

Introduction

The Oracle Data Integrator (ODI) 12c can be installed interactively through the Oracle Universal Installer (OUI) wizard and then can be configured through configuration wizard. But such wizard-based installation and configuration approach is not applicable on platforms where Graphical User Interface (GUI) is not available. On such platforms it needs to be performed through command line. This tutorial provides step by step instructions and required sample scripts/parameters for such command line based install and configuration.

Hardware and Software Requirements

The following is a list of hardware and software requirements:

• Please check System Requirements and Specifications

Prerequisites

Before starting this tutorial, you should:

• Have required JDK installed.
• Installed and have access to the supported Database where ODI repository will be created.
• Sign on to OTN (Oracle Technical Network) and Accept License Agreement for Software Downloads.
• Have downloaded binaries for Oracle Data Integrator 12.1.3.0.0 and its prerequisite Oracle Fusion Middleware Infrastructure.

Note: Instructions and any text that you need to modify in the template are enclosed in < >.

Before continuing with the install process for the ODI the required prerequisites need to be installed. Please follow the below steps to verify that the prerequisites are available in your environment.

1. Sign on to OTN (Oracle Technical Network) and Accept License Agreement for Software Downloads.
2. Download Oracle Data Integrator 12.1.3.0.0 installer and save it in local directory. Unzip it into the same directory.
3. If you want to install ODI JEE agent or Collocated Agent then you also need to download Oracle Fusion Middleware Infrastructure. You can unzip it into the same directory where ODI installer is extracted in the previous step.
4. Open a command prompt and go to the directory where you unzipped the jars.

5. JDK 1.7 is required for ODI 12.1.3. For exact version information please check system requirement. You can verify the installed java version in your environment by invoking following command.

   
   java -version
   

6. The JEE Agent and Collocated Agent are present in the Enterprise Install type in ODI Installer, which requires to be installed in an $ORACLE_HOME containing FMW Infrastructure 12.1.3. If you do not have an existing FMW Infrastructure available then you can install it in silent mode with following command:

   
   java -jar fmw_12.1.3.0.0_infrastructure.jar -silent -responseFile <full path to response file>
   

   The FMW Infrastructure Installation Response File can be used for specifying above configuration properties. Please update the property values according to your environment.

   Note: The above response file can also be generated through the Installer wizard on a platform where GUI is available. To generate it run the installer command without the -silent flag and click Save Response File button on the Installation Summary page.

   

To install ODI, perform the following steps:

1. On the command prompt go to the directory where you had unzipped Oracle Data Integrator 12.1.3.0.0 installer.

2. Invoke ODI installer in silent mode by invoking following command. Depending upon your desired installation type the response file would have different properties as described in subsequent steps.

   
   java -jar fmw_12.1.3.0.0_odi.jar -silent -responseFile <full path to response file>
   

3. If you want to install JEE Agent or Collocated Agent then Enterprise Installation Response File can be used for specifying configuration properties. Please update the properties according to your environment.

   • The $ORACLE_HOME should point to the same location where you have installed the FMW Infrastructure in Topic #1.
   • The response file can also be generated through Installer wizard on a platform where GUI is available. To generate it run the installer command without the -silent flag and click Save Response File button on the Installation Summary page.
   

4. If you want to want to install Standalone Agent then Standalone Installation Response File can be used for specifying configuration properties. Please update the properties according to your environment.

   Note: The response file can also be generated through Installer wizard on a platform where GUI is available. To generate it run the installer command without the -silent flag and click Save Response File button on the Installation Summary page.

   

ODI Agent connects to the ODI repository for its operations. So before configuring ODI Agent the repository must be created in the identified database to host the ODI and other required components schemas. Repository Creation Utility (RCU) is installed in either install type to create the required schemas and populating the seed data in them.

1. On the command prompt go to <$ORACLE_HOME>/oracle_common/bin and depending upon your installation type follow either step #2 or #3 below.

2. If you have installed Standalone Install Type then invoke rcu command with following parameters. RCU will interactively prompt for passwords and other component specific parameters on the command line (all on one line with no line breaks).

   
   ./rcu -silent -dropRepository -connectString <HOST_NAME:PORT:SERVICE_NAME> -dbUser <SYS USER> 
     -dbRole <sysdba> -useSamePasswordForAllSchemaUsers true -schemaPrefix <DEV> -component ODI
   

   You will be prompted to enter parameters as shown in the following screen shot.

   
   [user@myhost bin]$ ./rcu -silent -createRepository -connectionString myhost:1524:orcl2.us.oracle.com -dbUser sys 
     -dbRole sysdba -useSamePasswordForAllSchemaUsers true -schemaPrefix DEV10 -component ODI
   Please enter the database password(user:sys):
   
   Processing command line ....
   Repository Creation Utility - Checking Prerequisites
   Checking Global Prerequisites
   Please enter the schema password. This password will be used for all schema users of the following components:ODI,STB.
   *******
   
   Please enter the value of Custom Variable [Supervisor password] for Component ODI [Min Length:6, Max Length:12]
   *******
   
   Please enter the value of Custom Variable [Work Repository Type: (D) Development (Default) or (E) Execution] for
    Component ODI [Min Length:0, Max Length:1]
   D
   
   Please enter the value of Custom Variable [Work Repository Name (WORKREP)] for Component ODI [Min Length:0, Max
    Length:128]
   WORKREP
   
   Please enter the value of Custom Variable [Work Repository Password] for Component ODI [Min Length:0, Max
    Length:10]
   *******
   
   Please enter the value of Custom Variable [Encryption Algorithm: AES-128 (Default) or AES-256] for Component
    ODI [Min Length:0, Max Length:7]
   AES-128
   
   Repository Creation Utility - Checking Prerequisites
   Checking Component Prerequisites
   Repository Creation Utility - Creating Tablespaces
   Validating and Creating Tablespaces
   Repository Creation Utility - Create
   Repository Create in progress.
   Percent Complete: 40
   Percent Complete: 40
   Percent Complete: 44
   Percent Complete: 44
   

   Note: If you want to avoid passing the passwords and components specific parameters you can create a text file with each value on a separate line in the same order it is asked in interactive mode. A sample rcuparam.txt would have following values:

   
   <SYS PASSWORD>
   <SCHEMA PASSWORDS>
   <ODI PASSWORD>
   <REPOSITORY TYPE>
   <WORK REPOSITORY NAME>
   <WORK REPOSITORY pASSWORD>
   <ENCRYPTION TYPE>
   

   Parameters from such rcuparam.txt file can be passed to RCU as follows (all on one line with no line breaks):

   
   ./rcu -silent -dropRepository -connectString <HOST_NAME:PORT:SERVICE_NAME> -dbUser <SYS USER> -dbRole <sysdba> 
     -useSamePasswordForAllSchemaUsers true -schemaPrefix <DEV> -component ODI < rcuparam.txt
   

3. If you have installed Enterprise Install Type then invoke rcu command with following parameters. RCU will interactively prompt for passwords and other component specific parameters on the command line (all on one line with no line breaks).

   
   ./rcu -silent -dropRepository -connectString <HOST_NAME:PORT:SERVICE_NAME> -dbUser <SYS USER> 
     -dbRole <sysdba> -useSamePasswordForAllSchemaUsers true -schemaPrefix <DEV> -component ODI -component IAU
     -component IAU_APPEND -component IAU_VIEWER -component OPSS
   

   You will be prompted to enter parameters as shown in the following screen shot.

   
   [user@myhost bin]$ ./rcu -silent -createRepository -connectionString myhost:1524:orcl2.us.oracle.com -dbUser sys 
     -dbRole sysdba -useSamePasswordForAllSchemaUsers true -schemaPrefix DEV10 -component ODI -component IAU 
     -component IAU_APPEND -component IAU_VIEWER -component OPSS
   Please enter the database password(user:sys):
   
   Processing command line ....
   Repository Creation Utility - Checking Prerequisites
   Checking Global Prerequisites
   Please enter the schema password. This password will be used for all schema users of the following components:ODI,STB.
   *******
   
   Please enter the value of Custom Variable [Supervisor password] for Component ODI [Min Length:6, Max Length:12]
   *******
   
   Please enter the value of Custom Variable [Work Repository Type: (D) Development (Default) or (E) Execution] for
    Component ODI [Min Length:0, Max Length:1]
   D
   
   Please enter the value of Custom Variable [Work Repository Name (WORKREP)] for Component ODI [Min Length:0, Max
    Length:128]
   WORKREP
   
   Please enter the value of Custom Variable [Work Repository Password] for Component ODI [Min Length:0, Max
    Length:10]
   *******
   
   Please enter the value of Custom Variable [Encryption Algorithm: AES-128 (Default) or AES-256] for Component
    ODI [Min Length:0, Max Length:7]
   AES-128
   
   Repository Creation Utility - Checking Prerequisites
   Checking Component Prerequisites
   Repository Creation Utility - Creating Tablespaces
   Validating and Creating Tablespaces
   Repository Creation Utility - Create
   Repository Create in progress.
   Percent Complete: 22
   Percent Complete: 33
   Percent Complete: 44
   Percent Complete: 45
   

   Note: If you want to avoid passing the passwords and components specific parameters you can create a text file with each value on a separate line in the same order it is asked in interactive mode. A sample rcuparam.txt would have following values:

   
   <SYS PASSWORD>
   <SCHEMA PASSWORDS>
   <ODI PASSWORD>
   <REPOSITORY TYPE>
   <WORK REPOSITORY NAME>
   <WORK REPOSITORY pASSWORD>
   <ENCRYPTION TYPE>
   

   Parameters from such rcuparam.txt file can be passed to RCU as follows (all on one line with no line breaks):

   
   ./rcu -silent -dropRepository -connectString <HOST_NAME:PORT:SERVICE_NAME> -dbUser <SYS USER> -dbRole <sysdba> 
     -useSamePasswordForAllSchemaUsers true -schemaPrefix <DEV> -component ODI -component IAU  -component IAU_APPEND
     -component IAU_VIEWER -component OPSS < rcuparam.txt
   

ODI agent can be configured and deployed in the WebLogic domain through the wlst scripts. Depending upon the ODI agent type please follow appropriate steps to create a new domain with it in silent mode.

1. Copy appropriate script from the below list into your <$ORACLE_HOME>/oracle_common/common/bin and update the values marked with <...> according to your environment configuration.

   1. To configure Standalone Agent in Standalone Install Type, copy createOdiDomainForStandaloneAgent.
   2. To configure JEE Agent in your Enterprise Install Type, copy createOdiDomainForJeeAgent.
   3. To configure Collocated Standalone Agent your Enterprise Install Type, copy createOdiDomainForColocatedAgent.

2. Run the script with following command: ./wlst.sh <script file>

   You should see output similar to the following:

   
   Welcome to WebLogic Server Administration Scripting Shell
   
   Type help() for help on available commands
   
   drw-   odi_standalone_domain
   drw-   OracleSystemUser
   Setting JDBCSystemResource with name LocalSvcTblDataSource
   Configuring instance.properties
   ************************************************************************************
   Done creating Standalone domain, Master Repository, Supervisor user and Nodemanager
   ************************************************************************************
   
   Exiting WebLogic Scripting Tool.
   

Silent install and configuration for ODI 12.1.3 release is described in this tutorial. Such install and configuration is useful for setting up ODI domains on platforms where GUI is not available or to automate the installation process.

In this tutorial, you learned to:

• Install ODI in silent mode from command line
• Create ODI repository schemas through RCU in silent mode
• Configure ODI agent in silent mode through wlst scripts

Resources

The following are conceptual or procedural Help topics relevant to the topic of this tutorial:

• Online documentation, viewlets, samples, and OLN URLs on OTN:
• Current version: here
• Older versions: here
• The following specific courses:
• D82167GC10 Oracle Data Integrator 12c: Integration and Administration
  (replaces D64974GC20 Oracle Data Integrator 11g: Integration and Administration Ed2)
• D82171GC10 Oracle Data Integrator 12c: New Features
• External Web sites for related information:
• www.oracle.com/goto/odi
• OTN Community Forums
• To learn more about Oracle Data Integrator 12c, refer to additional OBEs in the Oracle Learning Library, or on the ODI Studio Start Page.

Credits

• Lead Curriculum Developer: Ayush Ganeriwal
• Other Contributors: Steve Friedberg