based on Note:405396.1, I Changed the Matches Warning from the default value ORA-0*(600?|7445|4[0-9][0-9][0-9])[^0-9] to ORA-* in order to receive an warning alert for all ORA- errors.
but I just recieved the alert like the following:
Metric=Generic Alert Log Error
Time/Line Number=Mon Feb 25 23:52:21 2008/21234
Timestamp=Feb 26, 2008 12:06:03 AM EST
Message=ORA-error stack (1654, 1654, 1654) logged in /opt/oracle/admin/PRD/bdump/alert_PRD.log.
Notification Rule Name=Alert Log Error
Notification Rule Owner=SYSMAN
as you can see, the message only indicate the ORA-1654, nothing else.
How to set in 10g grid control to get the details alert that in the alert log like:
"ORA-1654: unable to extend index ADM.RC_BP_STATUS by 1024 in tablespace PSINDEX"
I can't believe Oracle 10g Grid control only provide the ORA- number without details
What have you actually put in the alert log filter? Cut and paste exactly please.
Note the bottom of 405396.1:
"If you define the Warning or Critical Threshold for the metric "Generic Alert Log Error Status" with just ORA- without any pattern behind, then the full ORA error number will be displayed in the alert (or in the notification if set). You will get for example:
"Message=ORA-error stack (00942) logged in <full path and name of the alert.log file>"
However in that case, as you did not specify any filter you will be alerted for all ORA- error messages recorded in the alert.log file. This must be kept in mind."