Oracle database extension: DB name query have failed

[bvypk]

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

[radek_jasinski]

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

[bvypk]

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

[Ana_Kuzmenchuk]

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

[islam_zidan · Accepted solution]

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