ORA-29279: SMTP permanent error: Unable to relay [message #519697] |
Tue, 16 August 2011 06:32 |
|
sarfarazahmedv
Messages: 6 Registered: August 2011 Location: India
|
Junior Member |
|
|
Hi,
I have a requirement wherein I need to send mail to external servers (customers). I am currently using the below UTL_MAIL standard package. This works fine when sending across internally within our organization; while I am unable to send to external server. Though I have seen others had a similar issue in forum but could'nt find useful. Could anybody advise if there is any configuration missout from database or mail server needs to be done. Any quick help will be highly appreciate.
BEGIN
--
UTL_TCP.CLOSE_ALL_CONNECTIONS;
--
EXECUTE IMMEDIATE 'ALTER SESSION SET smtp_out_server =''mail server ip address''';
--
sys.UTL_MAIL.send(sender => 'mymailid@xyz.com',
recipients => 'recepient@gmail.com',
subject => 'Test Mail',
message => 'Hello Mail,
mime_type => 'text; charset=us-ascii'
);
--
dbms_output.put_line('Mail Sent Successfully ');
END;
Following is the error:
ORA-29279: SMTP permanent error: 550 5.7.1 Unable to relay
ORA-06512: at "SYS.UTL_SMTP", line 20
ORA-06512: at "SYS.UTL_SMTP", line 98
ORA-06512: at "SYS.UTL_SMTP", line 240
ORA-06512: at "SYS.UTL_MAIL", line 405
ORA-06512: at "SYS.UTL_MAIL", line 599
P.S: We are using (Microsoft Exchange Server 2007) as mail server.
Thanks
|
|
|
|
|
Re: ORA-29279: SMTP permanent error: Unable to relay [message #579796 is a reply to message #579791] |
Fri, 15 March 2013 07:56 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
This response is of no help.
1. It is all in caps, and difficult to read.
2. Do you really think the OP is so inept that they didn't realize if they put in a bad email address?
3. Michel already gave the correct response by asking the sysadmin to look into the problem as it is not an Oracle problem. The server needs to have external emailing enabled.
|
|
|
|
|
|
|
|
|
Re: ORA-29279: SMTP permanent error: Unable to relay [message #623118 is a reply to message #519697] |
Thu, 04 September 2014 14:33 |
Solomon Yakobson
Messages: 3275 Registered: January 2010 Location: Connecticut, USA
|
Senior Member |
|
|
Error says it all. You are trying to send email from mymailid@xyz.com to recipient@gmail.com. So there can be two scenarios: mail server is servicing @xyz.com or something else, e.g. @abc.com. In both cases email either comes from outside, is going outside or both. This is called relaying. If you have first scenario, you should find out not just any mail server, but one that is configured to allow relaying emails outside. If you have second scenario, I doubted you can find an email server - who would allow outside users using their email server?
SY.
|
|
|
|
|