{"id":14444,"date":"2020-04-18T15:15:57","date_gmt":"2020-04-18T15:15:57","guid":{"rendered":"https:\/\/ittutorial.org\/?p=14444"},"modified":"2020-11-12T08:21:43","modified_gmt":"2020-11-12T08:21:43","slug":"ora-12801-error-signaled-in-parallel-query-server-string","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/ora-12801-error-signaled-in-parallel-query-server-string\/","title":{"rendered":"ORA-12801: error signaled in parallel query server string"},"content":{"rendered":"<p>When I run the SQL as parallel execution using Parallel hint, I got &#8221; ORA-12801: error signaled in parallel query server string ORA-08103 &#8221; error.<\/p>\n<p><!--more--><\/p>\n<p>&nbsp;<\/p>\n<h2><span style=\"color: #ff0000;\">ORA-12801: error signaled in parallel query server string<\/span><\/h2>\n<p>Details of error are as follows.<\/p>\n<pre>SQL&gt; SELECT REPORT_DAY,count(*) FROM MEHMET.DEVECI\r\n2 GROUP BY REPORT_DAY;\r\nSELECT REPORT_DAY,count(*) FROM MEHMET.DEVECI\r\n*\r\nERROR at line 1:\r\nORA-12801: error signaled in parallel query server P00B, instance\r\nmsddb01.msd.local:MSD1 (1)\r\nORA-08103: object no longer exists\r\n\r\n<span class=\"msg\">ORA-12801: error signaled in parallel query server\u00a0<span class=\"italic\">string<\/span><\/span>\r\n\r\n<span class=\"msgexplankw\">Cause:<\/span>\u00a0A parallel query server reached an exception condition.\r\n\r\n<span class=\"msgactionkw\">Action:<\/span>\u00a0Check the following error message for the cause, and consult your error manual for the appropriate action.<\/pre>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #ff0000;\">ORA-08103: object no longer exists<\/span><\/h3>\n<p>This error is related with Partitioned table and Parallel execution on Cluster Nodes.<\/p>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<p>To solve this problem, You can run the same SQL as follows.<\/p>\n<p>set the following trace events, then run the same SQL as follows.<\/p>\n<pre><strong><span style=\"color: #ff0000;\">alter session set events '10384 trace name context forever , level 16384';<\/span><\/strong><\/pre>\n<p>&nbsp;<\/p>\n<pre>SQL&gt; alter session set events '10384 trace name context forever , level 16384';\r\n\r\nSession altered.\r\n\r\nSQL&gt; ALTER SESSION SET PARALLEL_FORCE_LOCAL=TRUE;\r\n\r\nSession altered.\r\n\r\nSQL&gt;\r\nSQL&gt; SELECT \/*+ PARALLEL(16) *\/ REPORT_DAY,count(*) FROM MEHMET.DEVECI\r\n2 GROUP BY REPORT_DAY;\r\n\r\nREPORT_D COUNT(*)\r\n-------- ----------\r\n20200101 143879088\r\n20200102 143900001\r\n20200103 143919894\r\n20200104 143939085\r\n20200105 143949689\r\n20200106 143974041\r\n20200107 143999241\r\n20200108 144019865\r\n20200109 144040582\r\n20200110 144062839\r\n20200111 144083914\r\n\r\nREPORT_D COUNT(*)\r\n-------- ----------\r\n20200112 144095191\r\n20200113 144120876\r\n20200114 144141403\r\n20200115 144167352\r\n\r\n15 rows selected.\r\n\r\nSQL&gt;<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Or To solve this error, Increase the\u00a0 sort_area_size as follows.<\/p>\n<pre>SQL&gt; show parameter sort_area\r\n\r\nNAME TYPE VALUE\r\n------------------------------------ ----------- ------------------------------\r\nsort_area_retained_size integer 0\r\nsort_area_size integer 65536\r\nSQL&gt;\r\n\r\n\r\n\r\nalter session set sort_area_size = 640000 scope=both sid='*';<\/pre>\n<p>&nbsp;<\/p>\n<h5><a href=\"https:\/\/ittutorial.org\/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba\/\"><span style=\"color: #ff0000;\">Do you want to learn Oracle Database for Beginners, then Click and read the following articles.<\/span><\/a><\/h5>\n<p><a href=\"https:\/\/ittutorial.org\/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba\/\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle Database Tutorials for Beginners ( Junior Oracle DBA )<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>When I run the SQL as parallel execution using Parallel hint, I got &#8221; ORA-12801: error signaled in parallel query server string ORA-08103 &#8221; error.<\/p>\n","protected":false},"author":1,"featured_media":6095,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[2111],"tags":[8763,8766,8765,8759,8758,8757,8756,8760,8761,8764,8762],"class_list":["post-14444","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-ora-errors","tag-activerecord-statementinvalid-ocierror-ora-12801-error-signaled-in-parallel-query-server-p000","tag-error-signaled-in-parallel-query-server-string","tag-ora-12801","tag-ora-12801-error-in-informatica","tag-ora-12801-error-signaled-in-parallel-query-server-in-informatica","tag-ora-12801-error-signaled-in-parallel-query-server-ora-01652","tag-ora-12801-error-signaled-in-parallel-query-server-ora-01722-invalid-number","tag-ora-12801-error-signaled-in-parallel-query-server-ora-08103-object-no-longer-exists","tag-ora-12801-ora-00600","tag-ora-12801-error-signaled-in-parallel-query-server-string","tag-ora-20011-approximate-ndv-failed-ora-12801-error-signaled-in-parallel-query-server-p000"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/03\/ora-error-e1494274386931.png","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/14444","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=14444"}],"version-history":[{"count":4,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/14444\/revisions"}],"predecessor-version":[{"id":32220,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/14444\/revisions\/32220"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/6095"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=14444"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=14444"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=14444"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}