Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Alert emails from database 10g

Re: Alert emails from database 10g

From: Mladen Gogala <>
Date: Mon, 14 Aug 2006 20:51:20 -0400
Message-Id: <>

On 08/14/2006 07:49:32 PM, Nirmalya Das wrote:

> Problem:
> All the emails that still gets generated from the alerts when certain threshold
> crosses a limit on objects/database still goes to that email address and the
> email delivery failure notice comes to the list.
> Any idea of where the previous DBA's email address is engraved in terms of all
> the alerts.

You need help from a good system administrator. Someone should examine MTA logs and see what went where. Log usually looks like this:

Aug 14 19:43:00 medo sendmail[5930]: k7ENh0dF005929: to=<mgogala_at_localhost>, delay=00:00:00, xdelay=00:00:00, mailer=local, pri=35532, dsn=2.0.0, stat=Sent
Aug 14 19:53:00 medo sendmail[5939]: k7ENr0xQ005939: from=<>, size=4270, class=0, nrcpts=1, msgid=<>, proto=ESMTP, daemon=MTA, []
Aug 14 19:53:00 medo sendmail[5940]: k7ENr0xQ005939: to=<mgogala_at_localhost>, delay=00:00:00, xdelay=00:00:00, mailer=local, pri=34426, dsn=2.0.0, stat=Sent
Aug 14 20:23:02 medo sendmail[5967]: k7F0N12Z005967: from=<>, size=4466, class=0, nrcpts=1, msgid=<>, proto=ESMTP, daemon=MTA,
Aug 14 20:23:02 medo sendmail[5969]: k7F0N12Z005967: to=<mgogala_at_localhost>, delay=00:00:01, xdelay=00:00:00, mailer=local, pri=34623, dsn=2.0.0, stat=Sent

These are records show mail delivery to my account on my home machine. Here is a record that shows delivery from my home machine:

Aug 14 20:30:24 medo sendmail[6021]: k7F0UOAC006019: to=<>, ctladdr=<> (500/100), delay=00:00:00, xdelay=00:00:00, mailer=relay, pri=121384, [], dsn=2.0.0, stat=Sent (ok 1155601824 qp 87827)

Here is an example of another thing that can prevent mail from being delivered:  

Aug 14 20:31:29 medo spamd[2474]: identified spam (12.6/5.0) for mgogala:500 in 7.8 seconds, 3128 bytes.
Aug 14 20:31:29 medo spamd[2474]: result: Y 12 - BAYES_99,FM_NO_STYLE,FS_VIAGRI,HTML_MESSAGE,RAZOR2_CF_RANGE_51_100,RAZOR2_CHECK,RCVD_IN_BL_SPAMCOP_NET,SUBJECT_DRUG_GAP_VIA,URIBL_SBL,URIBL_WS_SURBL scantime=7.8,size=3128,mid=<000001c6c002$028695c0$8f8fa8c0_at_ybp71>,bayes=0.999999521582874,autolearn=no
Aug 14 20:31:29 medo sendmail[6050]: k7F0VDZW006044: to=<mgogala_at_localhost>, delay=00:00:11, xdelay=00:00:11, mailer=local, pri=33035, dsn=2.0.0, stat=Sent

I have a barrier called spamassassin which prevents certain emails from being delivered. Mail software is a complicated thing and you will need a good system administrator who knows how to diagnose and fix mail problems. I am using sendmail because of the unbeatable price and because I learned how to configure it while I was a system administrator. Today, there are many more choices then sendmail: exim, postfix and qmail are the first ones that come to mind. Your local system administrator probably knows what is installed and how is it configured. With sendmail, only trusted users are allowed to fake the "from" address. Your problem with the "from" part looks like the authorization problem. Delivery errors may mean that your mail server requires authorization. Sendmail requires quite a bit of tweaking before it can work as client to the server which does require authorization as SBC Global SMTP servers do. BTW, to all concerned, I am moving back to the Big Apple, there may be a day or two interrupt in my email responses. In other words, there is a bit more to the matter of email then just OE.

Mladen Gogala

Received on Mon Aug 14 2006 - 19:51:20 CDT

Original text of this message