How to resolve ORA-31001 for dbms_network_acl_admin.create_acl on Windows
702674Jun 5 2009 — edited Jun 5 2009Hi:
I am using 11gR1 on Windows Server 2003, and trying to setup XMLDB web services and got ora-31001. I Did :
begin
DBMS_NETWORK_ACL_ADMIN.DROP_ACL('localhost.xml');
dbms_network_acl_admin.create_acl(
acl => 'localhost.xml'
,description => 'ACL for 127.0.0.1'
,principal => 'myname'
,is_grant => true
,privilege => 'connect');
dbms_network_acl_admin.assign_acl('localhost.xml', '127.0.0.1');
end;
/
And got following errors:
ORA-31001: Invalid resource handle or path name "/sys/acls/localhost.xml"
ORA-06512: at "XDB.DBMS_XDB", line 331
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 392
ORA-06512: at line 2
It seems to be complaining about the default directory “/sys/acls”. How do I do it in Windows? It does not help even if I created a "c:\sys\acls"
Thanks in advnace for your help,
Richard