Script for monitoring the database ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Script for monitoring the database ?

  1. #1
    Join Date
    Sep 2000
    Posts
    103
    Hi all,

    Is it possible for me to get a script which will email me if there is any message/error message in the alert log and any script which will help me monitor the live database. We're using win2000 and 98 machines.
    I'd really appreciate all the help I can get.

    Thanks a lot

    pst.

  2. #2
    I think you can use UTLBSTAT and UTLESTAT scripts to monitor the database.

    There are other scripts out there as well including some at the link to your left titled Oracle Scripts.


    To e-mail yourself if an error appears in the alert log - I'm not sure, our company wrote one but it was on UNIX and unix scripting is somewhat different I think.

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    MKS Toolkit is great for porting your shell scripts and run them in NT

    As for monitoring scripts check the oracle scripts section

  4. #4
    Join Date
    Sep 2000
    Posts
    103
    thanks Zamial for the response.
    A shell script will be fine. i just want to get an idea of how to do it. Maybe I can convert it to perl or something.

    Thanks a lot
    pst

  5. #5
    I don't have the script here because i am not on site today or all this week.

    I'm pretty sure the guys found all the info they needed from a small book though .

    I think it would be possible to find a script on-line somewhere that does what you need.

  6. #6
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Talking


    normally, when on Unix, I just use a .cmd/.bat file on the NT frontend which FTPs the monitoring files to my desktop. Our Unix box doesn't allow any email out so this is another solution. With FTP, you could send your alert-logs, monitoring files, and anything else to specific folders on your desktop if you wanted (which can be helpful).

    - Magnus

  7. #7
    Join Date
    Jul 2001
    Location
    Netherlands (Utrecht)
    Posts
    21
    Why not using OEM???

    It will monitor your databases and will email you the warnings and errors.
    J.Jongman - DBA

  8. #8
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    hi guys.
    where can i get the mks toolkit to run my shell scriots in NT?
    "High Salaries = Happiness = Project Success."

  9. #9
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    http://www.mks.com

    the demo works for 45 days only though

  10. #10
    Join Date
    Nov 2000
    Posts
    344
    Hey Pst -

    take a look at EZSQL. http://www.ezsql.net.

    One of the things it has is a db health report (very configurable) that can be run from a command prompt or
    within the EZSQL GUI. It can send you email when a variety
    of conditions exist in the database. It doesn't check the
    alert log though.

    -John
    John Dorlon
    www.ezsql.net
    john@ezsql.net

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