现象：

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

问题原因：

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

处理方法：

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.

ITPub博客

数据库创建组件时报错ORA-30554: XDB.XDB$ACL_XIDX is disabled