Oracle Database extension: Database name query fail

[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_Zedan · 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

[sandeep_kanchal]

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