8 Replies Latest reply on Feb 21, 2017 3:55 PM by Billy~Verreynne

ORA-29279: SMTP permanent error: 550 5.7.1

user12251389 Feb 21, 2017 12:37 PM

I have written small anonymous block which sends an email :

DECLARE
 vSender VARCHAR2(30) := 'support@leo.com';


 vRecip  VARCHAR2(30) := 'r.d@leosoftsys.com';


 vSubj   VARCHAR2(50) := 'test';


 vMesg   VARCHAR2(4000) := 'test';


 vMType  VARCHAR2(30) := 'text/plain; charset=us-ascii';


BEGIN
 utl_mail.send
 (vSender, vRecip, NULL, NULL, vSubj, vMesg, vMType, NULL);
END;

When i execute this plsql blcock i am getting error as :

ORA-29279: SMTP permanent error: 550 5.7.1 <r.d@leo.com>: Recipient address rejected: Mail appeared to be SPAM or forged. Ask your Mail/DNS-Administrator to correct HELO and DNS MX settings or to get removed from DNSBLs; MTA helo: w010a893.k, MTA hostname: p50936657.dip0.t-ipconnect.de[80.147.102.87] (helo/hostname mismatch)
ORA-06512: at "SYS.UTL_MAIL", line 654
ORA-06512: at "SYS.UTL_MAIL", line 671
ORA-06512: at line 14
29279. 00000 -  "SMTP permanent error: %s"
*Cause:    A SMTP permanent error occurred.
*Action:   Correct the error and retry the SMTP operation.

1. Re: ORA-29279: SMTP permanent error: 550 5.7.1

Saubhik Feb 21, 2017 12:38 PM (in response to user12251389)

This is not an Oracle error, check with your mail server admin.
Like Show 0 Likes(0)

Actions
2. Re: ORA-29279: SMTP permanent error: 550 5.7.1

user12251389 Feb 21, 2017 12:52 PM (in response to Saubhik)

I think the MTA hostname: p50936657.dip0.t-ipconnect.de[80.147.102.87] is incorrect. DO you know how to change it ? It should be <oracle server name>
Like Show 0 Likes(0)

Actions
3. Re: ORA-29279: SMTP permanent error: 550 5.7.1

AndrewSayer Feb 21, 2017 1:07 PM (in response to user12251389)

user12251389 wrote:

I think the MTA hostname: p50936657.dip0.t-ipconnect.de[80.147.102.87] is incorrect. DO you know how to change it ? It should be <oracle server name>
show parameter smtp_out_server
alter system set smtp_out_server = <correct smtp server>;
Like Show 0 Likes(0)

Actions
4. Re: ORA-29279: SMTP permanent error: 550 5.7.1

user12251389 Feb 21, 2017 1:14 PM (in response to AndrewSayer)

Yes i already set this correctly but i am talking about the MTA hostname which is not looking correctly
Like Show 0 Likes(0)

Actions
5. Re: ORA-29279: SMTP permanent error: 550 5.7.1

Billy~Verreynne Feb 21, 2017 1:21 PM (in response to user12251389)

Seems like the HELO command is incorrect. Something I have mentioned before as Oracle sample code, and the majority of PL/SQL e-mail sample code found, get the HELO command wrong. See Re: How to write procedure in database to retrieve oracle report and send it by mail.

Also, your SMTP client (which is the database server when using PL/SQL) in some cases need to be a valid client to accept e-mail from, from the SMTP server's perspective.

Lastly, thou shalt not relay - use the SMTP server on domain c to relay mail between domains a and b. Though this does not seem to be the case with the error you have reported.
Like Show 0 Likes(0)

Actions
6. Re: ORA-29279: SMTP permanent error: 550 5.7.1

AndrewSayer Feb 21, 2017 1:52 PM (in response to Billy~Verreynne)

Billy~Verreynne wrote:

Seems like the HELO command is incorrect. Something I have mentioned before as Oracle sample code, and the majority of PL/SQL e-mail sample code found, get the HELO command wrong. See Re: How to write procedure in database to retrieve oracle report and send it by mail.

Also, your SMTP client (which is the database server when using PL/SQL) in some cases need to be a valid client to accept e-mail from, from the SMTP server's perspective.

Lastly, thou shalt not relay - use the SMTP server on domain c to relay mail between domains a and b. Though this does not seem to be the case with the error you have reported.
With utl_mail, there's no need to do the HELO call yourself, it's all handled by the send procedure - although, that doesn't mean Oracle's own code doesn't suffer from exactly what you have mentioned.

OP, try having your process use utl_smtp instead.
Like Show 0 Likes(0)

Actions
7. Re: ORA-29279: SMTP permanent error: 550 5.7.1

user12251389 Feb 21, 2017 3:13 PM (in response to user12251389)

Thank you all. It works for me. I have tried with authentication with Username and Password and also used UTL_SMTP.ehlo instead of UTL_SMTP.Helo and it works for me
Like Show 0 Likes(0)

Actions
8. Re: ORA-29279: SMTP permanent error: 550 5.7.1

Billy~Verreynne Feb 21, 2017 3:55 PM (in response to AndrewSayer)

UTL_MAIL is ugly code with a very simplistic interface. It does not do much right...
Like Show 1 Likes(1)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.