Database Monitoring is not supported for this site.
The features described on this page are in beta. Contact your Customer Success Manager to provide feedback or ask for help.
Supported Oracle versions, features, and architectures
- Versions: 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:
- An Agent version that supports Oracle monitoring features must be installed.
- 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
Host requirements
See the DBM Setup Architecture documentation to determine where to install the Agent.
The Agent doesn’t require any external Oracle clients.
Recommended Agent version
Datadog recommends the following Oracle DBM builds, because they contain all of the implemented Oracle monitoring features and bug fixes. The basis of an Oracle DBM build is always a stable Agent release.
- Linux:
7.47.1~dbm~oracle~0.2-1 - Windows:
7.47.1-dbm-oracle-0.2-1 - Docker:
7.47.1-dbm-oracle-0.2
If you prefer an official Datadog Agent release, wait at least until the version 7.49.0.
Oracle DBM build installation
Oracle DBM builds can be downloaded for RHEL and Ubuntu from their respective repositories.
Set DD_API_KEY and run the following commands to install the Oracle DBM release, for example:
export DD_AGENT_DIST_CHANNEL=beta
export DD_AGENT_MINOR_VERSION="47.1~dbm~oracle~0.2-1"
DD_API_KEY= DD_SITE="datadoghq.com" bash -c "$(curl -L https://s3.amazonaws.com/dd-agent/scripts/install_script_agent7.sh)"
Oracle DBM builds can be downloaded from the Windows builds repository.
Download the MSI file for the Oracle DBM build.
Set APIKEY and run the following command in the command prompt inside the directory where you downloaded the installer, for example:
start /wait msiexec /qn /i datadog-agent-7.47.1-dbm-oracle-0.2-1.x86_64.msi APIKEY="" SITE="datadoghq.com"
Oracle DBM images can be found in the Docker builds repository.
Set DD_API_KEY and run the following command to install the Oracle DBM release, for example:
docker run -d --name dd-agent -v /var/run/docker.sock:/var/run/docker.sock:ro -v /proc/:/host/proc/:ro -v /sys/fs/cgroup/:/host/sys/fs/cgroup:ro -e DD_API_KEY="" -e DD_SITE="datadoghq.com" gcr.io/datadoghq/agent:7.47.1-dbm-oracle-0.2
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.
