Home » RDBMS Server » Server Administration » Network acls problem on 11g
Network acls problem on 11g [message #302690] Tue, 26 February 2008 11:27 Go to next message
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 #302752 is a reply to message #302690] Tue, 26 February 2008 22:38 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

check it
http://www.error-code.org.uk/view.asp?e=ORACLE-ORA-31003

hope this helps
Re: Network acls problem on 11g [message #302852 is a reply to message #302690] Wed, 27 February 2008 03:11 Go to previous message
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.
Previous Topic: How to find database status
Next Topic: Oracle 8.1.5 to 8.1.6
Goto Forum:
  


Current Time: Mon Dec 05 19:28:40 CST 2016

Total time taken to generate the page: 0.10805 seconds