{"id":45038,"date":"2026-06-11T08:55:15","date_gmt":"2026-06-11T06:55:15","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=45038"},"modified":"2026-06-11T08:55:17","modified_gmt":"2026-06-11T06:55:17","slug":"temporary-tablespace-and-oda-19-31","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/temporary-tablespace-and-oda-19-31\/","title":{"rendered":"Temporary tablespace and ODA 19.31."},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">I recently patched Oracle Database Appliances (ODAs) to 19.31. For DBs with more than 1 tempfile in the temporary tablespace I got an error during the &#8220;odacli update-dbhome&#8221; :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># odacli describe-job -i 2ff3fd5d-f611-4ae6-aae0-63df7c08ec71\n \nJob details\n----------------------------------------------------------------\n                     ID:  2ff3fd5d-f611-4ae6-aae0-63df7c08ec71\n            Description:  DB Home Patching to 19.31.0.0.0: Home ID is 1c101fd3-2ca8-55f6-9415-22ec5abc53da\n                 Status:  Failure (To view Error Correlation report, run \"odacli describe-job -i 2ff3fd5d-f611-4ae6-aae0-63df7c08ec71 --ecr\" command)\n                Created:  June 09, 2026 15:07:23 CEST\n                Message:  DCS-10001:Internal error encountered: Unable to autoextend tablespace TEMP.<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The issue is that Oracle tries to &#8220;set autoextend on&#8221; on the temporary files in 19.31., but runs a syntactically wrong command. E.g. in the alert.log I could see<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>2026-06-09T15:54:14.898088+02:00\nalter database tempfile '\/u02\/app\/oracle\/oradata\/mydbt_dc2\/MYDBT_DC2\/datafile\/o1_mf_temp_m2d4kz32_.tmp \/u02\/app\/oracle\/oradata\/mydbt_dc2\/MYDBT_DC2\/datafile\/o1_mf_temp_m2d4l3wf_.tmp' autoextend on next 100m maxsize 20g\nORA-1516 signalled during:  alter database tempfile '\/u02\/app\/oracle\/oradata\/mydbt_dc2\/MYDBT_DC2\/datafile\/o1_mf_temp_m2d4kz32_.tmp \/u02\/app\/oracle\/oradata\/mydbt_dc2\/MYDBT_DC2\/datafile\/o1_mf_temp_m2d4l3wf_.tmp' autoextend on next 100m maxsize 20g ...<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">I.e. Oracle just listed all tempfiles separated by blank in one string. This is of course wrong and produces the error.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The workaround was to&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;&#8211; create a temporary tablespace temp2<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;&#8211; make temp2 the default temporary tablespace<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;&#8211; drop temporary tablespace temp<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;&#8211; create the temporary tablespace temp with just 1 tempfile<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;&#8211; make temp the default temporary tablespace<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;&#8211; drop temporary tablespace temp2<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Then run the &#8220;odacli update-dbhome&#8221; again and it will be successful. Afterwards add your temporary files to tablespace temp again.\u00a0<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Please consider that it is not obvious in the produced errors of odacli in what DB the error happened (odacli update-dbhome patches all DBs running in the specified ORACLE_HOME). To find out what DB is affected it&#8217;s a good idea to scan the alert-logs for the error:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ find \/u01\/app\/odaorabase\/oracle\/diag\/rdbms\/*\/*\/trace -name \"alert*.log\" -exec grep -il \"ORA-1516\" {}\\;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">To proactively avoid the issue when patching to 19.31. on the ODA, I&#8217;d recommend to check your databases in advance if they have more than 1 tempfile in the temporary tablespace and implement the workaround mentioned above.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>select count(*) from dba_temp_files where tablespace_name='TEMP';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">We opened a SR with Oracle to get the issue fixed for the next release.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I recently patched Oracle Database Appliances (ODAs) to 19.31. For DBs with more than 1 tempfile in the temporary tablespace I got an error during the &#8220;odacli update-dbhome&#8221; : The issue is that Oracle tries to &#8220;set autoextend on&#8221; on the temporary files in 19.31., but runs a syntactically wrong command. E.g. in the alert.log [&hellip;]<\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[4107,2567,96,2568,4106,2646],"type_dbi":[],"class_list":["post-45038","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-autoextend","tag-oda-2","tag-oracle","tag-oracle-database-appliance-2","tag-tempfile","tag-temporary-tablespace"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.8 (Yoast SEO v27.8) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Temporary tablespace and ODA 19.31. - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/temporary-tablespace-and-oda-19-31\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Temporary tablespace and ODA 19.31.\" \/>\n<meta property=\"og:description\" content=\"I recently patched Oracle Database Appliances (ODAs) to 19.31. For DBs with more than 1 tempfile in the temporary tablespace I got an error during the &#8220;odacli update-dbhome&#8221; : The issue is that Oracle tries to &#8220;set autoextend on&#8221; on the temporary files in 19.31., but runs a syntactically wrong command. E.g. in the alert.log [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/temporary-tablespace-and-oda-19-31\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2026-06-11T06:55:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-06-11T06:55:17+00:00\" \/>\n<meta name=\"author\" content=\"Clemens Bleile\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ifgtxD2SrQ8r!YuXj\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Clemens Bleile\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/temporary-tablespace-and-oda-19-31\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/temporary-tablespace-and-oda-19-31\\\/\"},\"author\":{\"name\":\"Clemens Bleile\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0ac04011f60f2e93c115358d0789c2da\"},\"headline\":\"Temporary tablespace and ODA 19.31.\",\"datePublished\":\"2026-06-11T06:55:15+00:00\",\"dateModified\":\"2026-06-11T06:55:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/temporary-tablespace-and-oda-19-31\\\/\"},\"wordCount\":252,\"commentCount\":0,\"keywords\":[\"autoextend\",\"oda\",\"Oracle\",\"oracle database appliance\",\"tempfile\",\"temporary tablespace\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/temporary-tablespace-and-oda-19-31\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/temporary-tablespace-and-oda-19-31\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/temporary-tablespace-and-oda-19-31\\\/\",\"name\":\"Temporary tablespace and ODA 19.31. - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2026-06-11T06:55:15+00:00\",\"dateModified\":\"2026-06-11T06:55:17+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0ac04011f60f2e93c115358d0789c2da\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/temporary-tablespace-and-oda-19-31\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/temporary-tablespace-and-oda-19-31\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/temporary-tablespace-and-oda-19-31\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Temporary tablespace and ODA 19.31.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0ac04011f60f2e93c115358d0789c2da\",\"name\":\"Clemens Bleile\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"caption\":\"Clemens Bleile\"},\"description\":\"Clemens Bleile has more than 30 years of IT experience, thirteen in Oracle Support and fifteen in Oracle Consulting. He is specialized in Oracle Database Performance Tuning (SQL Tuning, DB Tuning) and developing an Oracle DB IT architecture (highly available, low-maintenance, cost efficient storage of data). He is an expert in problem analysis and resolution. Prior to joining dbi services, Clemens Bleile was Manager of the EMEA Database Performance team at the Oracle Global Customer Support Services. Clemens Bleile is Oracle Certified Professional 11g, 12c and Oracle Certified Expert for Performance Management and Tuning and holds a Master Degree, Business Information Systems from the Fachhochschule Furtwangen, Germany.\",\"sameAs\":[\"https:\\\/\\\/www.dbi-services.com\",\"https:\\\/\\\/x.com\\\/ifgtxD2SrQ8r!YuXj\"],\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/clemens-bleile\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Temporary tablespace and ODA 19.31. - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/temporary-tablespace-and-oda-19-31\/","og_locale":"en_US","og_type":"article","og_title":"Temporary tablespace and ODA 19.31.","og_description":"I recently patched Oracle Database Appliances (ODAs) to 19.31. For DBs with more than 1 tempfile in the temporary tablespace I got an error during the &#8220;odacli update-dbhome&#8221; : The issue is that Oracle tries to &#8220;set autoextend on&#8221; on the temporary files in 19.31., but runs a syntactically wrong command. E.g. in the alert.log [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/temporary-tablespace-and-oda-19-31\/","og_site_name":"dbi Blog","article_published_time":"2026-06-11T06:55:15+00:00","article_modified_time":"2026-06-11T06:55:17+00:00","author":"Clemens Bleile","twitter_card":"summary_large_image","twitter_creator":"@ifgtxD2SrQ8r!YuXj","twitter_misc":{"Written by":"Clemens Bleile","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/temporary-tablespace-and-oda-19-31\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/temporary-tablespace-and-oda-19-31\/"},"author":{"name":"Clemens Bleile","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"headline":"Temporary tablespace and ODA 19.31.","datePublished":"2026-06-11T06:55:15+00:00","dateModified":"2026-06-11T06:55:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/temporary-tablespace-and-oda-19-31\/"},"wordCount":252,"commentCount":0,"keywords":["autoextend","oda","Oracle","oracle database appliance","tempfile","temporary tablespace"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/temporary-tablespace-and-oda-19-31\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/temporary-tablespace-and-oda-19-31\/","url":"https:\/\/www.dbi-services.com\/blog\/temporary-tablespace-and-oda-19-31\/","name":"Temporary tablespace and ODA 19.31. - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2026-06-11T06:55:15+00:00","dateModified":"2026-06-11T06:55:17+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/temporary-tablespace-and-oda-19-31\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/temporary-tablespace-and-oda-19-31\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/temporary-tablespace-and-oda-19-31\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Temporary tablespace and ODA 19.31."}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da","name":"Clemens Bleile","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","caption":"Clemens Bleile"},"description":"Clemens Bleile has more than 30 years of IT experience, thirteen in Oracle Support and fifteen in Oracle Consulting. He is specialized in Oracle Database Performance Tuning (SQL Tuning, DB Tuning) and developing an Oracle DB IT architecture (highly available, low-maintenance, cost efficient storage of data). He is an expert in problem analysis and resolution. Prior to joining dbi services, Clemens Bleile was Manager of the EMEA Database Performance team at the Oracle Global Customer Support Services. Clemens Bleile is Oracle Certified Professional 11g, 12c and Oracle Certified Expert for Performance Management and Tuning and holds a Master Degree, Business Information Systems from the Fachhochschule Furtwangen, Germany.","sameAs":["https:\/\/www.dbi-services.com","https:\/\/x.com\/ifgtxD2SrQ8r!YuXj"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/clemens-bleile\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/45038","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=45038"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/45038\/revisions"}],"predecessor-version":[{"id":45039,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/45038\/revisions\/45039"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=45038"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=45038"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=45038"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=45038"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}