Dangling References In DBA_NETWORK_ACL_PRIVILEGES When Using RCU To Drop The PORTAL Schema (Doc ID 855814.1)

Last updated on OCTOBER 03, 2022

Applies to:

Symptoms

After dropping a PORTAL schema in the repository using RCU, some dangling privileges are still in place and breaks a new PORTAL install.

Step to reproduce:

1. Run RCU against a database and install the Portal repository with schema CRASH_PORTAL
2. Once installed, run RCU again and drop the CRASH_PORTAL
3. Rerun the RCU and install Portal again as NEW_PORTAL.
   This fails with the error below reported in portal.log:

checkinstall2=Add ACL for network packages if DB is 11.1 or higher...
old 4: schema varchar2(2000) := upper('&&1');
new 4: schema varchar2(2000) := upper('NEW_PORTAL');
Package DBMS_NETWORK_ACL_ADMIN exists, assign ACL if not already assigned
Removing dangling principals,if any from the ACL privilege list ...
ERROR: when assigning network ACL
declare
 *
ERROR at line 1:
ORA-24246: empty access control list (ACL) not allowed
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 421
ORA-06512: at line 1
ORA-01403: no data found
ORA-06512: at line 83

Changes

This issue occurs when dropping the unique Portal schema in the database and trying to install it new.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.