Re: EM configure, question
- From: mek s <sidi.bouzid.meknessy@xxxxxxxxx>
- To: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- Date: Thu, 8 Sep 2011 15:31:34 +0200
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
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
