E-mail when alert
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: E-mail when alert

  1. #1
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Hi,

    My work environment are arround 100 DB in different SO. My question is:

    Does anybody know how could I check this alert.log files from all servers and send me an e-mail when everything is wrong?

    Thanks in advance

    Angel

  2. #2
    Join Date
    Jul 2000
    Posts
    521
    Is this unix env ?

    If yes, then you can write a simple shell script that can grab the errors from various alert logs and combine them together.

    The script can be executed through rsh from a central admin server.
    svk

  3. #3
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    We have unix and windows database servers :-(

    svk:

    Could you explain how you access to every alert.log in different servers from the script ?

    Thanks

    Angel

  4. #4
    Join Date
    Aug 2001
    Posts
    390
    email me.

    I have some scripts for you.


    LNGUYE16@YAHOO.COM


  5. #5
    Join Date
    Jul 2000
    Posts
    521
    I can talk only @ the unix servers !!

    Do you have some kind of stucture in your file system and directories ? Based on the SID, can you locate the alert log for that database ? I mean something like $HOME/admin/$SID/bdump ?

    Are all the 'oracle' unix accounts have same password on all servers ?

    Is there a central server that can be configured to to run a 'rsh' on all the database servers ?

    If answer to 2 questions above is 'NO', you will have to run the script individually on all servers through 'cron' and each will generate a mail.

    If the answer is 'YES', you can have one single mail talking about all the databases.
    svk

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    send me an e-mail when everything is wrong?
    When is everything wrong :-)


  7. #7
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Originally posted by julian
    send me an e-mail when everything is wrong?
    When is everything wrong :-)

    I was talking about anything :-)

    Excuse for my english

    svk: Thanks for your replies

    Regards

    Angel

  8. #8
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    I know, not everybody will be happy with this solution,
    but I do this using Oracle Entreprise Manager.

    I created an event that checks the alert-file. On alarm, a mail is sent by OEM . ( you need an SMTP avare mail system )

    Regards
    Gert

  9. #9
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Thanks Gert I will try it too

    Regards

    Angel

  10. #10
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    OEM actually has a predefined event called 'Alert' that notifies you whenever a new error message is written to the alert log.

    Why do people continue using shell scripts and CRON to do things that Oracle and OEM can do just as well, or better? It just seems like making work for yourself to me. We use SunOS, HP-UX, NT & 2000. If it weren't for OEM we would never have any sort of standardisation.
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

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