Re: EM configure, question

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 8 Sep 2011 14:50:05 +0100
Message-ID: <CABe10sYt=kdfG4RtKM+FV9_DPYxtWrbBHh68i6DDd6Rk410mcg_at_mail.gmail.com>

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_at_gmail.com>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_at_gmail.com> 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_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
>>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info


--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 08 2011 - 08:50:05 CDT