Home » RDBMS Server » Server Administration » smtp server (10g windows xp)
smtp server [message #294239] Wed, 16 January 2008 23:24 Go to next message
shachipathak
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.

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

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"


Regards

Manjit Kumar [mkbhati]





Re: smtp server [message #294406 is a reply to message #294239] Thu, 17 January 2008 08:24 Go to previous message
vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton
Member
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:

SQL> ALTER SYSTEM SET SMTP_OUT_SERVER = 'SMTP host name: port id';

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.

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


Current Time: Fri Dec 09 05:35:15 CST 2016

Total time taken to generate the page: 0.05440 seconds