Generic Alert Log Error metric regex pharsing
I was wondering if someone might be able to provide me some insight as to what might be the issue concerning the regex expression in the Generic Alert Log metric. There is no Waring Threshold just a Critical Threshold that has the following expression:
ORA-0*(600?|257|16038|1157|1578|27048|1242|1243|7445|1555|4030|4031|3113|353|355|356|29740|4[0-9][0-9][0-9])[^0-9]
I have been testing the metric by using the dbms_system.ksdwrt to write entries into the alert log - for example:
exec dbms_system.ksdwrt(2, 'ORA-3113: 1');
Will write into the alert log a message "ORA-3113: 1" - OEM will then generate a Alert email message. However, the following values seem to have no effect on the process - 16038, 27048, and 29740 and no alert message is generated. I have checked the expression in a RegExp tester and the entry in the log of for example "ORA-16038: 1" shows up a match. I was just wondering if anyone might know of the cause of the behavior - it might be related to the fact the value has 5 digits instead of the 4 digits of the