java.io.IOException: ORA-01652: unable to extend temp segment
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