Posts

Showing posts from November, 2012

Error occurs when sending email from database 11g triiger

We had 9i database and we migrated to 11g. one of the problems that occurred was   executing the "demo_mail" package that sends emails. The problem Sending mail via UTL_TCP and UTL_SMTP failes ERROR at line 1: ORA-24247: network access denied by access control list (ACL) ORA-06512: at "SYS.UTL_TCP" , line 17 ORA-06512: at "SYS.UTL_TCP" , line 246 ORA-06512: at "SYS.UTL_SMTP" , line 115  Cause : The Database user which execute the demo_mail package is not authorized to open connection and send a mail. Solution : suppose that the user executes the package is "Scott" and  smtp_host is " email2.dhaman.org" SQL> EXECUTE DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => 'send_mail.xml',description => 'send_mail ACL',principal => 'scott',is_grant => true,privilege => 'connect'); PL/SQL procedure successfully completed. SQL> EXECUTE DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl