My Oracle Support Banner

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:

Portal - Version to [Release 10gR2 to FMW11g]
Information in this document applies to any platform.


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
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



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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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