---
title: Install & configure NRDOT Collector for ADB monitoring
source: https://docs.newrelic.com/docs/opentelemetry/database/oracle/adb
---

> #### 💡 PREVIEW
>
> We're still working on this feature, but we'd love for you to try it out!
>
> This feature is currently provided as part of a preview pursuant to our [pre-release policies](https://docs.newrelic.com/docs/licenses/license-information/referenced-policies/new-relic-pre-release-policy/).

Get comprehensive insights into your Oracle Autonomous Database (ADB) performance with database monitoring, query analysis, and system health metrics using the New Relic Distribution of OpenTelemetry (NRDOT) collector.

> #### 💡 GUIDED INSTALLATION
>
> To install through the New Relic UI instead, go to  **[one.newrelic.com](https://one.newrelic.com) > Integrations & Agents > Oracle (OpenTelemetry)** . This page covers the CLI install path only.

## Prerequisites [#prerequisites]

Before you begin, ensure you have the following:

-   Valid New Relic [license key](https://docs.newrelic.com/docs/apis/intro-apis/new-relic-api-keys/#ingest-license-key)
-   Supported architecture: Linux with AMD64 and ARM64
-   Network connectivity to [New Relic OTLP endpoint](https://docs.newrelic.com/docs/opentelemetry/best-practices/opentelemetry-otlp)
-   Oracle Database `19c` or later

### Enroll to preview [#enroll]

This integration is available as part of the New Relic public preview program. Contact your Organization Manager to opt in from the [Previews & Trials](https://one.newrelic.com/admin-portal/promotion-management/home) page.

## Install NRDOT Collector [#installation]

Select the appropriate installation distribution method for your Linux environment:

**For AMD64 architecture**

-   For Debian/Ubuntu system, run:

    ```bash
    NRDOT_VERSION=$(curl -s https://api.github.com/repos/newrelic/nrdot-collector-releases/releases/latest | grep '"tag_name":' | awk -F'"' '{print $4}') && curl -L "https://github.com/newrelic/nrdot-collector-releases/releases/download/${NRDOT_VERSION}/nrdot-collector_${NRDOT_VERSION}_linux_amd64.deb" --output nrdot-collector.deb && sudo dpkg -i nrdot-collector.deb
    ```
-   For RHEL/CentOS/OEL system, run:

    ```bash
    NRDOT_VERSION=$(curl -s https://api.github.com/repos/newrelic/nrdot-collector-releases/releases/latest | grep '"tag_name":' | awk -F'"' '{print $4}') && curl -L "https://github.com/newrelic/nrdot-collector-releases/releases/download/${NRDOT_VERSION}/nrdot-collector_${NRDOT_VERSION}_linux_x86_64.rpm" --output nrdot-collector.rpm && sudo rpm -ivh nrdot-collector.rpm
    ```

**For ARM64 architecture**

-   For Debian/Ubuntu system, run:

    ```bash
    NRDOT_VERSION=$(curl -s https://api.github.com/repos/newrelic/nrdot-collector-releases/releases/latest | grep '"tag_name":' | awk -F'"' '{print $4}') && curl -L "https://github.com/newrelic/nrdot-collector-releases/releases/download/${NRDOT_VERSION}/nrdot-collector_${NRDOT_VERSION}_linux_arm64.deb" --output nrdot-collector.deb && sudo dpkg -i nrdot-collector.deb
    ```

-   For RHEL/CentOS/OEL system, run:

    ```bash
    NRDOT_VERSION=$(curl -s https://api.github.com/repos/newrelic/nrdot-collector-releases/releases/latest | grep '"tag_name":' | awk -F'"' '{print $4}') && curl -L "https://github.com/newrelic/nrdot-collector-releases/releases/download/${NRDOT_VERSION}/nrdot-collector_${NRDOT_VERSION}_linux_aarch64.rpm" --output nrdot-collector.rpm && sudo rpm -ivh nrdot-collector.rpm
    ```

## Configure database user [#database-user]

Create a monitoring user with the necessary privileges for your ADB Oracle Database instance.
Run the following statements as SYS inside your target ADB to create a local monitoring user:

```sql
CREATE USER <USER_NAME> IDENTIFIED BY "<YOUR_PASSWORD>";
GRANT CREATE SESSION TO <USER_NAME>;
```

## Grant monitoring privileges for Autonomous Database [#grant-privileges]

Run these commands as an admin inside your ADB. This gives the monitoring tool the basic access it needs to collect metrics, track events, and find your database instances.

```sql
GRANT SELECT ON SYS.V_$INSTANCE   TO <USER_NAME>;
GRANT SELECT ON SYS.V_$DATABASE   TO <USER_NAME>;
GRANT SELECT ON SYS.V_$CONTAINERS TO <USER_NAME>;
GRANT SELECT ON SYS.V_$DATAFILE   TO <USER_NAME>;
GRANT SELECT ON SYS.V_$PDBS       TO <USER_NAME>; 
GRANT SELECT ON SYS.V_$SYSSTAT                    TO <USER_NAME>;
GRANT SELECT ON SYS.V_$SYSMETRIC                  TO <USER_NAME>;
GRANT SELECT ON SYS.V_$SESSION                    TO <USER_NAME>;
GRANT SELECT ON SYS.V_$RESOURCE_LIMIT             TO <USER_NAME>;
GRANT SELECT ON SYS.V_$OSSTAT                     TO <USER_NAME>;
GRANT SELECT ON SYS.V_$SGAINFO                    TO <USER_NAME>;
GRANT SELECT ON SYS.V_$ROWCACHE                   TO <USER_NAME>;
GRANT SELECT ON SYS.V_$PARAMETER                  TO <USER_NAME>;
GRANT SELECT ON SYS.DBA_TABLESPACE_USAGE_METRICS  TO <USER_NAME>;
GRANT SELECT ON SYS.DBA_TABLESPACES               TO <USER_NAME>;
GRANT SELECT ON SYS.DBA_DATA_FILES                TO <USER_NAME>;
GRANT SELECT ON SYS.DBA_FREE_SPACE                TO <USER_NAME>;
GRANT SELECT ON SYS.DBA_RECYCLEBIN                TO <USER_NAME>;
GRANT SELECT ON SYS.V_$SQL            TO <USER_NAME>;
GRANT SELECT ON SYS.V_$SQL_PLAN_STATISTICS_ALL       TO <USER_NAME>;
GRANT SELECT ON SYS.V_$LOCK           TO <USER_NAME>;
GRANT SELECT ON SYS.V_$SESSION_EVENT  TO <USER_NAME>;
GRANT SELECT ON SYS.DBA_PROCEDURES    TO <USER_NAME>;
GRANT SELECT ON SYS.DBA_OBJECTS       TO <USER_NAME>;
```

## Configure NRDOT Collector [#configure-collector]

Configure the NRDOT Collector with your ADB-specific settings. Create a configuration file (e.g., `adb-config.yaml`) with the following content:

**ADB Unsupported Metrics**

The following metrics are **not supported in ADB**:

-   `oracledb.database.cpu.utilization`
-   `oracledb.database.wait.utilization`
-   `oracledb.host.cpu.utilization`
-   `oracledb.execution.utilization`
-   `oracledb.parse.rate`
-   `oracledb.parse.utilization`
-   `oracledb.sort.ratio`
-   `oracledb.sql_service.response.duration`
-   `oracledb.buffer_cache.utilization`
-   `oracledb.library_cache.utilization`
-   `oracledb.shared_pool.utilization`
-   `oracledb.redo_allocation.utilization`
-   `oracledb.processes.limit`
-   `oracledb.processes.usage`
-   `oracledb.sessions.limit`
-   `oracledb.transactions.limit`
-   `oracledb.transactions.usage`
-   `oracledb.dml_locks.limit`
-   `oracledb.dml_locks.usage`
-   `oracledb.enqueue_locks.limit`
-   `oracledb.enqueue_locks.usage`
-   `oracledb.enqueue_resources.limit`
-   `oracledb.enqueue_resources.usage`

> #### 💡 TIP
>
> You can also:
>
> -   [Configure multiple receivers](https://docs.newrelic.com/docs/opentelemetry/database/oracle/multi-receiver): To monitor multiple Oracle Database instances from one collector.
> -   [Configure SQL Query Receiver](https://docs.newrelic.com/docs/opentelemetry/database/capabilities/sql-query-receiver/): To collect custom metrics from your Oracle Database.
> -   [Link your Oracle Database with APM](https://docs.newrelic.com/docs/opentelemetry/database/capabilities/db-apm): To correlate your application performance with database operations. This allows you to see exactly which applications are generating specific database workloads.
> -   [Set up secret management](https://docs.newrelic.com/docs/opentelemetry/database/capabilities/db-apm/#secret-management): To securely manage sensitive information, such as database credentials. This helps to enhance the security of your monitoring setup by avoiding hardcoding sensitive data in configuration files.

## Restart NRDOT Collector [#restart-collector]

After configuring the collector, restart the NRDOT Collector service to apply the changes:

```bash
sudo systemctl restart nrdot-collector
```

To verify that the collector is running properly, check the service status:

```bash
sudo systemctl status nrdot-collector
```

> #### 💡 TIP
>
> Always restart the NRDOT Collector after making configuration changes to ensure the new settings take effect.

## Find and use your data [#find-use-data]

After you set up the Oracle ADB integration, you can start monitoring and analyzing your database performance in New Relic:

1.  Go to **[one.newrelic.com](https://one.newrelic.com) > All Entities**.
2.  Filter by **Oracle** to find your database entities.
3.  Select your Oracle ADB entity to view dashboards, metrics, and logs.

For more information about monitoring Oracle databases, refer to our [database monitoring documentation](https://docs.newrelic.com/docs/database-monitoring/oracle-monitoring/).

## Related articles [#related-articles]

[Troubleshooting](https://docs.newrelic.com/docs/opentelemetry/database/oracle/troubleshooting)

Learn how to troubleshoot your Oracle ADB monitoring setup in New Relic.

[Metrics reference](https://docs.newrelic.com/docs/opentelemetry/database/oracle/metrics-reference)

Learn about the available metrics collected by the NRDOT Collector.

[RDS instrumentation](https://docs.newrelic.com/docs/opentelemetry/database/oracle/rds)

Learn how to set up your Oracle Database for RDS monitoring in New Relic.