Unable to monitor the oracle DB with the below errors. ContentWhile polling for endpoint host name: port number: DB name query have failed: User calls count, Limits
Hi @bvypk
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
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
Hi @bvypk @radek_jasinski any update on this? Is the issue resolved?
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.
Thanks,
Islam
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