var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Network acls problem on 11g
a user wanted to use utl_inaddr.get_host_name but got an error regarding network acl permissions, so I tried granting them as such:
4 'SOMEUSER', TRUE, 'connect');
5 DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('somename.xml',' *');
But I keep getting this response:
ERROR at line 1:
ORA-31003: Parent /sys/acls/ already contains child entry somename.xml
ORA-06512: at "XDB.DBMS_XDB", line 192
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 195
ORA-06512: at line 2
However, I cannot see this when I do
SQL> select * from dba_network_acls;
no rows selected
I've tried reading the docs here http://download.oracle.com/docs/cd/B...n.htm#BABJJBJI
but haven't figured this out yet. I tried the dba how to see network acls thing but that also returned no rows.
I don't understand why I can't create this acl and also cannot see it.
Can anyone point me in the right direction?