-
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.
-
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>
-
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>;
-
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
-
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.
-
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.
-
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
-
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...