中午开发人员反映oracle报错,信息如下
<时间:20141203 111833> <进程号:[1429894]> 原因:应用错误,请与系统管理员联系。[-600]ORA-00600: internal error code, arguments: [kkslpbp:1], [], [], [], []
查metalink,解释如下
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.4 [Release 10.2] Information in this document applies to any platform.
***Checked for relevance on 31-Dec-2013***
Symptoms
This incident was observed on Oracle 10.2.0.4 64-bit on a HP-UX Itanium server RAC database, but the error can occur on single instance databases.
It can occur in any 10G release lower than 10.2.0.5
Problem description:
Some SQL statements are failing with internal errors.
The alert log shows the errors are occurring intermittently.
Solution
Bug 3176026 is unpublished.
It is fixed in 10.2.0.5. and Rel. 11
Due to the complexity of the fix, it cannot be backported to earlier releases.
Workaround 1.
If a WITH clause is involved, rewrite the query to not use the WITH clause, or use the INLINE hint
e.g. .. . . . ( WITH X AS ( SELECT /*+ INLINE */ . . . .
OR
Workaround 2.
Set cursor_sharing to EXACT
SQL> show parameter cursor_sha
NAME TYPE VALUE
------------------------------------ ----------- ----------
cursor_sharing string SIMILAR
SQL> ALTER SYSTEM SET CURSOR_SHARING='EXACT';
修改CURSOR_SHARING后,alter log不在出现ORA-00600: internal error code, arguments: [kkslpbp:1]