Dangling References In DBA_NETWORK_ACL_PRIVILEGES When Using RCU To Drop The PORTAL Schema

(Doc ID 855814.1)

Last updated on JUNE 01, 2018

Applies to:

Portal - Version to [Release 10gR2 to FMW11g]
Information in this document applies to any platform.
Checked for relevance on 21-Oct-2013


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.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms