ORA-29278: SMTP transient error: 421 Service not available [message #318191] |
Tue, 06 May 2008 01:23  |
musman
Messages: 147 Registered: July 2007 Location: Lahore
|
Senior Member |

|
|
i am trying to send mail using utl_smtp.
but this error occurs. even smtp is installed on server.
ERROR at line 1:
ORA-29278: SMTP transient error: 421 Service not available
ORA-06512: at "SYS.UTL_SMTP", line 21
ORA-06512: at "SYS.UTL_SMTP", line 97
ORA-06512: at "SYS.UTL_SMTP", line 139
ORA-06512: at "TEST.DEMO_MAIL", line 235
ORA-06512: at "TEST.DEMO_MAIL", line 113
ORA-06512: at "TEST.DEMO_MAIL", line 99
ORA-06512: at line 2
database 10.2.0
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: ORA-29278: SMTP transient error: 421 Service not available [message #652821 is a reply to message #652818] |
Mon, 20 June 2016 06:25   |
John Watson
Messages: 8964 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Your SMTP server is using ESMTP, which means you need to open the conversation with EHLO, not with HELO. If I telnet to it, this works:220 smtp.qq.com Esmtp QQ Mail Server
ehlo example.com
250-smtp.qq.com
250-PIPELINING
250-SIZE 73400320
250-STARTTLS
250-AUTH LOGIN PLAIN
250-AUTH=LOGIN
250-MAILCOMPRESS
250 8BITMIME but if I give it helo instead of ehlo, it doesn't. If I'm right, either you have to write your own esmtp compliant code, or you need to ask your mail administrators to permit smtp.
|
|
|
|
|
Re: ORA-29278: SMTP transient error: 421 Service not available [message #653002 is a reply to message #653001] |
Thu, 23 June 2016 07:51   |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
In general, I have made had good experiences with running a local mail-forwarder on the database server ( postfix / sendmail ), and set up forwarding to the "real" mail server.
That way, when glitches/hangs/network problems/planned downtimes that prevent the "real" mail server of the organisation to accept the mail, the mails that are send by my applications don't get lost, but end up in the local mail queue and get send when the problem on the mail server side is fixed.
( Of course that only works when you are not only the DBA but also the administrator of the underlying OS. )
|
|
|
|