OIC/Integration/11 → Configuring Agent in OIC to connect on premise Oracle Database

integratio
3 min readAug 28, 2023

--

This is a post on Oracle Integration Cloud highlighting how to configure Agent to connect to On-Premise Oracle Database

Integration

(1) Activities:

i. Create an Agent Group in the OIC Console

ii. Download the Connectivity Agent zip file from the OIC Console

iii. Unzip the contents of the zip file, on the on-premises agent machine

iv. Update the “InstallerProfile.cfg” with the details of the OIC environment and on-premises network.

v. Run the agent using : java -jar connectivityagent.jar, on the on-premises agent machine.

(2) Steps:

i. Create an Agent Group in the OIC Console:

ii. Download the Connectivity Agent zip file from the OIC Console:

Download zip file : oic_conn_agent_installer.zip

iii. Unzip the contents of the zip file, on the on-premises agent machine:

Unzip and edit : “InstallerProfile.cfg”

iv. Update the “InstallerProfile.cfg” with the details of the OIC environment and on-premises network:

v. Run the agent using : java -jar connectivityagent.jar, on the on-premises agent machine:

After Agent is started, a new file “pid file” gets generated “inside oic_conn_agent_installer” folder , from where the jar was run. This file contains the process id number (eg. 12980)

When investigating from Task Manager in windows we found below running :

One can cross check Agent status in OIC instance by navigating to Monitoring tab and then click to Agents.

  • Points to remember for Agent Group:

i. Only one connectivity agent can be associated with an agent group.

ii. For a single Oracle Integration instance, you can create up to five agent group.

  • To Restart the Agent:

Restart the on-premises connectivity agent if required by running the command:

java –jar connectivityagent.jar

  • Stop the agent in either of the following ways:

a. Enter ctrl+c on the host on which the agent is running.

b. Search for the connectivity agent process and kill it.

Note : When you shut down the agent server, several minutes pass before the agent is displayed as down on the Agent Monitoring page (as indicated by a red thunderbolt)

………………………………………………………………………………………………

--

--

integratio

📌 IT Backend enthusiast 📌 Blogging about Oracle FMW, Python, Cloud related technologies 📌 Non monetized, non hustle 📌 Knowledge sharing sole purpose