RE: Format for monitoring generic alert log messages in 12c
- From: "Jorgensen, Finn" <Finn.Jorgensen@xxxxxxxxxxxxxxxxx>
- To: "niall.litchfield@xxxxxxxxx" <niall.litchfield@xxxxxxxxx>, "mschmitt@xxxxxxxxxxxx" <mschmitt@xxxxxxxxxxxx>
- Date: Fri, 14 Dec 2012 09:26:41 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Niall Litchfield
Sent: Thursday, December 13, 2012 6:08 PM
To: mschmitt@xxxxxxxxxxxx
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@xxxxxxxxxxxx>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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
//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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
