Tuesday
Dec152015

Configure Email Alerts for Oracle errors

I want to know whenever an ORA-#### error occurs. So I wrote a quick script and scheduled it.

It'll send you an e-mail with an aggregated list of the ORA-#### errors incurred in the last hour

Prerequisites would include the utlmail and url_mail_internal_wrapped packages, along with sufficient permission to both.

You'll also want to verify your SMTP settings for your Oracle implementation.

Included in the PL/SQL below is an example statement for how to write to the alert.log for testing and, as always, links that helped me on my way.