topic Oracle Database extension: Database name query fail in Extensions

Oracle Database extension: Database name query fail

bvypk — Tue, 20 Aug 2024 07:55:30 GMT

Unable to monitor the oracle DB with the below errors.

Content

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

Re: Oracle database extension

radek_jasinski — Thu, 02 Nov 2023 08:03:54 GMT

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

Re: Oracle database extension

bvypk — Thu, 02 Nov 2023 08:08:51 GMT

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

Content

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

Re: Oracle database extension

Ana_Kuzmenchuk — Fri, 15 Dec 2023 11:17:09 GMT

Hi @bvypk @radek_jasinski any update on this? Is the issue resolved?

Re: Oracle database extension: DB name query have failed

Islam_Zedan — Fri, 15 Dec 2023 13:00:37 GMT

Hi @bvypk

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

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.

https://docs.dynatrace.com/docs/shortlink/extend-oracle#before-you-begin

Thanks,

Islam

Re: Oracle Database extension: Database name query fail

sandeep_kanchal — Fri, 07 Feb 2025 11:38:43 GMT

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