重庆思庄Oracle、Redhat认证学习论坛

标题: 数据库创建组件时报错ORA-30554: XDB.XDB$ACL_XIDX is disabled [打印本页]

作者: 刘泽宇 时间: 2022-4-2 10:13
标题: 数据库创建组件时报错ORA-30554: XDB.XDB$ACL_XIDX is disabled
现象：

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.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)