Home » RDBMS Server » Server Administration » smtp server (10g windows xp)
smtp server [message #294239] Wed, 16 January 2008 23:24 Go to next message
Messages: 16
Registered: December 2007
Location: Bangalore
Junior Member
Dear sir,
I get the error
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 "X.y", line 68
ORA-06512: at line 7

i have got the access to the smtp sever.
i can do a telnet to the sever at port 25.

still i get this errror
i am working on windows xp.
any windows setting required.

Re: smtp server [message #294256 is a reply to message #294239] Wed, 16 January 2008 23:58 Go to previous messageGo to next message
Messages: 93
Registered: February 2007
Location: Mumbai

If you are on windows, as it appears from your post & you can successfully telnet on port 25 to your smtp host than this may be a problem by your Anti virus. Some anti virus like McAfee (version 8 in particular) hook to this port number in order to avoid mass spam mailing by viruses. This is default behavior of all new release of major anti virus packages on windows. Please check settings of your anti virus & firewall (if you have one).

If you have Mcafee than follow as below :

Virus Scan Console --> Access Protection --> Port Blocking Tab-->
Uncheck "Prevent mass Mailing Worms From sending Mail Port 25"


Manjit Kumar [mkbhati]

Re: smtp server [message #294406 is a reply to message #294239] Thu, 17 January 2008 08:24 Go to previous message
Messages: 71
Registered: June 2005
Location: Scranton
Please check if the parameter SMTP_OUT_SERVER is not set, or check if it is a blank string, or is not the correct SMTP host name and port id.

If that is the case the calls to the UTL_MAIL will fail

Try this out

1. In SQLPlus set the parameter SMTP_OUT_SERVER:


2. As SMTP_OUT_SERVER is a static parameter, the database needs to be restarted.

3. Call the UTL_MAIL package:

SQL>exec UTL_MAIL.SEND(sender=>'first.last@hostname.com', recipients=>'first.last@hostname.com', subject=>'Testmail', message => 'Hello');

PL/SQL procedure successfully completed.

4. Check email inbox for a mail message.

Previous Topic: Stop Running on DB after X number of Minutes
Next Topic: Hw to change utl_file_dir parameter
Goto Forum:

Current Time: Tue Oct 25 18:06:06 CDT 2016

Total time taken to generate the page: 0.15480 seconds