{"id":2317,"date":"2019-05-17T10:57:28","date_gmt":"2019-05-17T13:57:28","guid":{"rendered":"https:\/\/zmsolution.laraclaud.com.br\/?p=2317"},"modified":"2019-05-17T10:57:28","modified_gmt":"2019-05-17T13:57:28","slug":"erro-ora-25226-apos-import-com-impdp","status":"publish","type":"post","link":"http:\/\/zmsolution.com\/erro-ora-25226-apos-import-com-impdp\/","title":{"rendered":"Erro ORA-25226 ap\u00f3s import com impdp"},"content":{"rendered":"<p>As vezes realizamos o import de um sistema que possui queue, normalmente ap\u00f3s o import ocorre o seguinte erro:\u00a0<strong>ORA-25226 dequeue failed queue not enabled for dequeue<\/strong>, para solucionar esse erro \u00e9 bem simples, apos o import habilite novamente as queues. segue o comando abaixo:<\/p>\n<pre class=\"lang:default decode:true \">select para verificar a\u00a0QUEUE\r\n\r\nSQL&gt; select OWNER,NAME,QUEUE_TABLE,ENQUEUE_ENABLED,DEQUEUE_ENABLED from dba_queues where NAME='EVENT_QUEUE';\r\n\r\nOWNER NAME\r\n------------------------------ ------------------------------\r\nQUEUE_TABLE ENQUEUE DEQUEUE\r\n------------------------------ ------- -------\r\nSTRMADMIN EVENT_QUEUE\r\nEVENT_QUEUE_TAB NO NO\r\n\r\nexecute o comando com sys para habilitar a\u00a0queue\r\n\r\nEXECUTE DBMS_AQADM.start_queue (queue_name =&gt; 'strmadmin.event_queue',enqueue=&gt; TRUE,dequeue=&gt; TRUE);<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As vezes realizamos o import de um sistema que possui queue, normalmente ap\u00f3s o import ocorre o seguinte erro:\u00a0ORA-25226 dequeue failed queue not enabled for dequeue, para solucionar esse erro \u00e9 bem simples, apos o import habilite novamente as queues. segue o comando abaixo: select para verificar a\u00a0QUEUE SQL&gt; select OWNER,NAME,QUEUE_TABLE,ENQUEUE_ENABLED,DEQUEUE_ENABLED from dba_queues where NAME=&#8217;EVENT_QUEUE&#8217;; OWNER NAME &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; QUEUE_TABLE ENQUEUE DEQUEUE &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; &#8212;&#8212;- &#8212;&#8212;- STRMADMIN EVENT_QUEUE EVENT_QUEUE_TAB NO NO execute o comando com sys[&#8230;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[21,20,18,19,23],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts\/2317"}],"collection":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/comments?post=2317"}],"version-history":[{"count":0,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts\/2317\/revisions"}],"wp:attachment":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/media?parent=2317"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/categories?post=2317"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/tags?post=2317"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}