Re: Alert emails from database 10g
- From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
- To: nirmalya@xxxxxxx
- Date: Mon, 14 Aug 2006 20:51:20 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
