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
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
