The ORA-29278
error may
signify that, the same server where you have your Oracle database
running, does not have an SMTP server up and running.
This solution
can help to resolve ORA-29278 errors:
Go to Control Panel->
Add or
Remove Programs->
Click on Add/Remove
Windows Components
Check IIS check box.
Select Internet Information Service (IIS) option and click on
Details button
Check whether SMTP Service is checked or not.
If not selected then select SMTP check box.
This process should be done on server.
It will help out from ORA-29278: SMTP transient error:
421 Service not available problem.
Furthermore,
Oracle MOSC documents also offers information regarding
ORA-29278 in conjunction with "attempting to utilize UTL_SMTP
on Microsoft Windows 2003 Server utilizing Oracle Database."
It states that to aid in resolving
ORA-29278, the document advises that the user, "Shutdown any
applications that are blocking or preventing use of the port, 25,
required by UTL_SMTP." because the cause of the error may be
associated with other applications (like anti-virus utilities),
"blocking access to the port required for UTL_SMTP."
