Re: Monitoring

Something you may want to look at is Oracle's Enterprise Manager. It has built in events for what you are describing and supports paging and smtp mail.

Myself I'm using a central database that monitors the other 12. This database
has procedures that look across a database link. You would then need to either
write a file out to the operating system and have a cron type task do something
or you need another app that monitors this database. What that buys you is being
able to monitor events inside the database....

hope that helps

Carl Christianson
DBA First Data Corp

Full Name wrote:

> Here's a little diddy that might work.
>
> #!/bin/ksh
> ###################################################################
> # #
> # Oracle Alert Log pgm #
> # #
> # The purpose of the program is to scan the Oracle RDBMS log file #
> # and to fine any Oracle errors that may have occured #
> # If finding any then flagg them and send to Oracle admin types #
> # warning messages via mail and possibly beeper paging to notify #
> # Oracle admin types that a problem may exist on an Oracle box. #
> # #
> ###################################################################
>
> trap 'exit' 1 2 3
>
> case $ORACLE_TRACE in
> T) set -x ;;
> esac
> ORACLE_HOME=/local/lfs1/vend/oracle
> # Set path if path not set (if called from /etc/rc.
> case $PATH in
> "") PATH=/bin:/usr/bin:/etc
> export PATH ;;
> "ora_alert" 40 lines, 1637 characters
> export PATH ;;
> esac
> # Set path if path not set (if called from cron )
> case $PATH in
> "") PATH=/bin:/usr/bin:/etc
> export PATH ;;
> esac
>
> # Query the Oracle alert log and pull all ORA-**** errors if any.
> grep ORA- $ORACLE_HOME/rdbms/log/alert_HPHT04.log >
> $ORACLE_HOME/dba/admin/ora_t
> est.log
>
>
> if [ -s $ORACLE_HOME/dba/admin/ora_test.log ]
> then
> cat $ORACLE_HOME/dba/admin/hostname.txt
> $ORACLE_HOME/dba/admin/ora_test.lo
> g > $ORACLE_HOME/dba/admin/oraerr.log
> /usr/bin/mailx -s "user1" pagemail_at_ctmces1.hou130.chevron.com
> <
> $ORACLE_H
> OME/dba/admin/oraerr.log
> /usr/bin/mailx -s "user2" pagemail_at_ctmces1.hou130.chevron.com <
> $ORACLE_HOME/d
> ba/admin/oraerr.log
> fi
>
>
> AMARENDRA B NETTEM <nettama_at_charlie.cns.iit.edu> wrote in article
> <34426EDD.49AC_at_charlie.cns.iit.edu>...
> > R Aponte wrote:
> > >
> > > I have 9 Sun Solaris Servers with 9 databases. I am looking for a
>
> software
> > > that will monitor the server and send a signal/message (to
 possible a
> > > beeper) that a database went down. Does anybody knows about a
> software
> like
> > > that ?
> > ENTERPRISE MANAGER FOR WINDOWS NT
> > AMAR
> > --
> >
> *
> **************************************************************************
>
> **
> > AMARENDRA B NETTEM 5039 N E River Road, Apt. 1A
> > Certified Oracle DBA NORRIDGE, IL 60656
> > Whittman-Hart Inc.,
> > 311 South Wacker Drive, Suite 3500
> > Chicago, IL 60606.
> >
> > Ph.No. (708) 583 9870 (H)
> > (312) 913 6758 (W)
> >
> > E-mail:nettama_at_charlie.cns.iit.edu,
> > anettem_at_whittman-hart.com
> >
> > Homepage: http://www.iit.edu/~nettama
> >
> >
> *
> **************************************************************************
>
> > Opinions are mine and do not necessarily reflect those of
 Whittman-hart
> > Inc.
> >
Received on Thu Oct 16 1997 - 00:00:00 CDT