ORA-30554: XDB.XDB$ACL_XIDX is disabled

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Creation of ACL with DBMS_NETWORK_ACL_ADMIN.CREATE_ACL is failing with error:

ORA-30554: function-based index XDB.XDB$ACL_XIDX is disabled
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 252
ORA-06512: at line 2

 

Cause

Functional Index XDB$ACL_XIDX is disabled.So its causing error ORA-30554.

SQL> select owner, index_name, index_type,
  2  table_owner, table_name, status,
  3  funcidx_status
  4  from dba_indexes
  5  where index_name = 'XDB$ACL_XIDX';

OWNER                INDEX_NAME                     INDEX_TYPE                                      
-------------------- ------------------------------ ---------------------------                     
TABLE_OWNER                    TABLE_NAME                     STATUS   FUNCIDX_                     
------------------------------ ------------------------------ -------- --------                     
XDB                  XDB$ACL_XIDX                   FUNCTION-BASED DOMAIN                           
XDB                            XDB$ACL                        VALID    DISABLED

 

Solution

Enable the Functional index XDB.XDB$ACL_XIDX.

SQL> conn / as sysdba
SQL> alter index xdb.XDB$ACL_XIDX enable;

Run the DBMS_NETWORK_ACL_ADMIN.CREATE_ACL again.