---
title: Install & configure NRDOT for Oracle monitoring with Autonomous Database
source: https://docs.newrelic.com/docs/opentelemetry/db360/oracle/adb
---

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 manual installation only.

## Prerequisites [#prerequisites]

Before you begin, ensure you have the following:

-   A 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

## 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 <YOUR_DB_USERNAME> IDENTIFIED BY "<YOUR_DB_PASSWORD>";
GRANT CREATE SESSION TO <YOUR_DB_USERNAME>;
```

## 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 <YOUR_DB_USERNAME>;
GRANT SELECT ON SYS.V_$DATABASE   TO <YOUR_DB_USERNAME>;
GRANT SELECT ON SYS.V_$CONTAINERS TO <YOUR_DB_USERNAME>;
GRANT SELECT ON SYS.V_$DATAFILE   TO <YOUR_DB_USERNAME>;
GRANT SELECT ON SYS.V_$PDBS       TO <YOUR_DB_USERNAME>; 
GRANT SELECT ON SYS.V_$SYSSTAT                    TO <YOUR_DB_USERNAME>;
GRANT SELECT ON SYS.V_$SYSMETRIC                  TO <YOUR_DB_USERNAME>;
GRANT SELECT ON SYS.V_$SESSION                    TO <YOUR_DB_USERNAME>;
GRANT SELECT ON SYS.V_$RESOURCE_LIMIT             TO <YOUR_DB_USERNAME>;
GRANT SELECT ON SYS.V_$OSSTAT                     TO <YOUR_DB_USERNAME>;
GRANT SELECT ON SYS.V_$SGAINFO                    TO <YOUR_DB_USERNAME>;
GRANT SELECT ON SYS.V_$ROWCACHE                   TO <YOUR_DB_USERNAME>;
GRANT SELECT ON SYS.V_$PARAMETER                  TO <YOUR_DB_USERNAME>;
GRANT SELECT ON SYS.DBA_TABLESPACE_USAGE_METRICS  TO <YOUR_DB_USERNAME>;
GRANT SELECT ON SYS.DBA_TABLESPACES               TO <YOUR_DB_USERNAME>;
GRANT SELECT ON SYS.DBA_DATA_FILES                TO <YOUR_DB_USERNAME>;
GRANT SELECT ON SYS.DBA_FREE_SPACE                TO <YOUR_DB_USERNAME>;
GRANT SELECT ON SYS.DBA_RECYCLEBIN                TO <YOUR_DB_USERNAME>;
GRANT SELECT ON SYS.V_$SQL            TO <YOUR_DB_USERNAME>;
GRANT SELECT ON SYS.V_$SQL_PLAN_STATISTICS_ALL       TO <YOUR_DB_USERNAME>;
GRANT SELECT ON SYS.V_$LOCK           TO <YOUR_DB_USERNAME>;
GRANT SELECT ON SYS.V_$SESSION_EVENT  TO <YOUR_DB_USERNAME>;
GRANT SELECT ON SYS.DBA_PROCEDURES    TO <YOUR_DB_USERNAME>;
GRANT SELECT ON SYS.DBA_OBJECTS       TO <YOUR_DB_USERNAME>;
GRANT SELECT ON SYS.V_$PROCESS        TO <YOUR_DB_USERNAME>;
GRANT SELECT ON SYS.V_$TRANSACTION    TO <YOUR_DB_USERNAME>;
GRANT SELECT ON SYS.CDB_SERVICES      TO <YOUR_DB_USERNAME>;
```

## 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:

> #### 💡 FULL CONFIGURATION
>
> This configuration captures essential baseline metrics. To see the complete metric catalog, refer to the [configuration reference](https://docs.newrelic.com/docs/opentelemetry/db360/oracle/config-reference/#adb-full).

> #### 💡 TIP
>
> You can also:
>
> -   [Configure multiple receivers](https://docs.newrelic.com/docs/opentelemetry/db360/oracle/multi-receiver): To monitor multiple Oracle Database instances from one collector.
> -   [Configure SQL Query Receiver](https://docs.newrelic.com/docs/opentelemetry/db360/capabilities/sql-query-receiver/): To collect custom metrics from your Oracle Database.
> -   [Link your Oracle Database with APM](https://docs.newrelic.com/docs/opentelemetry/db360/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/db360/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]

Once your data is being collected, you can access comprehensive Oracle Database monitoring through the New Relic UI.

To find your Oracle Database entity in New Relic:

1.  Go to **<https://one.newrelic.com> > All Capabilities > Databases**.
2.  Set the search criteria as `instrumentation.provider = opentelemetry`.
3.  Select your Oracle ADB database from the list of entities.

## Related articles [#related-articles]

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

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

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

Learn about the available metrics collected by the NRDOT Collector.

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

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