1. ORA-29278 错误的含义 ORA-29278 是一个 Oracle 数据库错误代码,表示 SMTP 临时错误(SMTP transient error)。这意味着在尝试通过 SMTP 协议发送电子邮件时,由于某种临时性问题,服务器无法处理此消息。 2. ORA-29278 错误的可能原因 SMTP 服务器故障:目标 SMTP 服务器可能由于维护、重启或配置错误而无法处理请...
ORA-29278: SMTP transient error: 421 Service not available 一般来说,很可能是邮件服务器连接不上 p_conn := utl_smtp.open_connection('xx.xx.xxx.xxx', xxx); 解决方法也很简单,将ip改为正确的邮件服务器ip或者联系服务器运维同事看看是不是对应的端口有问题即可...
用utl_smtp发邮件报 ora-29278:smtp临时性错误:421 service not available ora-06512:在"sys.utl_smtp",line 17 ... 这个错误不是数据库服务器产生的,是找不到smtp时从smtp server返回的错误;解决方法是:指定正确的邮件服务器ip或者计算机名. (注意是邮件服务器而不是代理的邮件服务器) 我用本机Oracle,邮件...
PL/SQL - Version 10.2.0.5 and later: Random/Sporadic/Intermittent "ORA-29278: SMTP transient error: 421 Service not available" Errors
SMTP SMTP（Simple Mail Transfer Protocol）即简单邮件传输协议,它是一组用于由源地址到目的地址传送...
oracle ORA-29278: SMTP transient error: Service not available when running UTL_MAIL We are planning to install the UTL_MAIL Package and we're currently testing the installation steps in
Check SMTP Server Availability for ORA-29278 or ORA-29279 errors using UTL_SMTP to Send Email 2014-07-18 13:48 −Check SMTP Server Availability for ORA-29278 or ORA-29279 errors using UTL_SMTP to Send Email. (文档 ID 604763.1) 转到底部 修改时间:2014-5-13类型:... ...
PL/SQL - Version 19.16.0.0.0 and later: UTL_SMTP.AUTH Fails with ORA-29278: SMTP Transient Error: 421 Service Not Available
ORA-29279: SMTP permanent error followed by a SMTP error code. CAUSE The "ORA-29278: SMTP transient error: 421 Service not available" error indicates that the problem is not with the UTL_SMTP package but the fact that your database server's network configuration does not allow it to contac...