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

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


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





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 => ‘’, lower_port => 1, upper_port => 1000);



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


    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

Don Charisma

because anything is possible with Charisma

Carol no Mundo!

Aventuras de uma intercambista a trabalho pelo mundo!

Blog do PHP

Oracle DBA for rookies!


Welcome to the world of Oracle with me....


News and reviews from the world of gadgets, gear, apps and the web


WordPress.com is the best place for your personal blog or business site.

Gurcan Orhan's ODI and DWH Blog

Some words about Oracle Data Integrator and Data Warehousing.

%d bloggers like this: