ORA-01652: unable to extend temp segment


アトラシアン コミュニティをご利用ください。



Confluence cannot be started or some operations/tasks cannot be performed.

atlassian-confluence.log に次のメッセージが表示される。

Could not create Oracle LOB; nested exception is ORA-01652: unable to extend temp segment by <number> in tablespace <tempfile>


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


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 DATABASE

You 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

最終更新日 2016 年 6 月 24 日


Powered by Confluence and Scroll Viewport.