Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Alert log error checking script for Windows?

Re: Alert log error checking script for Windows?

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 18 Oct 2004 12:14:19 -0700
Message-ID: <bf463804101812145fb1e3fa@mail.gmail.com>


On Mon, 18 Oct 2004 11:21:47 -0700 (PDT), Alex <stant_98_at_yahoo.com> wrote:
> This event test signifies that the database being monitored has generated errors to the ALERT log file since the last sample time. The ALERT log file is a special trace file containing a chronological log of messages and errors. An alert event is triggered when Oracle Exception (ORA-006xx), deadlock detected (ORA-00060), or data block corrupted (ORA-01578) messages are written to the ALERT log file. A warning is displayed when other ORA messages are written to the ALERT log file.
>
> Id this event only monitors ORA- errors mentioned above, that would not be enough, would it?
>

There are occasionally TNS- errors that appear in the alert log, as well as other interesting messages that don't contain an ORA- tag

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 18 2004 - 14:10:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US