Oracle Database Agent

Overview

An Oracle Database agent encapsulates the connection details to a single Oracle Database instance.

Operational Considerations

An incorrectly configured Oracle Database agent will affect every Operation attached to it. When configuring this agent, it is important to keep in mind:

  • Which tables the user being authenticated with has access to and what tables are available under its schema.
  • Connection timeout limits of the target Oracle Database instance.

Usages

The Oracle Database agent is used by the following Operations:

Configuration

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

Name
Description

Connection String

The ODP.net oracle data connection string used to connect to the target Oracle Database instance.

e.g. Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<SERVER_NAME>)(PORT=<PORT>)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=<SERVICE_NAME>)));User Id=<USERNAME>; Password=<PASSWORD>;

The default port is 1521


Agent Oracle Database

Is this article helpful for you?