{"id":622,"date":"2012-12-25T15:23:20","date_gmt":"2012-12-25T12:23:20","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=622"},"modified":"2012-12-25T15:27:33","modified_gmt":"2012-12-25T12:27:33","slug":"acl-error-solution-in-oracle-11g","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/acl-error-solution-in-oracle-11g\/","title":{"rendered":"ACL Error Solution in Oracle 11g"},"content":{"rendered":"

Oracle 11g have been used ACL procedure to send smtp e-mail. Default configuration can not send e-mail. You have to create below procedures for complete smtp configuration.<\/p>\n

I used CONNUSER as ACL connection user and 100.10.10.11 IP address as mail server IP and NOTIFYUSER as user for notification for configuration. You can change this users or IP address.<\/p>\n

Create ACL MailServer<\/strong><\/p>\n

\nSQL> create or replace procedure mailserver_acl(
\naacl varchar2,
\nacomment varchar2,
\naprincipal varchar2,
\naisgrant boolean,
\naprivilege varchar2,
\naserver varchar2,
\naport number)
\nis
\nbegin
\nbegin
\nDBMS_NETWORK_ACL_ADMIN.DROP_ACL(aacl);
\ndbms_output.put_line(‘ACL dropped…..’);
\nexception
\nwhen others then
\ndbms_output.put_line(‘Error dropping ACL: ‘||aacl);
\ndbms_output.put_line(sqlerrm);
\nend;
\nbegin
\nDBMS_NETWORK_ACL_ADMIN.CREATE_ACL(aacl,acomment,aprincipal,aisgrant,aprivilege);
\ndbms_output.put_line(‘ACL created…..’);
\nexception
\nwhen others then
\ndbms_output.put_line(‘Error creating ACL: ‘||aacl);
\ndbms_output.put_line(sqlerrm);
\nend;
\nbegin
\nDBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(aacl,aserver,aport);
\ndbms_output.put_line(‘ACL assigned…..’);
\nexception
\nwhen others then
\ndbms_output.put_line(‘Error assigning ACL: ‘||aacl);
\ndbms_output.put_line(sqlerrm);
\nend;
\ncommit;
\ndbms_output.put_line(‘ACL commited…..’);
\nend;<\/p>\n

Procedure created.
\n\/<\/p><\/blockquote>\n

Create ACL Connection<\/strong><\/p>\n

\nSQL> begin
\nmailserver_acl(
\n‘mailserver_acl.xml’,
\n‘ACL for used Email Server to connect’,
\n‘CONNUSER’,<\/strong>
\nTRUE,
\n‘connect’,
\n‘100.10.10.11’,<\/strong>
\n25);
\nend;<\/p>\n

PL\/SQL procedure successfully completed.
\n\/<\/p><\/blockquote>\n

Add User to ACL Privilage<\/strong><\/p>\n

SQL> begin
\nDBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(‘mailserver_acl.xml’,’NOTIFYUSER<\/strong>‘,TRUE,’connect’);
\ncommit;
\nend;
\n\/<\/p>\n

PL\/SQL procedure successfully completed.<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g have been used ACL procedure to send smtp e-mail. Default configuration can not send e-mail. You have to create below procedures for complete smtp configuration. I used CONNUSER as ACL connection user and 100.10.10.11 IP address as mail server IP and NOTIFYUSER as user for notification for configuration. You can change this users…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[9,12],"tags":[14,90,32],"class_list":["post-622","post","type-post","status-publish","format-standard","hentry","category-administration","category-oracle-procedure","tag-database-administration","tag-oracle","tag-oracle-administration"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-a2","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/622","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=622"}],"version-history":[{"count":6,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/622\/revisions"}],"predecessor-version":[{"id":628,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/622\/revisions\/628"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=622"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=622"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=622"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}