Home > problem-cause-solution > ORA-24247: network access denied by access control list (ACL)

ORA-24247: network access denied by access control list (ACL)


Problem:

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 127
ORA-06512: at “SYS.UTL_SMTP”, line 150
ORA-06512: at “GEOPP.SEND_MAIL”, line 240
ORA-06512: at “GEOPP.SEND_MAIL”, line 118
ORA-06512: at “GEOPP.GEOPP_ALARM_MAIL”, line 115
ORA-06512: at line 1

Cause:

Solution:

http://www.oracle-base.com/articles/11g/FineGrainedAccessToNetworkServices_11gR1.php

begin

dbms_network_acl_admin.create_acl ( acl => ‘utlpkg.xml’, description => ‘Normal Access’, principal => ‘GEOPP’, is_grant => TRUE, privilege => ‘connect’, start_date => null, end_date => null );

dbms_network_acl_admin.assign_acl ( acl => ‘utlpkg.xml’, host => ‘10.200.123.135’, lower_port => 1, upper_port => 1000);

commit;

end;
/

About these ads
Categories: problem-cause-solution Tags: ,
  1. Abhishek Sarkar
    November 1, 2010 at 4:19 am

    Thanks,

    It help me lot.

  2. Mr N
    July 11, 2012 at 9:54 am

    thank you very much. I research it for 5 days. my problem was sloved

  3. Nelz
    August 26, 2012 at 7:57 pm

    what do you use to enter the code? I’ve tried sql plus and sql command line but it’s not working

    • deryaoktay
      August 26, 2012 at 10:22 pm

      You may get error messages because of single quotes in varchar2 dataype parameters. I guess while copy pasteing them from editor to wordpress they are changed.
      As far as I remember, I had executed the anonymous plsql block from Toad editor.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 36 other followers

%d bloggers like this: