java.io.IOException: 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 java.io.IOException: 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.