{"id":515,"date":"2021-11-26T10:10:09","date_gmt":"2021-11-26T09:10:09","guid":{"rendered":"https:\/\/anjo.pt\/keyword-oracle\/?p=515"},"modified":"2021-11-26T10:10:11","modified_gmt":"2021-11-26T09:10:11","slug":"datapatch-and-tablespace-full","status":"publish","type":"post","link":"https:\/\/anjo.pt\/keyword-oracle\/2021\/11\/26\/datapatch-and-tablespace-full\/","title":{"rendered":"Datapatch and Tablespace Full"},"content":{"rendered":"\n<p>Yesterday on a simple 19.13 patching session, got a nice error during datapatch: ORA-01691: usable to extend lob segment in Tablespace SYSTEM ! Got a bit scared, but simple added more space to the tablespace, run datapatch again and all was ok. Maybe patch\/datapatch should check also for free space in the SYSTEM Tablespace ?<\/p>\n\n\n\n<p>Here the error:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nDBD::Oracle::st execute failed: ORA-01691: unable to extend lob segment SYS.SYS_LOB0000323098C00008$$ by 128 in tablespace SYSTEM\nORA-06512: at line 2 (DBD ERROR: OCIStmtExecute) &#x5B;for Statement &quot;BEGIN\n           INSERT INTO sys.dba_registry_sqlpatch_ru_info\n             (patch_id,\n              patch_uid,\n              patch_descriptor,\n              ru_version,\n              ru_build_description,\n              ru_build_timestamp,\n              patch_directory)\n           VALUES\n             (:patch_id,\n              :patch_uid,\n              :patch_descriptor,\n              :ru_version,\n              :ru_build_description,\n              TO_TIMESTAMP(:ru_build_timestamp, &#039;YYMMDDHH24MISS&#039;),\n              :patch_directory);\n           COMMIT;\n         END;&quot; with ParamValues: :patch_descriptor=OCIXMLTypePtr=SCALAR(0x468b0a0), :patch_directory=&#039;PK........\u2592LOS\u2592.\n\u2592. ..\u2592&#x5B;..\n...33192793.xml\u2592]&#x5B;.\u06f8.~..\n\u2592.v\u2592\u2592\u2592.x.\u2592\u2592q*.o\u2592\u2592*.&#039;s\u2592\u2592\u2592(.-qL\u2592l.ji\u2592\u2592\/@Im        8 .$.I\u2592&amp;lt;\u25920j\u2592.&gt;\\.\u2592.\u2592~.\u2592\u2592\u2592K\u2592vE\u2592\u2592\u2592.~K..\u25926\u2592\u2592b\u2592\u2592\u2592a\u2592?=F.\u2592..\u2592]\u2592\\\u25925\u2592\u2592\u2592\u2592.?|\u2592\u2592y4f\u2592\u2592{X\u2592\u2592\u2592..\u2592&quot;\u2592\u2592|?d.\u2592..I\u2592.E.\u2592\u2592\u2592\u2592=\u2592\u2592\u2592\u2592\u2592..\u2592\u2592\u2592.\u2592\u25925.Wg\u2592w.\u06fa\u2592..\u2592v}Q%}.\u2592..\u2592\u2592.\u2592\u2592.-\u2592\u2592\u2592\u2592\u2592\\%\u2592\u2592\u05ff\u2592vE.\u2592\u2592xsU\u2592\u2592)%\u0127a@.r\u2592\u2592.\u2592K\u06e2\u2592.\u2592}..y\u2592\u2592.~j2\u2592\u2592\u00e2.=\u2592\u2592\u2592.\u2592\u2592\u2592O.\u2592\u2592&amp;lt;\u2592wm\u2592\u2592\u2592d\u2592.\u2592vw\u2592\u2592\u2592\u2592....\u2592o\u07bc.\u2592}\u2592\u2592\u2592.I.\u2592x\u2592.\u2592\u2592.\u2592\u2592\u2592\u2592.\u2592\u2592.\u2592x\u2592o\u2592)\u2592\u2592wo.vx\u06ff{|\\\u2592,.i]5\u25926\u2592\u2592..\u2592\u2592.b.g\u2592b\u2592\u25927Ew\u2592\u2592\u2592\u2592.\/\u2592.\u2592\u2592o.\u2592\/\u2592.\u2592.\u2592\u25926\u2592#\u2592.\u2592.\u2592...\u2592\u2592..\u2592\u2592\u2592\u2592\u07f5\u2592l\u2592\u2592\u2592\u2592...\u2592\u2592.\u2592.\u2592\u2592.a(\u2592.\u2592?|\u2592.\u2592\nX\u2592\u2592{+\u2592\u2592v\u2592=.\u2592{\u2592\u2592\u2592\u25929\u00cdui\u2592\u2592.H.\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592S.\u2592^\u2592|\u25929.\u2592%\u2592,\u2592\u2592\u2592SU\u2592.\u2592. zZ.\u2592..c;.\u2592v\u062dY\u2592B...\u2592\u2592\u2592\u2592\/\u2592\u2592.\u2592\u2592\u2592\u2592.\u2592\u2592\u2592..H{.7}f.\u2592..\u2592j.\u2592m\u06ff\u2592.\u2592S.\u25927\u2592.:\u00a7.\u2592+p\u2592%\u2592..w\u2592.\u2592.\u2592{7\u2592.\u2592k\u2592..\u25926\u25926\u2592\u2592&gt;v\u2592bwMU\u2592..\u2592Y_\u2592+\u2592IG\u2592&amp;lt;.|4\u2592\u2592\\\u25924.\u2592i\u2592*\u2592\u2592;G\u2592-V.\u03b5\u2592\u2592.p.\u2592\u2592\u2592\u2592\nG\u030d1\u2592.\u2592]\u2592\u2592\u2592.1O\u2592v\u2592^.\u2592\u2592\u2592.\u2592:.Wy._q7\u2592\u2592.*\u2592&amp;amp;\u2592\u2592`\/\u2592I\u07f9...pW.\n\u2592\u2592\u2592\u2592C.v\u2592j\u2592&#x5B;\u2592\u2592.\u2592\u2592~\u2592\u2592.\u2592.bo\u2592\u2592.U\u2592..\u2592V\u2592\u2592\n.`n\u2592\u2592N7\u2592.`nyup\u2592\u2592.w\u2592.]\u2592\u2592B\u2592.\u2592\u25925D7\u2592.w.#w.\u2592.\u2592m\u2592\u2592\u072c\u2592.p\u2592.3p.\u2592\u2592.\u2592.l\u2592.\u2592\u2592Z;\u25920.\\bm\u2592J\u2592...&#039;, :patch_id=&quot;33192793&quot;, :patch_uid=&quot;24462514&quot;, :ru_build_description=&quot;Release_Update&quot;, :ru_build_timestamp=&quot;211004165050&quot;, :ru_version=&quot;19.13.0.0.0&quot;] at \/u01\/oracle\/db19s\/sqlpatch\/sqlpatch.pm line 5876, &amp;lt;LOGFILE&gt; line 110.\n<\/pre><\/div>\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Yesterday on a simple 19.13 patching session, got a nice error during datapatch: ORA-01691: usable to extend lob segment in Tablespace SYSTEM ! Got a bit scared, but simple added more space to the tablespace, run datapatch again and all was ok. Maybe patch\/datapatch should check also for free space in the SYSTEM Tablespace ? [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,6,39],"tags":[],"class_list":{"0":"post-515","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-opatch","7":"category-oracle","8":"category-oracle-19c","9":"czr-hentry"},"_links":{"self":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/515","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/comments?post=515"}],"version-history":[{"count":1,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/515\/revisions"}],"predecessor-version":[{"id":516,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/515\/revisions\/516"}],"wp:attachment":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/media?parent=515"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/categories?post=515"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/tags?post=515"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}