If you are monitoring "generic alert log" then that *should *catch the ORA message (it might have to be ORA-02042, i.e one number shorter). I don't have a database control install setup to test against. My memory is that the generic alert test is a Perl RegExp and if you want to debug whether it is catching your errors remember the words of Jamie Zawinski Some people, when confronted with a problem, think "I know, I'll use regular > expressions." Now they have two problems. :( Niall On Thu, Sep 8, 2011 at 2:31 PM, mek s <sidi.bouzid.meknessy@xxxxxxxxx>wrote: > Thank you, > But, what does this exactly? > I have seen a new line added to alert log file (xml) but no entries in > dba_outstanding_alerts nor in SNMP server. > > > On Thu, Sep 8, 2011 at 3:15 PM, Niall Litchfield < > niall.litchfield@xxxxxxxxx> wrote: > >> ah yes the example, sorry. You'll need access to dbms_system. This one is >> from 11.2 and seems to throw an extra date line which I don't recall in >> earlier versions.. >> >> >> begin >> sys.dbms_system.ksdwrt(2,to_char(sysdate, 'Dy Mon DD HH24:MI:SS YYYY') >> ||' ORA-020042 ORACLE-L EXCEPTION ENCOUNTERED, TRY SWITCHING OFF AND ON >> AGAIN'); >> END; >> / >> >> which results in the following entry in the alert.log >> >> Thu Sep 08 14:10:16 2011 ORA-020042 ORACLE-L EXCEPTION ENCOUNTERED, TRY >> SWITCHING OFF AND ON AGAIN >> >> >> >> On Thu, Sep 8, 2011 at 12:06 PM, mek s <sidi.bouzid.meknessy@xxxxxxxxx>wrote: >> >>> Hi Niall, >>> >>> Thank you, >>> >>> but where "see below" ? >>> >>> >>> On Thu, Sep 8, 2011 at 1:02 PM, Niall Litchfield < >>> niall.litchfield@xxxxxxxxx> wrote: >>> >>>> I believe you'll find that the definition for "generic alert log error" >>>> specifically excludes ORA-00060. You'll either want to generate a different >>>> error (see below) or set your thresholds and notifications for the separate >>>> Deadlock error metrics. (NB I'm looking at an 11.2 db in Grid Control so >>>> the >>>> exact metrics available to you may vary. >>>> >>>> On Thu, Sep 8, 2011 at 10:58 AM, mek s >>>> <sidi.bouzid.meknessy@xxxxxxxxx>wrote: >>>> >>>>> Hello, >>>>> I would like to test the configure of SNMP traps via ENterprise Manager >>>>> database control (Not grid control); >>>>> Fo this, I have setup a notification rule and added recieve "Generic >>>>> Alert >>>>> Log Error" via SNMP. >>>>> >>>>> When testing it; by generating a deadlock error, the Global Enqueue >>>>> Services >>>>> Deadlock detected is shown in the alertlog file, the alert never >>>>> showing in >>>>> DBA_OUTSTANDING_ALERTS nor sent via SNMP. >>>>> >>>>> My database is 11gR2, >>>>> >>>>> Any idea? >>>>> >>>>> Thank you >>>>> >>>>> >>>>> -- >>>>> //www.freelists.org/webpage/oracle-l >>>>> >>>>> >>>>> >>>> >>>> >>>> -- >>>> Niall Litchfield >>>> Oracle DBA >>>> http://www.orawin.info >>>> >>> >>> >> >> >> -- >> Niall Litchfield >> Oracle DBA >> http://www.orawin.info >> > > -- Niall Litchfield Oracle DBA http://www.orawin.info -- //www.freelists.org/webpage/oracle-l