Hi everyone!

I'm trying to create a database monitoring script that reads an alert file and sends an error message if it can 'grep' a particular string.

Is there a way to send this message to a mail client using SMTP?

Even better, is there any place on this site that has these kinds of scripts?

I hope i'm not repeating questions that have already been answered...

Here is the script i'm creating. It's very simple, cron is executing it every minute and simnce i can't have a window always open due to timeout, i'd like to have the results mailed.

This is bash, by the way, under Solaris 5.8

tail /opt/oracle/admin/prodasap/bdump/alert_prodasap.log | grep ORA > /export/home/oracle/scripts/prodasap.log

if [ -s /export/home/oracle/scripts/prodasap.log ]
then
echo "Oracle message detected in alert log file" > /export/home/oracle/scripts/prodasap.log.bak
fi

This question looks familiar. Did you do a search of the site. I'm pretty sure I heard this one before...

You can use something along the lines of :

I've searched other posts, but didn't find anything i could work with, really.

And mail -s "Grep Alert!" joe@blow.com < /export/home/oracle/scripts/prodasap.log didn't quite work.

Maybe i didn't explain myself properly. I need this message to be sent to a windows client, like netscape. Can this be accomplished with the mail command?

Ok, i'm reading the oracle mail file and i see this:

The original message was received at Mon, 18 Nov 2002 16:27:01 GMT
from oracle@localhost

----- The following addresses had permanent fatal errors -----
matrix3773@yahoo.com

----- Transcript of session follows -----
550 5.1.2 matrix3773@yahoo.com... Host unknown (Name server: mailhost.: host not found)

Is this the result of a misconfigured mail serer?

Your Solaris box is configured to send non-local mail to a box called "mailhost". For it to do that, it needs to use DNS or whatever else you're using to convert a hostname to an IP address. This is where it is failing.

From your Solaris box, type "/usr/sbin/ping mailhost". You will probably get "unknown host". You need to fix that.

/usr/sbin/ping: unknown host mailhost

Yup, you're right.
I'll search the site and see if there's anything about this problem.