{"id":63,"date":"2026-06-11T11:24:55","date_gmt":"2026-06-11T09:24:55","guid":{"rendered":"http:\/\/cbleile.de\/wordpress\/?p=63"},"modified":"2026-06-11T11:24:55","modified_gmt":"2026-06-11T09:24:55","slug":"temporary-tablespace-and-oda-19-31","status":"publish","type":"post","link":"http:\/\/cbleile.de\/wordpress\/temporary-tablespace-and-oda-19-31\/","title":{"rendered":"Temporary tablespace and ODA 19.31."},"content":{"rendered":"\n

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 „odacli update-dbhome“ :<\/p>\n\n\n\n

# 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
The issue is that Oracle tries to „set autoextend on“ 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
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
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
The workaround was to <\/p>\n\n\n\n
 – create a temporary tablespace temp2<\/p>\n\n\n\n
 – make temp2 the default temporary tablespace<\/p>\n\n\n\n
 – drop temporary tablespace temp<\/p>\n\n\n\n
 – create the temporary tablespace temp with just 1 tempfile<\/p>\n\n\n\n
 – make temp the default temporary tablespace<\/p>\n\n\n\n
 – drop temporary tablespace temp2<\/p>\n\n\n\n
Then run the „odacli update-dbhome“ again and it will be successful. Afterwards add your temporary files to tablespace temp again.\u00a0<\/p>\n\n\n\n
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’s a good idea to scan the alert-logs for the error:<\/p>\n\n\n\n
$ find \/u01\/app\/odaorabase\/oracle\/diag\/rdbms\/*\/*\/trace -name \"alert*.log\" -exec grep -il \"ORA-1516\" {}\\;<\/code><\/pre>\n\n\n\n
To proactively avoid the issue when patching to 19.31. on the ODA, I’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
select count(*) from dba_temp_files where tablespace_name='TEMP';<\/code><\/pre>\n\n\n\n
We opened a SR with Oracle to get the issue fixed for the next release.<\/p>\n","protected":false},"excerpt":{"rendered":"
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 „odacli update-dbhome“ : The issue is that Oracle tries to „set autoextend on“ on the temporary files in 19.31., but runs a syntactically wrong command. E.g. in the alert.log […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[59,27,3,53,58],"class_list":["post-63","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-19-31","tag-oda","tag-oracle","tag-oracle-database-appliance","tag-temporary-tablespace"],"_links":{"self":[{"href":"http:\/\/cbleile.de\/wordpress\/wp-json\/wp\/v2\/posts\/63","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/cbleile.de\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/cbleile.de\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/cbleile.de\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/cbleile.de\/wordpress\/wp-json\/wp\/v2\/comments?post=63"}],"version-history":[{"count":1,"href":"http:\/\/cbleile.de\/wordpress\/wp-json\/wp\/v2\/posts\/63\/revisions"}],"predecessor-version":[{"id":64,"href":"http:\/\/cbleile.de\/wordpress\/wp-json\/wp\/v2\/posts\/63\/revisions\/64"}],"wp:attachment":[{"href":"http:\/\/cbleile.de\/wordpress\/wp-json\/wp\/v2\/media?parent=63"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/cbleile.de\/wordpress\/wp-json\/wp\/v2\/categories?post=63"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/cbleile.de\/wordpress\/wp-json\/wp\/v2\/tags?post=63"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}