PL/SQL (MOSC)

MOSC Banner

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

edited Jul 11, 2011 2:08AM in PL/SQL (MOSC) 3 commentsAnswered
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production 
When I run "select utl_http.request('http://www.tiger.com') from dual;"   I get the above error. 


I ran this query:
SELECT a.HOST
     , a.lower_port
     , a.upper_port
     , a.acl
     , principal
     , PRIVILEGE
     , is_grant
     , start_date
     , end_date
FROM   dba_network_acls a
     , dba_network_acl_privileges b
WHERE  a.acl = b.acl

The only null values are the ports and dates. 

host = *.xxx.com  (xxx is valid for our company)
acl =  /sys/acls/XXXDefault.xml
principal = valid schema
privilege = resolve/connect.
is_grant = true.

Thanks

Andy

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center