Re: EM configure, question

From: mek s <sidi.bouzid.meknessy_at_gmail.com>
Date: Thu, 8 Sep 2011 16:02:33 +0200
Message-ID: <CAJX5RkQPCQ-+9Z3mNqCxYMVRB1tFxYjbn2cioNBYaAC5LCATMg_at_mail.gmail.com>



Hi Niall,
This were catched in versions prior to 11g; On Thu, Sep 8, 2011 at 3:50 PM, Niall Litchfield <niall.litchfield_at_gmail.com
> 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_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 - 09:02:33 CDT

Original text of this message