cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Alert Log Error Alert

Description

The alert log file is now exposed within an Oracle database via the table named X$DBGALERTEXT. Ignite can query this table via a custom alert to look for specific errors such as ORA-600, or anything that appears in this table. Below is a example of an alert that looks for any Oracle error (denoted by "ORA-" in the message text).

Note: Ignite must be given privilege to read the X$DBGALERTEXT table before this alert will function. Login as sysdba and run the following commands:

CREATE OR REPLACE VIEW X_$DBGALERTEXT as SELECT * FROM X$DBGALERTEXT;

GRANT SELECT on  X_$DBGALERTEXT to [ignite_user];

SQL Statement

select substr(MESSAGE_TEXT, 1, 300) message_text, count(*) cnt
from X$DBGALERTEXT
where (MESSAGE_TEXT like '%ORA-%' or upper(MESSAGE_TEXT) like '%ERROR%')
and cast(ORIGINATING_TIMESTAMP as DATE) > sysdate - #FREQUENCY#/1440
group by substr(MESSAGE_TEXT, 1, 300);

Alert Definition


Oracle11g_Alert_Log_Monitor.jpg

Labels (1)
Version history
Revision #:
1 of 1
Last update:
‎01-07-2015 04:45 AM
Updated by: