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