Setting up Oracle

Database Monitoring is not supported for this site.

Supported Oracle versions, features, and architectures

  • Versions: 11.2, 12c, 18c, 19c, and 21c
  • Deployment configurations: Self-managed, RDS, RAC, Exadata, Autonomous Database
  • Architecture: Multi-tenant, non-CDB, RDS single-tenant

Overview

Prerequisites

To configure Database Monitoring for Oracle, the following prerequisites must be met:

  1. An Agent version that supports Oracle monitoring features must be installed (7.50.1 or greater).
  2. The Oracle integration must be installed.

Setup

If the above prerequisites are met, follow the setup instructions for your hosting type:

Prerequisite details

Install the Agent

See the DBM Setup Architecture documentation to determine where to install the Agent. The Agent doesn’t require any external Oracle clients.

To install the Agent, follow the instructions for your platform.

Upgrade an existing Agent installation

Execute all grant permission commands according to the documentation for your hosting type. New features need access to system views that you did not previously grant to the Datadog database user account.

Install the Oracle integration

On the Integrations page in Datadog, install the Oracle integration for your organization. This installs an Oracle dashboard in your account that can be used to monitor the performance of your Oracle databases.

Verify your existing Oracle integration

You can skip this step if this is your first time installing the Oracle integration.

For an existing installation, verify that your configuration is located in the conf.d/oracle-dbm.d/ directory. You may need to migrate the legacy configuration from the conf.d/oracle.d/ directory.

Use the following command to migrate the Oracle integration from the legacy integration to the new one:

cp /etc/datadog-agent/conf.d/oracle.d/conf.yaml /etc/datadog-agent/conf.d/oracle-dbm.d/conf.yaml

Deactivate the legacy integration:

mv /etc/datadog-agent/conf.d/oracle.d/conf.yaml /etc/datadog-agent/conf.d/oracle.d/conf.yaml.bak

Deactivating the legacy integration prevents sending the system metrics twice.

Since the Agent doesn’t require an external Oracle client, remove the jdbc_driver_path configuration parameter from the new parameter file /etc/datadog-agent/conf.d/oracle-dbm.d/conf.yaml.

If the above prerequisites are met, follow the setup instructions for your hosting type.

Further reading

Additional helpful documentation, links, and articles: