Oracle alert log error e-mail
Oracle Database Tips by Donald BurlesonConsulting
Its important to monitor the Oracle alert log and send alerts when serious errors are logged into the alert log. Also note that you must manage multiple alert logs in RAC.
It can take weeks to write a comprehensive set of intelligent scripts to scan the alert logs for important massages. If you don t want to write your own custom scripts, see my Oracle script download.
There are many approaches to detecting alert log messages and sending e-mail alerts:
- Ion for Oracle – The Ion tool has complete mechanisms for setting custom alert log extracts.
- SQL against the alert log – You can define the alert log file as an external table and detect messages with SQL.
- Scripts – Write OS shell scripts to detect alert log messages.
- PL/SQL – You can write a SQL*Plus procedure using utl_file to read the alert log.
- In 11g and beyond, you can directly query the alert log with SQL, using x$dbgalertext .
Also see these notes on reading the alert log file and sending alert messages:
Sample alert log monitoring scripts
Laurent Baylac has this example script to use utl_file to scan for alert log messages:
set head on
set echo off
set verify off
set feedback off
set pagesize 5000
set tab off
set serverout on
exec dbms_output.enable( 1000000)
Get the Complete
Oracle SQL Tuning Information
The landmark book Advanced Oracle SQL Tuning The Definitive Reference is filled with valuable information on Oracle SQL Tuning. This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher.
Burleson is the American Team
Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our Oracle forum .
Verifyexperience!Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications .
Errata? Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL for the page.
The Oracle of Database Support
Copyright 1996 – 2016
All rights reserved by Burleson
Oracle is the registered trademark of Oracle Corporation.