ODI JEE Agent Active-Active Installation

ODI JEE Agent Active-Active Installation
05 Sep 2023

CHAPTERⅠ- ODI Active-Active Structure – ODI HA Installation

We know that the active-active JEE agent has a wide variety of capabilities, so we recommend our customers to switch to a JEE agent instead of a standalone agent. We have even completed the installation and transition from a standalone agent to an active-active Java agent for one of our customers. In this article, we have compiled the ODI active-active agent and how we made this transition.

Oracle Data Integrator (ODI) is a platform that enables organizations to extract, transform, and load (ETL) data across different applications and systems. High availability (HA) capabilities mean ensuring the continuous and reliable operation of the ODI environment, even in the face of hardware or software failures. Below are some of the high availability features offered by Oracle Data Integrator:

Load Balancing: ODI can support load balancing across multiple nodes to evenly distribute workloads and avoid resource bottlenecks. This helps in optimizing performance and ensures that no single node is overloaded. We used load balancer in front of oracle webserver (OHS).

Cluster Support: ODI can be deployed in a clustered environment, where multiple ODI instances work together as a single logical unit. This cluster configuration ensures redundancy and fault tolerance, improving the overall availability of the system. We have installed as cluster structure ODI WebLogic server. 

Replication: ODI HA structure can replicate metadata and configurations across different nodes. This helps maintain data integrity and ensures that all nodes have access to the same information.

Data Source Redundancy: To prevent single points of failure in data sources, ODI can be configured to connect to redundant databases or data warehouses. This ensures continuous data availability even if one of the data sources becomes unavailable.

ODI Java agent HA structure:

pastedGraphic.png

ODI 12c HA Installation

  1. The environment architecture is based on Unix.The server name, port, domain name, user name and password information shown in this document have been created for illustrative purposes. You need to replace your values ​​with your own environment information. 
    • webhost.com – OHS acts as a Load Balancer, so you should replace it with your own Load Balancer/Virtual Host name.
    • host1.com – Oracle Data Integrator 12c with Oracle WebLogic 12c installed, so you should replace it with your own hostname of WLS managed server 1
    • host2.com – Oracle Data Integrator 12c with Oracle WebLogic 12c installed, so you should replace it with your own hostname of WLS managed server 2
    • db.com – Oracle Database with Oracle AS Repository Components have already been created with RCU, this is a non-RAC database
    • DBMS/Service (SID.com)  – Oracle Database instance service name in above Database
  1. However, you may apply the concept from this document to your own requirements using such as:
    • Hardware Load Balancer
    • RAC database or
    • add additional WLS servers (>2)
  1. … and adjust the command to suit the Windows environment.
  2. From this example, you will use a standard ODI Java EE Template, therefore a Java EE Agent Name is “OracleDIAgent”

HOST1 – Create the High Availability Domain

1. You can create your physical and logical Agent from ODI Studio so you can set the Agent Host and Port to your WEBHOST Hostname and Port number. 

pastedGraphic_1.png

2. Launch MW_HOME/oracle_common/common/bin/config.sh, choose “Create a new domain ” with the following components: