Need a script to check alert.log file for errors
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Need a script to check alert.log file for errors

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Posts
    5

    Post need a unix script to check alert log file

    Does anyone know were I could get a unix script
    to check an alert log file for errors? Does anyone have a script that is similar?

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    grep ^ORA alertSID.log | mailx youremail
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Feb 2014
    Posts
    1
    You can use this script to monitor the alertlog for all databases and listeners running on the server:
    http://dba-tips.blogspot.ae/2014/02/...r-ora-and.html

    This script will send you an email whenever any error appear in the alertlogs for all database, it is also well coded to send you only the new errors without replicate the same error message in the next run.

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,483

    Cool

    Quote Originally Posted by jzjy0r View Post
    Does anyone know were I could get a unix script
    to check an alert log file for errors? Does anyone have a script that is similar?
    A script? Who needs a script when you can set up alerts in Enterprise Manager (DB Console or Grid or Cloud).
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width