Re: Alert emails from database 10g

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@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=<oracle-l-bounce@xxxxxxxxxxxxx>, size=4270, class=0, nrcpts=1, 
msgid=<20060814164932.ftr7z4gokowgk0sk@xxxxxxxxxxx>, proto=ESMTP, daemon=MTA, 
relay=localhost.noip.com [127.0.0.1]
Aug 14 19:53:00 medo sendmail[5940]: k7ENr0xQ005939: to=<mgogala@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=<oracle-l-bounce@xxxxxxxxxxxxx>, size=4466, class=0, nrcpts=1, 
msgid=<90ad14210608141717m3fee9a63q946b3060c0cfd712@xxxxxxxxxxxxxx>, 
proto=ESMTP, daemon=MTA, relay=localhost.noip.com
[127.0.0.1]
Aug 14 20:23:02 medo sendmail[5969]: k7F0N12Z005967: to=<mgogala@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=<gogala@xxxxxxxxxxxxx>, 
ctladdr=<mgogala@xxxxxxxxxxxxx> (500/100), delay=00:00:00, xdelay=00:00:00, 
mailer=relay, pri=121384, relay=smtp.sbc.mail.yahoo4.akadns.net. 
[68.142.229.41], 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@ybp71>,bayes=0.999999521582874,autolearn=no
Aug 14 20:31:29 medo sendmail[6050]: k7F0VDZW006044: to=<mgogala@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
http://www.mgogala.com

--
http://www.freelists.org/webpage/oracle-l

Other related posts: