Home » SQL & PL/SQL » SQL & PL/SQL » ORA-29278: SMTP transient error: 421 Service not available
ORA-29278: SMTP transient error: 421 Service not available [message #318191] Tue, 06 May 2008 01:23 Go to next message
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 #318193 is a reply to message #318191] Tue, 06 May 2008 01:29 Go to previous messageGo to next message
Frank
Messages: 7877
Registered: March 2000
Senior Member
This is a message generated by the mailserver.
Re: ORA-29278: SMTP transient error: 421 Service not available [message #318194 is a reply to message #318193] Tue, 06 May 2008 01:31 Go to previous messageGo to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

u mean to say that mail server does not support smtp.
oracle server doing fine but not mail server.
is that??

[Updated on: Tue, 06 May 2008 01:34]

Report message to a moderator

Re: ORA-29278: SMTP transient error: 421 Service not available [message #318202 is a reply to message #318194] Tue, 06 May 2008 01:47 Go to previous messageGo to next message
Frank
Messages: 7877
Registered: March 2000
Senior Member
The mailserver says "421 Service not available"
This could be caused by many reasons: greylisting, server busy, maybe even a faulty HELO handshake.
Ask your systems administrator.
Re: ORA-29278: SMTP transient error: 421 Service not available [message #318480 is a reply to message #318202] Wed, 07 May 2008 00:26 Go to previous messageGo to next message
bloodhound
Messages: 9
Registered: May 2008
Junior Member
This error is not at all related to your code... this is a problem with the SMTP service... i also get this error many times but when i try after smetime it works fine...

so dat is actually a problem with the mail server...
Re: ORA-29278: SMTP transient error: 421 Service not available [message #318490 is a reply to message #318480] Wed, 07 May 2008 00:49 Go to previous messageGo to next message
babuknb
Messages: 1731
Registered: December 2005
Location: NJ
Senior Member


Disable your virus-scan and then try to execute your script.

Babu
Re: ORA-29278: SMTP transient error: 421 Service not available [message #318494 is a reply to message #318490] Wed, 07 May 2008 00:54 Go to previous messageGo to next message
Frank
Messages: 7877
Registered: March 2000
Senior Member
And what would that do?
The error clearly shows that the code is able to connect to the mailserver. The mailserver answers that it's busy.
Re: ORA-29278: SMTP transient error: 421 Service not available [message #318527 is a reply to message #318494] Wed, 07 May 2008 02:03 Go to previous messageGo to next message
babuknb
Messages: 1731
Registered: December 2005
Location: NJ
Senior Member


Dear Frank,

Some time virus-scan block mail's from smtp server. That's why i suggest need to check virus-scan disabled or enabled.

PS: Make sure your SMTP server running.

Babu
Re: ORA-29278: SMTP transient error: 421 Service not available [message #318531 is a reply to message #318527] Wed, 07 May 2008 02:10 Go to previous messageGo to next message
Frank
Messages: 7877
Registered: March 2000
Senior Member
The 421-error is a response from the SMTP-server AFTER the HELO, which means that
- the smtp server is running (otherwise there would be no response on port 25)
- my local machine/server is able to reach the smtp server (indicating that my virus-scanner has nothing to do with it)
Re: ORA-29278: SMTP transient error: 421 Service not available [message #318539 is a reply to message #318531] Wed, 07 May 2008 02:27 Go to previous messageGo to next message
babuknb
Messages: 1731
Registered: December 2005
Location: NJ
Senior Member

Dear Frank,

Thanks for update.

Actually some months before i was faced same issue. I thought the problem is

1. McAfee Scaner
2. SMTP server down.

Check Here

Now i understood.

Thanks,
Babu
Re: ORA-29278: SMTP transient error: 421 Service not available [message #575557 is a reply to message #318539] Thu, 24 January 2013 01:56 Go to previous messageGo to next message
sss111ind
Messages: 484
Registered: April 2012
Location: India
Senior Member

Hi All,

I am getting the same above error while trying to send an email,What could be the reason.

Regards,
Nathan
Re: ORA-29278: SMTP transient error: 421 Service not available [message #575558 is a reply to message #575557] Thu, 24 January 2013 02:05 Go to previous messageGo to next message
Michel Cadot
Messages: 59421
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
One of those given above, why don't you read and check them?

Regards
Michel
Re: ORA-29278: SMTP transient error: 421 Service not available [message #587927 is a reply to message #318191] Wed, 19 June 2013 06:42 Go to previous messageGo to next message
raunaqsharma@yahoo.com
Messages: 1
Registered: June 2013
Junior Member
I am getting the same error , but this case does not fall in any of the scenario's mentioned above.

I have two procedures one to create message body and setup information and the other to just attach files as attachment.

Now , i am passing the connection variable from one procedure to another procedure and then it is giving me this error. Any suggestions please?
Re: ORA-29278: SMTP transient error: 421 Service not available [message #587935 is a reply to message #587927] Wed, 19 June 2013 07:37 Go to previous message
Michel Cadot
Messages: 59421
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And what do you expect from us with what you have posted, I summarize: "I have an error and all what has been said before is useless".

I have a suggestion, copy and paste your code and what you do when you get the error.

Regards
Michel
Previous Topic: Diff between Alter Session and Alter system
Next Topic: String Split/ String replace based on character length
Goto Forum:
  


Current Time: Wed Oct 22 18:14:48 CDT 2014

Total time taken to generate the page: 0.08611 seconds