| Network acls problem on 11g [message #302690] |
Tue, 26 February 2008 11:27  |
humbletech99
Messages: 4
Registered: February 2008
|
Junior Member |
|
|
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:
SQL> begin
2 DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('somename.xml',
3 'somecomment',
4 'SOMEUSER', TRUE, 'connect');
5 DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('somename.xml','*');
6 end;
7 /
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/B28359_01/network.111/b28531/authorization.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?
|
|
|
|
|
|
| Re: Network acls problem on 11g [message #302852 is a reply to message #302690] |
Wed, 27 February 2008 03:11  |
humbletech99
Messages: 4
Registered: February 2008
|
Junior Member |
|
|
I already found the ORA error on google before posting but I don't fully understand how I can see this, I did the above mentioned select against dba_network_acls but it returned no rows so I'm a bit stumped. I must be looking at the wrong thing.
It also doesn't help that my company refuses to send me on all the courses I want to go on, probably means I'll be forced to change to a better company... I've never seen this network acl thing before or had any education on 11g... so apologies for any cluelessness here.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
