Oracle Database Monitoring - Alerting

[badgerfifteen]

Hi all,

Just wondering if I am missing something with the Oracle DB extension. I am under the impression alerting is done automatically as it is detected by the Davis AI. I've just tried to simulate changing the password that DT uses to connect to the DB so essentially severing its connection but even after 20 mins, it still says 'No Problems'. I would have to manually create a metric event to alert for this which I am not sure is right? 

[AntonPineiro · Accepted solution]

Hi,

I think you need to create your own metric events.

Best regads

[JamesKitson · Accepted solution]

For pretty much all extensions, you need to define your own metric events. Davis will correlate metrics/events that you define but it does not automatically start raising events on metrics. There are some exceptions to this where an extension explicitly reports an event and this is usually discussed on the Hub page.

One note on SQL data source extensions specifically is that when they can't connect they do not report any metrics so to alert on availability/outage issues from the extension's perspective you need to create a metric event configured to alert on missing data.

[Leonardo_Val · Accepted solution]

Hello!
You will need to create metric events to alarm when a certain behavior happens in your extension, if you have DQL you could create a workflow that triggers in base of the system events generated from the Oracle Extension, this could help to alarm about some known exceptions.

[badgerfifteen]

Hi all, Thanks for all of your support! 🙂