I had to recently drop an ACL and then add it back. I"m now having two issues. If I try adding the existing one (meaning using the same name), it tells me it already exists, but I have deleted it. If I use a new name, I then get a ivnalid resource configuration list.
If I run the following two queries, no data is returned:
SELECT *
FROM dba_network_acls
order by host;
SELECT acl,
principal,
privilege,
is_grant,
TO_CHAR(start_date, 'DD-MON-YYYY') AS start_date,
TO_CHAR(end_date, 'DD-MON-YYYY') AS end_date,
privilege
FROM dba_network_acl_privileges;
BTW, I've never had this problem in the past and everything has always worked fine.
I can run the following two PL/SQL blocks and everything works fine:
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (
acl => 'oracleflash2.xml',
description => 'Permissions to access http://www.oracleflash.com',
principal => 'SCOTT',
is_grant => TRUE,
privilege => 'connect');
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE (
acl => 'oracleflash2.xml',
principal => 'SCOTT',
is_grant => TRUE,
privilege => 'connect',
position => null);
COMMIT;
END;
/
When I run the following query below I get the following error message:
BEGIN
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
acl => 'oracleflash2.xml',
host => '*.oracleflash.com');
COMMIT;
END;
/
Error at line 1
ORA-01001: invalid cursor
ORA-31139: Invalid resource configuration list
ORA-06512: at line 31
The actual error happens with the COMMIT. If I remove the commit, everything seems to have worked properly.
I am completely stumped on this issue. Anyone seen this issue and know how to resolve? How can I verify that the first PL/SQL block worked properly where it creates the ACL and then assigns a privilege?
Appreciate it help.
--Cam--