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

  • From: "Solo Mahi" <solo.erp@xxxxxxxxx>
  • To: barb.baker@xxxxxxxxx
  • Date: Mon, 20 Nov 2006 12:35:42 +0530

Hi ,

Cant we check the latest error of the alert log files by

tail -f alert.log

I think we can continously get the latest error . If  I am wrong then do
please correct me.


On 11/15/06, Barbara Baker <barb.baker@xxxxxxxxx> wrote:

My favorite is still "chk_oerr" on Tim Gorman's web site (
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.   (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


On 11/15/06, Anand <shastry17@xxxxxxxxx> 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
> *

Other related posts: