Hi Niall, This were catched in versions prior to 11g; On Thu, Sep 8, 2011 at 3:50 PM, Niall Litchfield <niall.litchfield@xxxxxxxxx > wrote: > 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