Summary
This article discusses the required configuration for using the adTempus Database Operation Task with an Oracle database server.
Note
This configuration process is only required for adTempus 4.x. Beginning with adTempus 5.0, no special configuration is required.
Required Components
To use the Database Operation Task with an Oracle database server, the Oracle client components and the Oracle OleDb provider (OraOLEDB.Oracle) must be installed on the adTempus server. If you are using Distributed Scheduling, these components must be installed on any computers (Master and/or Agents) where the jobs may be run.
The components are not required on computers that only run the adTempus Console.
The components you install should match the version of the Oracle server that you are connecting to. You should use the 64-bit version of the components on 64-bit computers.
Component Installation
The required components can be obtained from Oracle.
Oracle Client
To obtain the Oracle client, search the Oracle Web site for the "Oracle Windows client installer" for the appropriate version of Oracle.
The adTempus Database Operation Task can work with or without a tnsnames file.
OleDB Provider
The Oracle OleDB provider is distributed as part of the Oracle Data Access Components:
- Oracle Data Access Components (32-bit) download page
- Oracle Data Access Components (64-bit) download page
Install the correct version based on the version of the Oracle server you are connecting to. You need to download the full installer, not the "managed" or "xcopy" installers.
No additional configuration of the OleDB provider is required after installation.
Additional Assistance
For assistance with installing or configuring the Oracle client, contact your Oracle database administrator or refer to the support resources available from the Oracle Web site.
Related Errors
If the required components are not installed, Database Operation Tasks that target Oracle will fail with the following error:
