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: How do you check for alert log file for the latest error ?

Re: How do you check for alert log file for the latest error ?

From: Barbara Baker <barb.baker_at_gmail.com>
Date: Wed, 15 Nov 2006 09:05:09 -0700
Message-ID: <47a6f72b0611150805x59636a7cic4dba09ebbb69309@mail.gmail.com>


Anand:
My favorite is still "chk_oerr" on Tim Gorman's web site (www.evdbt.com) It takes a bit of setup, but does everything! It keeps a file with the last line previously checked so it only looks at new entries.

chk_oerr.sh (ASCII text file 11Kb) UNIX Korn-shell script which is intended to called from the UNIX *cron *perhaps once per day or a couple times per week. It sends email to the configured email accounts (note the need for files named ".dbapage" and ".dbamail" in the "$HOME" directory of the owning UNIX account) when it detects newly-logged ORA- error messages in the "alert.log" file or in the ".trc" files in the BACKGROUND_DUMP_DEST or USER_DUMP_DEST directories. Also reports newly generated "core" files in the CORE_DUMP_DEST.

HTH!
Barb

On 11/15/06, Anand <shastry17_at_gmail.com> wrote:
>
> * Hi all,
>
>
> How do you check for alert log file for the latest error ?*
>
> *Linux command to remove files in the log direcotory,in such a way that
> the last 15 days fills must exist but purge the remaining files? *
>
> *What if the alert log file has been deleted by some script?
>
> Thanks
> Anand
> *
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 15 2006 - 10:05:09 CST

Original text of this message

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