Tag: ORA-31003/ORA-06512

Oracle Error : ORA-31003/ORA-06512

Posted on by Osama Mustafa in Database
The Below Error Appear when you are trying to use dbms_network_acl_admin

ORA-31003: Parent /sys/acls/File_name.xml already contains child entry
ORA-06512: at “SYS.DBMS_NETWORK_ACL_ADMIN”, line 226
ORA-06512: at line 30
ORA-01403: no data found

The Solution Is Simple

exec dbms_network_acl_admin.drop_acl(‘/sys/acls/file_name.xml’);
Commit
Re-Run Script Again.

Thank you
Osama Mustafa