SMTP

Hello all



-29278: SMTP transient error: 421 Service not available

Please help he on this. What is this and what need to be done.

ajaybeldeAsked:
Who is Participating?
 
sdstuberConnect With a Mentor Commented:
side note,  if you use smtp_out_server and it is NULL (unpopulated) then utl_mail is supposed to roll over to db_domain but it doesn't.

I haven't found a patch that resolves this bug.  

Easy fix though is to either NOT use utl_mail,  or, if you do,  make sure smtp_out_server is always populated.
0
 
sdstuberCommented:
it means your smtp server responded saying it wasn't able to send mail currently.

the "transient" part means it's expected the problem is temporary.

unfortunately, if you want more specifics you'll have to go to your smtp server and check its logs for details of exactly what went wrong
0
 
slightwv (䄆 Netminder) Commented:
What database version?

Depending on your version:
Did you set up the parameter smtp_out_server to a valid SMTP server?

Do you need to authenticate to the mail server?

Can you post your code?
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
LesterClaytonCommented:
I'd like to point out that some servers use a feature called "Greylisting".  If the SMTP server you're sending mail to is one of those servers, then this is a normal response.  a 4xx error code is temporary, and one of the ways that Greylisting is implemented.  SMTP RFC suggests that your client should re-attempt after a specified length of time.  You should ignore 4xx messages, and only act if it turns into a 5xx error (permanent failure).
0
 
sdstuberCommented:
actually,  slightwv could be correct.

if your utl_smtp.connection isn't valid   UTL_SMTP can return a 421 error.

Normally your SMTP server should send that as a response if it needs to close the connection.

However,  if you never established a connection then UTL_SMTP itself can return that error.
or, more thoroughly....

if you never called open_connection
or if you called it but it didn't return a valid connection and you used it anyway
or if the connection was vaild but it was closed by the server
or if the connection was valid but you closed it programmatically and then attempted to use it after closing
0
 
ajaybeldeAuthor Commented:
We are using 10.2.04
0
 
sdstuberCommented:
all of the above applies to UTL_MAIL as well, since it's just a limited functionality wrapper for utl_smtp
0
 
sdstuberCommented:
>>> We are using 10.2.04

doesn't matter - same is true from 8i through 11gR2
0
 
slightwv (䄆 Netminder) Commented:
>>We are using 10.2.04

That is the answer to one of my questions.  What about the rest?
0
 
slightwv (䄆 Netminder) Commented:
>>doesn't matter - same is true from 8i through 11gR2

Sure it does.  smtp_out_server is a new parameter.
0
 
sdstuberCommented:
that only applies to utl_mail.

if you don't have it populated you'll get a different error

I didn't notice you had requested that info though, sorry
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.