Re: EM configure, question
Date: Thu, 8 Sep 2011 14:15:13 +0100
Message-ID: <CABe10sZXyHZk0Gi2KF_tTk2cOrc2AAkfJc2L961CAExcvkNFXA_at_mail.gmail.com>
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_at_gmail.com>wrote:
> Hi Niall,
>
> Thank you,
>
> but where "see below" ?
>
>
> On Thu, Sep 8, 2011 at 1:02 PM, Niall Litchfield <
> niall.litchfield_at_gmail.com> 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_at_gmail.com>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
>>>
>>>
>>> --
>>> http://www.freelists.org/webpage/oracle-l
>>>
>>>
>>>
>>
>>
>> --
>> Niall Litchfield
>> Oracle DBA
>> http://www.orawin.info
>>
>
>
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 08 2011 - 08:15:13 CDT