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:
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.
Post a Comment