Connection to Oracle Databases

The SQL database agent can connect either to an Oracle Database instance or to Oracle RAC nodes.

This page includes the following:

Single Instance Oracle Connections

This is the standard default connection method and when set the database can only connect to an Oracle Database instance. The Job object contains the relevant connection data.

Ensure that the Agent SQL INI file parameter is set to the following: useOraClient=0 in the SQL section.

Oracle RAC Connections

The database agent can connect itself to Oracle RAC nodes. The Oracle file tnsnames.ora contains the relevant connection data. It is not necessary to fill in the field Server in the Job object's SQL tab.

Note: The agent's connection information itself has to be defined by using Connection objects (for example: in SQL variables). In the Connection object you would use Oracle or Oracle OCI as connection type.

The following steps are required in addition to installing the SQL agent:

  1. Ensure that the Agent SQL INI file parameter is set to the following: useOraClient=1 in the SQL section.
  2. Install the Oracle Instant Client

    3. Note: The Oracle Full Client is only needed on Windows machines because of the missing XML functionality within the Oracle Instant Client package for Windows.