1. UNIFYBroker knowledge
  2. Agents
  3. Articles

Oracle Database Agent

Overview

An Oracle database agent encapsulates the connection details to a single oracle database.

Usages

The Oracle Database agent is used by the following connectors:

Pre-requisites

The oracle database agent uses the Oracle.DataAccess.Client provider. This provider will need to be installed on the environment against which the UNIFYBroker service has been installed.

TIP: The latest installer as of writing can be found here.

Configuration

In addition to the common agent configuration shared by all agents, the Oracle Database agent requires the following by way of configuration:

Name Description
Connection String

An Oracle database connection string used to describe the connection mechanism to the oracle database instance. (For more details see Connecting to Oracle Database).

Example without TNS:

Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostName)(PORT=1251)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=serviceName)));

Example using TNS (see tnsnames.ora):

Data Source=dataSource;User Id=aUsername;Password=aPassword;

Example with Easy Connect (must be enabled in sqlnet.ora):

Data Source=username/password@//hostName:1521/serviceName;

Enable Transactions Whether the Microsoft Distributed Transaction Coordinator is used to manage transactions.
Operation Timeout The timeout to use to cancel long-running operations.

Image 4108

Previous article: OLE Database Agent
Next article: SQL Server Database Agent

Is this article helpful for you?

Customer support service by UserEcho