RE: Format for monitoring generic alert log messages in 12c

From: Jorgensen, Finn <Finn.Jorgensen_at_constellation.com>
Date: Fri, 14 Dec 2012 09:26:41 -0500
Message-ID: <9CE162BC5ED2C643956B526A7EDE46FF035944885C28_at_EXM-OMF-04.Ceg.Corp.Net>

Correct. Just change the warning or critical threshold for the Alert Log->Generic Alert Log Error metric to be ORA-04031 or to CYA you could use " .*ORA-04031".

To test you can do what Niall suggests below or simply edit the alert log, copy a timestamp from a previous line, modify it to be current timestamp and then insert a ORA-04031 line below it.

Thanks,
Finn

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield Sent: Thursday, December 13, 2012 6:08 PM To: mschmitt_at_uchicago.edu
Cc: oracle-l
Subject: Re: Format for monitoring generic alert log messages in 12c

It should be a standard perl regular expression (and therefore subject to http://xkcd.com/208/ : ) ) In other words a simple addition should be fine from memory You can test by a call to sys.dbms_system.ksdwrt(2, 'MESSAGE'); where message is appropriately crafted to match an oracle err message. .

On Thu, Dec 13, 2012 at 10:05 PM, Michael Schmitt <mschmitt_at_uchicago.edu>wrote:

>
> Hello,
>
> I want to monitor the alert log for ORA-04031 in Grid control (and
> nothing else), and was wondering if someone could help me with the
> format needed for that.
>
> Is it as easy as adding ORA-04031* ?
>
> I would just test it, but not exactly sure how I can cause an
> ORA-04031 on demand
>
> Thanks in advance
>
> Mike
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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


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




>>> This e-mail and any attachments are confidential, may contain legal, professional or other privileged information, and are intended solely for the addressee.  If you are not the intended recipient, do not use the information in this e-mail in any way, delete this e-mail and notify the sender. -IP1


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

Received on Fri Dec 14 2012 - 15:26:41 CET