{"id":764,"date":"2019-04-09T15:13:23","date_gmt":"2019-04-09T18:13:23","guid":{"rendered":"http:\/\/rodrigosilvaesilva.com.br\/?p=764"},"modified":"2019-04-09T15:13:23","modified_gmt":"2019-04-09T18:13:23","slug":"ora-30554-function-based-index-xdb-xdbacl_xidx-is-disabled","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2019\/04\/09\/ora-30554-function-based-index-xdb-xdbacl_xidx-is-disabled\/","title":{"rendered":"ORA-30554: function-based index XDB.XDB$ACL_XIDX is disabled"},"content":{"rendered":"<p>Erro ao criar ACL<\/p>\n<pre class=\"lang:plsql decode:true\">begin\n  DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(\n    acl =&gt; 'acl_http.xml',\n    description =&gt; 'Allow acl_viacep',\n    principal =&gt; 'CPD',\n    is_grant =&gt; true,\n    privilege =&gt; 'connect'\n    );\n\n  dbms_network_acl_admin.add_privilege (\n  acl =&gt; 'acl_http.xml',\n  principal =&gt; 'CPD',\n  is_grant =&gt; true,\n  privilege =&gt; 'resolve'\n  );\n\n  dbms_network_acl_admin.assign_acl(\n  acl  =&gt; 'acl_http.xml',\n  host =&gt; 'serasa.com.br'\n  );\n  commit;\nend;\n\/<\/pre>\n<p>Erro<\/p>\n<pre class=\"lang:plsql decode:true \">ORA-30554: function-based index XDB.XDB$ACL_XIDX is disabled\nORA-06512: at \"SYS.DBMS_NETWORK_ACL_ADMIN\", line 258\nORA-06512: at line 2<\/pre>\n<p>Consultando index<\/p>\n<pre class=\"lang:plsql decode:true\">column owner format a12;\ncolumn index_name format a18;\ncolumn status format a10;\ncolumn domidx_status format a10;\ncolumn domidx_opstatus format a10;\ncolumn funcidx_status format a10;\n\n\nSQL&gt; select owner, index_name, status, domidx_status, domidx_opstatus,funcidx_status from dba_indexes where domidx_opstatus is not null;\n\nOWNER        INDEX_NAME         STATUS     DOMIDX_STA DOMIDX_OPS FUNCIDX_ST\n------------ ------------------ ---------- ---------- ---------- ----------\nXDB          XDBHI_IDX          VALID      VALID      VALID      ENABLED\nXDB          XDB$ACL_XIDX       VALID      VALID      VALID      DISABLED<\/pre>\n<p>Recompilando Index<\/p>\n<pre class=\"lang:plsql decode:true \">SQL&gt;alter index XDB.XDB$ACL_XIDX rebuild;\n\nIndex altered.<\/pre>\n<pre class=\"lang:plsql decode:true \">SQL&gt; select owner, index_name, status, domidx_status, domidx_opstatus,funcidx_status from dba_indexes where domidx_opstatus is not null;\n\nOWNER        INDEX_NAME         STATUS     DOMIDX_STA DOMIDX_OPS FUNCIDX_ST\n------------ ------------------ ---------- ---------- ---------- ----------\nXDB          XDBHI_IDX          VALID      VALID      VALID      ENABLED\nXDB          XDB$ACL_XIDX       VALID      VALID      VALID      ENABLED\n             \n<\/pre>\n<p>Resolvido!<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Erro ao criar ACL begin DBMS_NETWORK_ACL_ADMIN.CREATE_ACL( acl =&gt; &#8216;acl_http.xml&#8217;, description =&gt; &#8216;Allow acl_viacep&#8217;, principal =&gt; &#8216;CPD&#8217;, is_grant =&gt; true, privilege =&gt; &#8216;connect&#8217; ); dbms_network_acl_admin.add_privilege ( acl =&gt; &#8216;acl_http.xml&#8217;, principal =&gt; &#8216;CPD&#8217;, is_grant =&gt; true, privilege =&gt; &#8216;resolve&#8217; ); dbms_network_acl_admin.assign_acl( acl =&gt; &#8216;acl_http.xml&#8217;, host =&gt; &#8216;serasa.com.br&#8217; ); commit; end; \/ Erro ORA-30554: function-based index XDB.XDB$ACL_XIDX is&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[252,253,254],"class_list":["post-764","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-ora-30554-ora-06512-ora-06512","tag-ora-30554-function-based-index-index_name-is-disabled","tag-ora-30554-function-based-index-xdb-xdbacl_xidx-is-disabled"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/764","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=764"}],"version-history":[{"count":0,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/764\/revisions"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=764"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=764"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=764"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}