OCP Blog
Super DBA
ORA-20222: ORA-24247: network access denied by access control list (ACL)
by Vazha Mantua Tuesday, February 21, 2012 1:14 PM

Good day all,

Let see a issue which appear after migration database from 10g to 11gR2

When executing DBMS_LDAP, UTL_INADDR (or) UTL_HTTP (or) any UTL packages after upgrading to 11gR1, fails with following error.

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

Cause of error is new security measure is introduced in Oracle 11g  for the following network-related PL/SQL packages: UTL_TCP, UTL_HTTP, UTL_SMTP, UTL_MAIL,  UTL_INADDR, DBMS_LDAP.By default, the ports are blocked.

We find Solution:

BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(
acl => 'http_service.xml',
description => 'HTTP ACL',
principal => 'SCOTT',
is_grant => true,
privilege => 'connect');

DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(
acl => 'http_service.xml',
principal => 'SCOTT',
is_grant => true,
privilege => 'resolve');

DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(
acl => 'http_service.xml',
host => '*');
COMMIT;
END;

In our case user SCOTT has a privileges use http_service. If you want to open port for specific host on assign_acl part use direct IP instead of ‘*”

Comments (3) -

5/12/2012 8:49:54 PM #

Firefighter Challenge Coins


Hi there, Its really very hard to stay at home having no job. The information's given above are very helpful in getting the job. keep it up man

Firefighter Challenge Coins United States

6/6/2012 7:03:13 AM #

Iraqi Dinar

I used to be very happy to find this web-site.I wanted to thanks to your time for this wonderful learn!! I definitely enjoying each little bit of it and I have you bookmarked to check out new stuff you blog post.

Iraqi Dinar United Kingdom

6/22/2012 12:55:31 AM #

Challenge Coins

Thanks for sharing. I hope it will be helpful to many people that are searching for this topic. Keep posting guys and keep this forum a great place to learn things.

Challenge Coins United States

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Filter by APML

Calendar

<<  October 2017  >>
MoTuWeThFrSaSu
2526272829301
2345678
9101112131415
16171819202122
23242526272829
303112345

View posts in large calendar

TextBox