{"id":2314,"date":"2019-05-13T10:36:59","date_gmt":"2019-05-13T13:36:59","guid":{"rendered":"https:\/\/zmsolution.laraclaud.com.br\/?p=2314"},"modified":"2019-05-13T10:36:59","modified_gmt":"2019-05-13T13:36:59","slug":"ora-31623-job-is-not-attached-to-this-session-via-the-specified-handle","status":"publish","type":"post","link":"http:\/\/zmsolution.com\/ora-31623-job-is-not-attached-to-this-session-via-the-specified-handle\/","title":{"rendered":"ORA-31623: a job is not attached to this session via the specified handle"},"content":{"rendered":"<p>O erro\u00a0<strong>ORA-31623<\/strong> ocorre algumas vezes na hora de executar um <strong>expdp<\/strong>, isso ocorre devido o parametro\u00a0<strong>streams_pool_size<\/strong> est\u00e1 com o valor 0<\/p>\n<p>Vamos corrigir o problema.<\/p>\n<pre class=\"lang:default decode:true \">[oraclezm@zmdb1~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.4.0 Production on Sun May 12 17:11:42 2019\r\n\r\nCopyright (c) 1982, 2013, Oracle. All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\r\nData Mining and Real Application Testing options\r\n\r\nSQL&gt; show parameter stream\r\n\r\nNAME TYPE\r\n------------------------------------ --------------------------------\r\nVALUE\r\n------------------------------\r\nstreams_pool_size big integer\r\n0\r\nSQL&gt; alter system set streams_pool_size=64M scope=both;\r\nalter system set streams_pool_size=64M scope=both\r\n*\r\nERROR at line 1:\r\nORA-32001: write to SPFILE requested but no SPFILE is in use\r\n\r\n\r\nSQL&gt; alter system set streams_pool_size=64M scope=memory;\r\n\r\nSystem altered.\r\n\r\nSQL&gt;<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>O erro\u00a0ORA-31623 ocorre algumas vezes na hora de executar um expdp, isso ocorre devido o parametro\u00a0streams_pool_size est\u00e1 com o valor 0 Vamos corrigir o problema. [oraclezm@zmdb1~]$ sqlplus \/ as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Sun May 12 17:11:42 2019 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 &#8211; 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application[&#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],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts\/2314"}],"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=2314"}],"version-history":[{"count":0,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts\/2314\/revisions"}],"wp:attachment":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/media?parent=2314"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/categories?post=2314"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/tags?post=2314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}