Friday 24 September 2021

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

To solve this issue run below as a sys user



 begin

DBMS_NETWORK_ACL_ADMIN.DROP_ACL('/sys/acls/OracleEBS.xml');

commit;

end;

 /

begin

DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('/sys/acls/OracleEBS.xml','ACL description', 'APPS', TRUE, 'connect');

DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE('/sys/acls/OracleEBS.xml','APPS', TRUE, 'resolve');

DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE('/sys/acls/OracleEBS.xml','APPS', TRUE, 'connect');

DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('/sys/acls/OracleEBS.xml','*');

commit;

END;

 /


No comments:

Post a Comment

Number of Visitors