# Oracle Alert log

**URL:** <https://community.dynatrace.com/t/oracle-alert-log/46274>\
**Category:** Alerting\
**Tags:** problem-detection, oracle, extensions, problems-classic\
**Created:** [June 24, 2024, 11:06am UTC](https://community.dynatrace.com/t/oracle-alert-log/46274 "2024-06-24T11:06:03Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mn\_24](https://avatars.discourse-cdn.com/v4/letter/m/e56c9b/32.png) [@mn\_24](https://community.dynatrace.com/u/mn_24)\
**Post date:** [June 24, 2024, 11:06am UTC](https://community.dynatrace.com/t/oracle-alert-log/46274/1 "2024-06-24T11:06:03Z")

</div>

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.

 ![dynatrace_alertlog.jpg](https://global.discourse-cdn.com/dynatrace/original/3X/3/9/39f6ffe07103f3b771ff8ff905859238005e352c.jpeg)

---

<div class="post-metadata">

**Author:** ![jaume\_reverte](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/jaume_reverte/32/1479_2.png) [@jaume\_reverte](https://community.dynatrace.com/u/jaume_reverte)\
**Post date:** [August 28, 2024, 7:30am UTC](https://community.dynatrace.com/t/oracle-alert-log/46274/2 "2024-08-28T07:30:48Z")

</div>

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:

 ![jaume_reverte_0-1724828783802.png](https://global.discourse-cdn.com/dynatrace/original/2X/0/01ad5effa3d2ed4c0146d99f0eab86fc180054c6.png)

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

 ![jaume_reverte_1-1724828855118.png](https://global.discourse-cdn.com/dynatrace/original/2X/3/3d676bbf06060ab29f6020707f33425a9ee1c24f.png)

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:

 ![jaume_reverte_3-1724829843060.png](https://global.discourse-cdn.com/dynatrace/original/1X/4a1199c4189797452e7e993597f492fbe6dfa75f.png)

Hope you a good monitoring!