2 Replies Latest reply: Dec 21, 2011 5:33 AM by user396453 RSS

    That domain isn't in my list of allowed rcpthosts (#5.7.1)

    user396453
      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 ...

      Edited by: 901580 on Dec 21, 2011 2:42 AM