系统空间不足产生ORA-1错误

ORA-1错误代表唯一冲突,而空间不足时出现这个错误还是第一次碰到。
错误信息如下:

Tue May 01 05:00:11 2012
Non critical error ORA-00001 caught while writing TO trace file "/home/oracle/base/diag/rdbms/orcl/orcl/trace/orcl_ora_31131.trc"
Error message: Linux-x86_64 Error: 28: No SPACE LEFT ON device
Additional information: 1
Writing TO the above trace file IS disabled FOR now ON...

这个错误是11.2.0.2引入的,Oracle本应该返回操作系统上的错误,结果返回了ORA-00001错误信息,这是一个未发布的BUG 8367518导致的,可以参考文档Non Critical Error ORA-00001 Caught While Writing To Trace File [ID 1354863.1]。
Oracle给出的解决方法就是应用BUG 8367518的补丁,当然这个问题并不严重,完全可以将其忽略。

This entry was posted in BUG and tagged , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *