Re: Monitoring

From: Full Name <cai_at_chevron.com>
Date: 1997/10/14
Message-ID: <01bcd8a7$ceb46c40$7f802192@banu-hou130-1.hou130.chevron.com>#1/1

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 Tue Oct 14 1997 - 00:00:00 CDT