OEM does not alert complete error message from alert log
As per https://forums.oracle.com/forums/thread.jspa?threadID=872273, i had reset the Generic Alert log to "ORA-0*(\[0-9]\[0-9]\[0-9])\[^0-9]*"
However, when i try to manually generate the ORA errors in alert log as per below command, it does not alert me the entire message, i continue see only "Message=1 distinct types of ORA- errors have been found in the alert log. "
execute sys.dbms_system.ksdwrt(2,' ORA-02999 : test message, ignore me' );
I have made the above alert settings on both DB level and on the template
Can somebody help me to identify why this still doesnt work?