FAQ
*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
*

Search Discussions

  • Johan Eriksson at Nov 15, 2006 at 11:17 am

    On 11/15/06, Anand wrote:
    Hi all,


    How do you check for alert log file for the latest error ?
    I use vi for this, but someone most cartainly have this scripted.
    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?
    find ./ -ctime +15 -exec rm {} \;
    (been running in the directory you want to purge )
    What if the alert log file has been deleted by some script?
    Then it doesn't exists and oracle will create a new on (if when trying
    to write to it or during startup I don't know and haven't tested)
  • Barbara Baker at Nov 15, 2006 at 4:05 pm
    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 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
  • Solo Mahi at Nov 20, 2006 at 7:05 am
    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.

    Thanks
    On 11/15/06, Barbara Baker wrote:

    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 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
  • Johan Eriksson at Nov 20, 2006 at 7:17 am

    On 11/20/06, Solo Mahi wrote:
    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.

    Thanks
    With tail you will get the last ines in the file, but nothing that
    tells you the last lines with errors in them, to get those you need to
    search.
    tail -f just prints the last lines of the file as they are written to it

    /johan
  • Raphael Tiran at Nov 20, 2006 at 9:58 am
    Hi,
    I provide a java program (as a charityware) for that purpose. It can check simultaneously numerous instances' alert log. For each error raised, it notifies you by email / sound and through a GUI.
    You can download it from www.orasentry.com.
    Raf
    * 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
    *
    Lycos Cinema : Catch up with your friends and see free movies online - watch, chat & connect now >>
    http://cinema.lycos.com
  • Jared Still at Nov 20, 2006 at 10:29 pm

    On 11/15/06, Anand wrote:
    * How do you check for alert log file for the latest error ?*
    I use a Perl (no surprise there, eh) script to monitor alert logs.

    It runs as a daemon ( or a service on Windows) and emails
    errors in the alert log as they read. It is very configurable, though
    moreso on Unix type platforms than on windows.

    Code is available at http://www.jaredstill.com/books.html

    --
    Jared Still
    Certifiable Oracle DBA and Part Time Perl Evangelist

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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedNov 15, '06 at 10:39a
activeNov 20, '06 at 10:29p
posts7
users6
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase