RE: Alert emails from database 10g
- From: "Peter McLarty" <Peter_McLarty@xxxxxxxxxxxxxxxxxxxxx>
- To: <nirmalya@xxxxxxx>
- Date: Tue, 15 Aug 2006 14:09:58 +1000
It is in your configuration I have been through that here when I was
setting up a new system
One place to look is if you log into the Enterprise manager console
there is a location under preferences there for it to send email. Then
check preferred credentials and you will locate additional email
addresses
I am pretty certain that is where I had to edit it to change the sending
behaviour of the system sending me emails
If you check under $ORACLE_HOME\server_database\sysman\config one of the
properties files holds email addresses
HTH
Cheers
Peter McLarty
Technical Consultant
Service Delivery
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mladen Gogala
Sent: Tuesday, 15 August 2006 10:51 AM
To: nirmalya@xxxxxxx
Cc: oracle-l
Subject: 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,RAZOR
2_CHECK,RCVD_IN_BL_SPAMCOP_NET,SUBJECT_DRUG_GAP_VIA,URIBL_SBL,URIBL_WS_S
URBL
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
