Oracle Error : ORA-31003/ORA-06512

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

One thought on “Oracle Error : ORA-31003/ORA-06512

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.