cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Oracle Database extension: Database name query fail

bvypk
Participant
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
4 REPLIES 4

radek_jasinski
DynaMight Guru
DynaMight Guru

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

Have a nice day!

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
Community Team
Community Team

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

The only constant is change. Finding ways for great things to happen!

islam_zidan
Champion

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

Dynatrace Certified Professional - Dynatrace Partner - Yourcompass.ca

Featured Posts