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.
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!
