Oracle Database extension: Database name query fail

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