ORA-600(ksires_1)错误

Oracle RAC 10.2.0.4 for HP-UX环境出现ORA-600[ksires_1]错误。
错误信息为:

Mon DEC 13 23:00:13 2010
Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl2_m000_1861.trc:
ORA-00600: internal error code, arguments: [ksires_1], [], [], [], [], [], [], []
Mon DEC 13 23:00:15 2010
Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl2_m000_1861.trc:
ORA-00600: internal error code, arguments: [ksires_1], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [ksires_1], [Tue DEC 14 09:55:39 2010
Restarting dead background process MMON
MMON started WITH pid=24, OS id=29770

这个错误在两个节点上都出现过,而且有时发生在MNNN进程上,有时发生在ORA进程上。查询MOS发现,导致问题的原因是/var/tmp目录下crs的sockets文件被清除:Many ORA-600: [ksires_1] In RAC [ID 1311870.1]。
这个问题可能发生在10.2.0.4以后的任何非Windows平台上。如果要避免这个错误,只需避免/var/tmp目录下的文件被删除既可。

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 *