Oracle Alert log

[mn_24]

Hello,

how to extract ORA- errors from the alert log and if the error doesn't persist anymore - the issue is solved(but still in the alert log as for example from yesterday) not to create a problem again for that ?

We've tried to generate a problem but nothing has happened even though there is an ORA-609 error in the alert log of the database.

[jaume_reverte · Accepted solution]

Hello Mn_24, 

I assume you already have the logs inside Dynatrace. My recommendation for troubleshooting your scenario is to check whether your logs match the alert's Log query.

After you solve it, I recommend you do simple steps to extract more information from Dynatrace alerting. The first thing I do is create a Log processing rule to extract the ORA error code. This can be achieved using a rule like this:

Then you create a custom attribute with the generated ORA error code: 

Then you can create a Event extraction to alert for the ORA code, in my case I prefer to control for which ORA codes we are sending an alert so I have the codes directly in the Matcher:

Hope you a good monitoring!