RE: Alert emails from database 10g

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala Sent: Tuesday, 15 August 2006 10:51 AM
To: nirmalya_at_hln.com
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_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=<oracle-l-bounce_at_freelists.org>, size=4270, class=0, nrcpts=1, msgid=<20060814164932.ftr7z4gokowgk0sk_at_www.hln.com>, proto=ESMTP, daemon=MTA, relay=localhost.noip.com [127.0.0.1] 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=<oracle-l-bounce_at_freelists.org>, size=4466, class=0, nrcpts=1, msgid=<90ad14210608141717m3fee9a63q946b3060c0cfd712_at_mail.gmail.com>, proto=ESMTP, daemon=MTA, relay=localhost.noip.com [127.0.0.1]
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=<gogala_at_sbcglobal.net>, ctladdr=<mgogala_at_medo.noip.com> (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_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
http://www.mgogala.com

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


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