# Oracle Database extension: Database name query fail

**URL:** <https://community.dynatrace.com/t/oracle-database-extension-database-name-query-fail/42419>\
**Category:** Extensions\
**Tags:** databases, oracle, extensions\
**Created:** [November 2, 2023, 7:51am UTC](https://community.dynatrace.com/t/oracle-database-extension-database-name-query-fail/42419 "2023-11-02T07:51:28Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![bvypk](https://avatars.discourse-cdn.com/v4/letter/b/258eb7/32.png) [@bvypk](https://community.dynatrace.com/u/bvypk)\
**Post date:** [November 2, 2023, 7:51am UTC](https://community.dynatrace.com/t/oracle-database-extension-database-name-query-fail/42419/1 "2023-11-02T07:51:28Z")

</div>

Unable to monitor the oracle DB with the below errors.&nbsp;ContentWhile polling for endpoint host name: port number: DB name query have failed: User calls count, Limits

---

<div class="post-metadata">

**Author:** ![radek\_jasinski](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/radek_jasinski/32/10432_2.png) [@radek\_jasinski](https://community.dynatrace.com/u/radek_jasinski)\
**Post date:** [November 2, 2023, 8:03am UTC](https://community.dynatrace.com/t/oracle-database-extension-database-name-query-fail/42419/2 "2023-11-02T08:03:54Z")

</div>

Hi&nbsp;[@bvypk](https://community.dynatrace.com/user/65779)

Sorry, but I don’t quite understand what your problem is. Your question is about DB monitoring problems (is that the problem you are getting?) or lack of functionality on the DT side?

Radek

---

<div class="post-metadata">

**Author:** ![bvypk](https://avatars.discourse-cdn.com/v4/letter/b/258eb7/32.png) [@bvypk](https://community.dynatrace.com/u/bvypk)\
**Post date:** [November 2, 2023, 8:08am UTC](https://community.dynatrace.com/t/oracle-database-extension-database-name-query-fail/42419/3 "2023-11-02T08:08:51Z")

</div>

We configured oracle DB monitoring under Dynatrace but due to the below error DB is not reporting monitoring.

ContentWhile polling for endpoint host name: port number: DB name query have failed: User calls count, Limits

---

<div class="post-metadata">

**Author:** ![Ana.Kuzmenchuk](https://avatars.discourse-cdn.com/v4/letter/a/c37758/32.png) [@Ana.Kuzmenchuk](https://community.dynatrace.com/u/Ana.Kuzmenchuk)\
**Post date:** [December 15, 2023, 11:17am UTC](https://community.dynatrace.com/t/oracle-database-extension-database-name-query-fail/42419/4 "2023-12-15T11:17:09Z")

</div>

Hi&nbsp;[@bvypk](https://community.dynatrace.com/user/65779)&nbsp;[@radek\_jasinski](https://community.dynatrace.com/user/16832)&nbsp;any update on this? Is the issue resolved?

---

<div class="post-metadata">

**Author:** ![Islam\_Zedan](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/islam_zedan/32/31999_2.png) [@Islam\_Zedan](https://community.dynatrace.com/u/Islam_Zedan)\
**Post date:** [December 15, 2023, 1:00pm UTC](https://community.dynatrace.com/t/oracle-database-extension-database-name-query-fail/42419/5 "2023-12-15T13:00:37Z")

</div>

Hi&nbsp;[@bvypk](https://community.dynatrace.com/user/65779)

This error mainly related to user limits, you can run the below query to see what is the limit put for your user

```markup
SELECT
  to_char(m.begin_time,'hh24:mi') "start time",
  to_char(m.end_time,'hh24:mi') "end time",
  m.value "current value",
  s.average "average value",
  m.metric_name,
  m.metric_unit
FROM
  v$sysmetric m,
  v$sysmetric_summary s
WHERE
      m.metric_id = s.metric_id
  AND s.average > 0   
  AND ((m.value - s.average)/s.average)*100 >= 10
  AND lower(m.metric_name) NOT LIKE '%ratio%';

```

Also, you need to make sure that you fullfiled point #3 in the below document to get all metrics supported by the extension.

> **[Manage Oracle Database extensions](https://docs.dynatrace.com/docs/ingest-from/extensions/supported-extensions/data-sources/sql/oraclesql)**
>
> Learn how to extend observability in Dynatrace with declarative metrics ingested from Oracle Database.

Thanks,

Islam

---

<div class="post-metadata">

**Author:** ![sandeep\_kanchal](https://avatars.discourse-cdn.com/v4/letter/s/e19adc/32.png) [@sandeep\_kanchal](https://community.dynatrace.com/u/sandeep_kanchal)\
**Post date:** [February 7, 2025, 11:38am UTC](https://community.dynatrace.com/t/oracle-database-extension-database-name-query-fail/42419/6 "2025-02-07T11:38:43Z")

</div>

Hi,

Mine is standalone node, it is showing same error as above, all other cluster nodes it is working fine. The topology option is barred to be removed.

While polling for endpoint XXXXDB.XXXX.XX:1651/XXXXDB query have failed: Topology, Queries, Database, Instance
