Search This Blog

Friday, July 17, 2009

ORA-29278: SMTP transient error: 421 Service not available

Tips:
Oracle Certification - Tips

DBA Preparation - Tips

Practical DBA - Tips


One of our production database I saw the below error message


ORA-29278: SMTP transient error: 421 Service not available


Db: 10.2.0.4.0 (cpu jan-09 applied)
OS: Win32bit


This error occur when SMTP SERVER IS NOT REACHABLE so it is not oracle error.
when UTL_SMTP package not able to connect SMTP server then above error will occur.


Suggestion:
1. First need to check without involving oracle we are able to connect smtp server through TELNET command

for eg:
C:\>telnet SMTP_SERVERNAME.LOCAL
Connecting To SMTP_SERVERNAME.LOCAL...Could not open connection to the host, on
port 23: Connect failed

You will see the above error it means system is not able to connect smtp server that is why the above error occur.


Check the Metalink Note for more details: 604763.1

1 comment:

ORA Training said...

Dear Oracle Newbie DBA,

Please note that SMTP server runs on port 25, not default telnet port 23. So you need to do "telnet 25" to check if smtp server is reachable or not.