| smtp server [message #294239] |
Wed, 16 January 2008 23:24  |
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  |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
