ORA-31003 Tips

Question:  I am getting this ORA-31003 error with a ORA-06512 error:

ORA-31003: Parent /sys/acls/File_name.xml already contains child entry

How do I resolve this ORA-31003 error?

Answer:  The oerr utility show this for the error, an attempt to insert a duplicate child entry:

ORA-31003: Parent %s already contains child entry %s

Cause: An attempt was made to insert a duplicate child into the XDB hierarchical resolver.

Action: Insert a unique name into the container.

The solution is easy, just execute dbms_network_acl drop_acl procedure:

exec dbms_network_acl_admin.drop_acl('/u01/sys/acls/myfile_name.xml');
commit;

Re-execute script