Purpose

This tutorial will show you how to install and configure Oracle Data Integrator (ODI) on your Oracle Java Cloud instance.

Time to Complete

The tutorial will take about fifteen minutes to complete.

Background

You should be familiar with how to install and configure ODI on premises. You can find most of that information on the web in the ODI home page, documentation, and in Oracle Learning Library (OLL) tutorials such as ODI Getting Started.

Scenario

ODI can run on Windows or Linux, can be managed with a web-based Console or standalone Studio GUI, with or without WebLogic Server (WLS). It can use agents deployed in Standalone, Collocated, and Java Enterprise Edition (JEE) mode. This tutorial will assume Linux for both the client workstation and server, managed by the Weblogic Administration Console, with WLS installed as JCS, and the agents deployed in JEE mode.

The topology of the domain you create can vary, depending upon how many virtual machines and how many Managed Servers you provision as part of your Java Cloud Service subscription.

Note — Only the Enterprise Installation is supported on ODI Cloud Service.

Context

This tutorial assumes a single node JCS deployment.

What Do You Need?

You will need to be familiar with the Oracle Java Cloud Service. If you are not then it is strongly recommended that you run through the Getting Started with Oracle Java Cloud Service tutorial before attempting this one.

Make sure you are familiar with the prerequisites required for Oracle Java Cloud Service on OCI.

The instructions in this tutorial assume that you have performed all of these tasks:

1. Ensure that you have subscriptions for Oracle Storage, Oracle Cloud Infrastructure (OCI) Database, Oracle Virtual Cloud Network, and Oracle Java Cloud Service environments.

   For more information, see Signing Up for Oracle Cloud Infrastructure.

2. Create the VM public and private keys.

   The VM public key is used by the new instance's VM for authentication when you connect to it using an SSH client. When you connect, you must provide the private key that matches the public key.

   When creating an OCI Database instance and Java Cloud Service (JCS) instance you need to specify the public key. You generate an SSH public/private key pair using a standard SSH key generation tool. For more information, see Creating SSH Keys for Use with Oracle Cloud Services in the Oracle Learning Library.

3. Configure an OCI Database instance that meets the Java Cloud Service deployment requirements, including adding a specific policy so that the database appears on the Oracle Java Cloud Service web console as an infrastructure schema database choice.

   For instructions, see:

   • Create an Oracle Cloud Infrastructure Database in the Administering Oracle Java Cloud Service guide.
   • Overview of the Database Service in the Oracle Cloud Infrastructure documentation.

Note: When creating the OCI Database instance to use with the Oracle Java Cloud Service, make sure you have created a policy to permit Oracle Platform Services to create instances in your VCN. Keep the policy current. The policy should include:

• Allow service PSM to inspect vcns in compartment
• Allow service PSM to use subnets in compartment
• Allow service PSM to use vnics in compartment
• Allow service PSM to manage security-lists in compartment
• Allow service PSM to manage all-resources in compartment
Set up the credentials to provide access to the object storage bucket, so that you can select Automatic Backup as the backup option for the database.

While performing all of these tasks, be sure to note the user name and passwords you enter; you will need them later while provisioning or performing administration tasks.

If you are doing this just as a proof-of-concept, it is easier to make all of the passwords the same. In a production environment, you should not use shared passwords.

Locating Your Database Details

You will need the Compartment Name, Database Instance Name, PDB Name, and the Administrator user name and password. You will need to have generated a token to use as a password for back up and recovery.

As with all things Linux, directories are case sensitive.

Note: Since Oracle WebLogic Server is already installed in your Java Cloud Service instance, there is no need to install the Fusion Middleware Infrastructure. It is already there. However, once you have unzipped the ODI installer files, you must apply patch 22384876 before installing ODI.

1. From the vncviewer, open a terminal session and navigate to the /tmp directory. Check there are no temporary files present. If there are any, delete them using the rm command, so removing any possiblity of running out of disk space whilst installing ODI.

   Then navigate to the /u01/zips/upperstack directory

   cd /u01/zips/upperstack

   Inside the folder you will find the odi installer archive file. You can check by executing the ls command.

2. Unpack the archive file using the unzipcommand.

   unzip ODI.zip

3. This will unpack two jar files into the current directory. These files make up the ODI installer, from which you can also apply patch 22384876. To run the installer. Use the Java command:

   java -jar fmw_12.2.1.3.0_odi_generic.jar

   to initiate the installation.

4. When prompted, set the Inventory Directory to /u01/app/oraInventory, then click OK to create the Central Inventory Directory.

   

5. When the Welcome screen opens, click Next.

   

6. On the Auto Updates screen, select Search My Oracle Support for Updates.

   Enter your user name and password for My Oracle Support. Click Search.

   Select 22384876 13.9.3 PREFLIGHT ON FMW 12.2.1.3.1. Click Next.

   Click Yes on the popup dialog box Some of the updates require restart of the installer. Do you want to continue?. The installer will restart.

   Click Next.

   

7. For the installation location enter /u01/app/oracle/middleware. Click Next to move to the next step.

   

8. In the Installation Type form, select Enterprise Installation. Click Next.

   Note – The Standalone Installation is not supported in this configuration. Do not select it.

   

9. Click Next on the Prerequisite Check screen

   Note – Depending on the configuration of instance, the ODI installer may display a warning stating that the JDK version is not certified. You can ignore the message.

   

10. On the Installation Summary form, click Install.

    

11. The Installation Progress screen will show the name and status of each component as it copied and configured. When the operation has completed, click Next

    

12. Click Finish on the Installation Complete screen.

    

You have successfully installed Oracle Data Integrator.

1. Open a browser in the JCS instance.
2. Log on to My Oracle Support https://support.oracle.com, and search for patch 26669648. Download it to your instance.
3. Verify your OPatch version. Execute the command:

   cd /u01/app/oracle/middleware/OPatch
   ./opatch version

   The command should not error and must return an OPatch version of 13.3 or later.

4. Verify the OUI Inventory. Execute the command: ./opatch lsinventory -jre $JAVA_HOME/jre. This command should NOT error out.
5. In your Oracle Home, edit file .bashrc and add the following lines at the end:

   export ORACLE_HOME=/u01/app/oracle/middleware
   export PATH=${ORACLE_HOME}/OPatch:${PATH}

6. Navigate to the directory where the patch downloaded, for example: /home/oracle/Downloads.

   Unzip patch 26669648, using the command:

   unzip p26669648_122130_Generic.zip

7. Navigate to the patch directory (for example /u01/app/oracle/tools/home/oracle/Patches/26669648).
8. Run the command:

   opatch apply

   to apply the patch.

• Configuring the Domain for the Java EE Agent, part of Oracle Fusion Middleware Installing and Configuring Oracle Data Integrator documentation.
• Oracle Data Integrator 12c: Getting Started Series on Oracle Learning Library (OLL).
• Oracle WebLogic Server 12c: Administration I, the root of all WLS (and therefore JCS) training. Includes Training on Demand (ToD), Instructor-Led Training (ILT), and Live Virtual Class (LVC) formats.
• Leveraging On-Premises Licenses in the Oracle Public Cloud. This document will tell you which middleware products can be used in conjunction with the Oracle Java Cloud Service.
• Oracle® Fusion Middleware Developer's Guide for the Oracle Data Integrator. This document will tell you how to get started with the Oracle Data Integrator.
• Updating the Java Cloud Service Domain
• Using Oracle Data Integrator to Test Your Domain
• Provisioning Oracle Data Integrator on a Clustered Oracle Java Cloud Service
• Connecting from the Administration server to the Managed server.
• Installing Oracle Data Integrator on the Managed server.