java.io.IOException: ORA-01652: unable to extend temp segment
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
Confluence cannot be started or some operations/tasks cannot be performed.
The following appears in the atlassian-confluence.log:
Could not create Oracle LOB; nested exception is java.io.IOException: ORA-01652: unable to extend temp segment by <number> in tablespace <tempfile>Cause
Oracle is not able to extend the size for the tablespace as it has reached the maximum defined size of the tablespace in which the Confluence database resides
Resolution
The value of 2GB (2000M) given here is an example. The exact value will depend on how large your existing segment is, and the value in the error message. Consider increasing the segment by at least the value shown in the error message.
Increase the temp segment size by running the following SQL query. In this example, the size is increased to 2000 MB.
alter database tempfile '/path/to/tempfile.dbf' resize 2000m;
If you hit into an error which is:
ERROR at line 1:
ORA-02231: missing or invalid option to ALTER DATABASEYou can run this query instead:
alter database datafile '/path/to/tempfile.dbf' autoextend on maxsize 2000M;For more information on this, please refer to the Oracle documentation