Erro ao criar ACL
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
begin DBMS_NETWORK_ACL_ADMIN.CREATE_ACL( acl => 'acl_http.xml', description => 'Allow acl_viacep', principal => 'CPD', is_grant => true, privilege => 'connect' ); dbms_network_acl_admin.add_privilege ( acl => 'acl_http.xml', principal => 'CPD', is_grant => true, privilege => 'resolve' ); dbms_network_acl_admin.assign_acl( acl => 'acl_http.xml', host => 'serasa.com.br' ); commit; end; / |
Erro
|
1 2 3 |
ORA-30554: function-based index XDB.XDB$ACL_XIDX is disabled ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 258 ORA-06512: at line 2 |
Consultando index
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
column owner format a12; column index_name format a18; column status format a10; column domidx_status format a10; column domidx_opstatus format a10; column funcidx_status format a10; SQL> select owner, index_name, status, domidx_status, domidx_opstatus,funcidx_status from dba_indexes where domidx_opstatus is not null; OWNER INDEX_NAME STATUS DOMIDX_STA DOMIDX_OPS FUNCIDX_ST ------------ ------------------ ---------- ---------- ---------- ---------- XDB XDBHI_IDX VALID VALID VALID ENABLED XDB XDB$ACL_XIDX VALID VALID VALID DISABLED |
Recompilando Index
|
1 2 3 |
SQL>alter index XDB.XDB$ACL_XIDX rebuild; Index altered. |
|
1 2 3 4 5 6 |
SQL> select owner, index_name, status, domidx_status, domidx_opstatus,funcidx_status from dba_indexes where domidx_opstatus is not null; OWNER INDEX_NAME STATUS DOMIDX_STA DOMIDX_OPS FUNCIDX_ST ------------ ------------------ ---------- ---------- ---------- ---------- XDB XDBHI_IDX VALID VALID VALID ENABLED XDB XDB$ACL_XIDX VALID VALID VALID ENABLED |
Resolvido!