Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error 553 sorry, that domain isn't in my list of allowed rcpthosts (#5.7.1)

user396453Dec 21 2011 — edited Dec 21 2011
I want send the email from oracle database.
So I did the following steps
1.@F:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\utlmail.sql

2.@F:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\prvtmail.plb

3.alter system set smtp_out_server = 'webmail.vilsoft.co.in:25' scope=both;

4.exec utl_mail.send(sender=> 'Id1@vilsoft.co.in',recipients=>'Id2@vilsoft.co.in',subject=>'test mail',message=>'hi');

PL/SQL procedure successfully completed.

So the mail is send to Destination Correctly.

But When I want to send the mail from one server to another server So i execute the following query

SQL> exec utl_mail.send(sender=> 'ID1@vilsoft.co.in',recipients=>'Id2@gmail.com',subject=>'test mail',message=>'hi');

then following error occurs....

BEGIN utl_mail.send(sender=> 'ID1@vilsoft.co.in',recipients=>'Id2@gmail.com',subject=>'test mail',message=>'hi'); END;

*
ERROR at line 1:
ORA-29279: SMTP permanent error: 553 sorry, that domain isn't in my list of
allowed rcpthosts (#5.7.1)
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 424
ORA-06512: at "SYS.UTL_MAIL", line 594
ORA-06512: at line 1

So Please help me to resolve this error ...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 18 2012
Added on Dec 21 2011
2 comments
412 views