Oracle Alert log

mn_24 — Tue, 25 Jun 2024 06:16:13 GMT

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.

Re: Oracle Alert log

jaume_reverte — Wed, 28 Aug 2024 07:30:48 GMT

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!

topic Re: Oracle Alert log in Alerting

Oracle Alert log

Re: Oracle Alert log