Install & configure NRDOT for Oracle monitoring with Autonomous Database

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 > Integrations & Agents > Oracle (OpenTelemetry) . This page covers manual installation only.

Prerequisites

Before you begin, ensure you have the following:

A valid New Relic license key
Supported architecture: Linux with AMD64 and ARM64
Network connectivity to New Relic OTLP endpoint
Oracle Database 19c or later

Install NRDOT Collector

Select the appropriate installation distribution method for your Linux environment:

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

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:

CREATE USER <YOUR_DB_USERNAME> IDENTIFIED BY "<YOUR_DB_PASSWORD>";
GRANT CREATE SESSION TO <YOUR_DB_USERNAME>;

Grant monitoring privileges for Autonomous Database

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.

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

Database Username

Database Password

Oracle ADB Hostname

Oracle ADB Port

Service Name

New Relic OTLP Endpoint

New Relic License Key

adb-config.yaml

1
receivers:
2
    nroracledb/adb:
3
      datasource: "oracle://newrelic:YOUR_PASSWORD@adb.example.oraclecloud.com:1522/YOUR_SERVICE_NAME?ssl=true&ssl%20verify=true"
4
      collection_interval: 15s
5
      events:
6
        db.server.query_sample:
7
          enabled: true
8
        db.server.top_query:
9
          enabled: true
10
        db.server.session.wait_sample:
11
          enabled: true
12
        db.server.top_procedure:
13
          enabled: true
14
        db.server.query_plan:
15
          enabled: true
16

17
      top_query_collection:
18
        max_query_sample_count: 1000
19
        top_query_count: 200
20
        collection_interval: 60s
21
        allowed_comment_keys:
22
          - nr_service_guid
23

24
      query_sample_collection:
25
        max_rows_per_query: 100
26
        allowed_comment_keys:
27
          - nr_service_guid
28

29
      session_wait_event_collection:
30
        max_rows_per_query: 100
31

32
      top_procedure_collection:
33
        max_procedure_sample_count: 1000
34
        top_procedure_count: 250
35
        collection_interval: 60s
36

37
      # Metrics configuration - This baseline configuration captures essential metrics. To enable advanced monitoring and extended telemetry, refer to the full configuration documentation
38
      metrics:
39
        oracledb.buffer_cache.utilization:
40
          enabled: true
41
          attributes:
42
            - oracle.db.pdb
43
        oracledb.consistent_gets:
44
          enabled: true
45
          attributes:
46
            - oracle.db.pdb
47
        oracledb.cpu_time:
48
          enabled: true
49
          attributes:
50
            - oracle.db.pdb
51
        oracledb.database.cpu.utilization:
52
          enabled: true
53
          attributes:
54
            - oracle.db.pdb
55
        oracledb.database.wait.utilization:
56
          enabled: true
57
          attributes:
58
            - oracle.db.pdb
59
        oracledb.db_block_gets:
60
          enabled: true
61
          attributes:
62
            - oracle.db.pdb
63
        oracledb.enqueue_deadlocks:
64
          enabled: true
65
          attributes:
66
            - oracle.db.pdb
67
        oracledb.execution.utilization:
68
          enabled: true
69
          attributes:
70
            - oracledb.parse.type
71
            - oracle.db.pdb
72
        oracledb.executions:
73
          enabled: true
74
          attributes:
75
            - oracle.db.pdb
76
        oracledb.hard_parses:
77
          enabled: true
78
          attributes:
79
            - oracle.db.pdb
80
        oracledb.host.cpu.utilization:
81
          enabled: true
82
          attributes:
83
            - oracle.db.pdb
84
        oracledb.library_cache.utilization:
85
          enabled: true
86
          attributes:
87
            - oracle.db.pdb
88
        oracledb.logical_reads:
89
          enabled: true
90
          attributes:
91
            - oracle.db.pdb
92
        oracledb.logons:
93
          enabled: true
94
          attributes:
95
            - oracle.db.pdb
96
        oracledb.parse.rate:
97
          enabled: true
98
          attributes:
99
            - oracledb.parse.result
100
            - oracle.db.pdb
101
        oracledb.parse_calls:
102
          enabled: true
103
          attributes:
104
            - oracle.db.pdb
105
        oracledb.pga_memory:
106
          enabled: true
107
          attributes:
108
            - oracle.db.pdb
109
        oracledb.physical_io.requests:
110
          enabled: true
111
          attributes:
112
            - disk.io.direction
113
            - disk.io.block_size
114
            - oracle.db.pdb
115
        oracledb.physical_reads:
116
          enabled: true
117
          attributes:
118
            - oracle.db.pdb
119
        oracledb.physical_writes:
120
          enabled: true
121
          attributes:
122
            - oracle.db.pdb
123
        oracledb.processes.usage:
124
          enabled: true
125
        oracledb.sessions.usage:
126
          enabled: true
127
          attributes:
128
            - session_type
129
            - session_status
130
            - oracle.db.pdb
131
        oracledb.sga.usage:
132
          enabled: true
133
          attributes:
134
            - oracledb.sga.component.name
135
        oracledb.shared_pool.utilization:
136
          enabled: true
137
          attributes:
138
            - oracle.db.pdb
139
        oracledb.sql_service.response.duration:
140
          enabled: true
141
          attributes:
142
            - oracle.db.pdb
143
        oracledb.sqlnet.io.transferred:
144
          enabled: true
145
          attributes:
146
            - network.io.direction
147
            - destination.type
148
            - oracle.db.pdb
149
        oracledb.tablespace_size.usage:
150
          enabled: true
151
          attributes:
152
            - tablespace_name
153
            - oracle.db.pdb
154
        oracledb.transactions.usage:
155
          enabled: true
156
        oracledb.user_commits:
157
          enabled: true
158
          attributes:
159
            - oracle.db.pdb
160
        oracledb.user_rollbacks:
161
          enabled: true
162
          attributes:
163
            - oracle.db.pdb
164

165
      # Resource attributes attached to all metrics/logs (all enabled by default)
166
      resource_attributes:
167
        oracle.db.edition:
168
          enabled: true
169
exporters:
170
    otlp/newrelic:
171
      endpoint: https://otlp.nr-data.net:4318
172
      headers:
173
        api-key: YOUR_LICENSE_KEY
174
      compression: gzip
175
      retry_on_failure:
176
        enabled: true
177
        initial_interval: 5s
178
        max_interval: 30s
179
        max_elapsed_time: 300s
180
      sending_queue:
181
        enabled: true
182
        sizer: bytes
183
        queue_size: 100_000_000
184
        num_consumers: 10
185
        batch:
186
          sizer: bytes
187
          max_size: 1_000_000
188
          min_size: 0
189
          flush_timeout: 5s
190
service:
191
    pipelines:
192
      metrics/oracledb:
193
        receivers: [nroracledb/adb]
194
        exporters: [otlp/newrelic]
195
      logs/oracledb:
196
        receivers: [nroracledb/adb]
197
        exporters: [otlp/newrelic]

Conseil

You can also:

Configure multiple receivers: To monitor multiple Oracle Database instances from one collector.
Configure SQL Query Receiver: To collect custom metrics from your Oracle Database.
Link your Oracle Database with 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: 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

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

Conseil

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

Find and use your 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:

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

Troubleshooting

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

Metrics reference

Learn about the available metrics collected by the NRDOT Collector.

RDS instrumentation

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

Install & configure NRDOT for Oracle monitoring with Autonomous Database

Guided installation

Prerequisites

Install NRDOT Collector

For AMD64 architecture

For ARM64 architecture

Configure database user

Grant monitoring privileges for Autonomous Database

Configure NRDOT Collector

full configuration

Conseil

Restart NRDOT Collector

Conseil

Find and use your data

Troubleshooting

Metrics reference

RDS instrumentation

Install & configure NRDOT for Oracle monitoring with Autonomous Database

Guided installation

Prerequisites .css-21sua1{background:none;border:none;width:0;padding:0;}

Install NRDOT Collector

For ARM64 architecture

Configure database user

Grant monitoring privileges for Autonomous Database

Configure NRDOT Collector

full configuration

Conseil

Restart NRDOT Collector

Conseil

Find and use your data

Related articles

Troubleshooting

Metrics reference

RDS instrumentation

Prerequisites