ORA-00600\ ORA-07445

ORACLE ALERT文件中的报错信息

Mon Oct 19 23:01:26 2009
Errors in file d:\oracle\product\10.2.0\admin\gwdb\udump\gwdb_ora_2320.trc:
ORA-00600: 内部错误代码, 参数: [kksfbc-reparse-infinite-loop], [0x9B5A9C4], [], [], [], [], [], []

Tue Oct 20 02:12:44 2009
Thread 1 advanced to log sequence 3656
  Current log# 1 seq# 3656 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\GWDB\REDO01.LOG
Tue Oct 20 07:09:27 2009
Thread 1 advanced to log sequence 3657
  Current log# 2 seq# 3657 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\GWDB\REDO02.LOG
Tue Oct 20 10:23:04 2009
Errors in file d:\oracle\product\10.2.0\admin\gwdb\udump\gwdb_ora_820.trc:
ORA-00600: 内部错误代码, 参数: [kksfbc-reparse-infinite-loop], [0x3FA9C4], [], [], [], [], [], []

Tue Oct 20 11:52:53 2009
Errors in file d:\oracle\product\10.2.0\admin\gwdb\udump\gwdb_ora_2256.trc:
ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_selexe+741] [PC:0x1C10141] [ADDR:0x1C] [UNABLE_TO_READ] []

Tue Oct 20 11:52:59 2009
Errors in file d:\oracle\product\10.2.0\admin\gwdb\udump\gwdb_ora_1308.trc:
ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_selexe+741] [PC:0x1C10141] [ADDR:0x1C] [UNABLE_TO_READ] []

 

METALINK:

Bug 6494146 - OERI [kksfbc-reparse-infinite-loop] can occur
	:	6494146.8	Type:	PATCH
	Modified Date :	24-SEP-2008	Status:	PUBLISHED

Bug 6494146  OERI [kksfbc-reparse-infinite-loop] can occur

 This note gives a brief overview of bug 6494146.
 The content was last updated on: 21-DEC-2007
 Click for details of each of the sections below.

Affects:

Product (Component)	Oracle Server (Rdbms)
Range of versions believed to be affected	Versions < 11
Versions confirmed as being affected
Platforms affected	Generic (all / most platforms affected)

Fixed:

This issue is fixed in
Symptoms:		Related To:
Internal Error May Occur (ORA-600)

Description

ORA-600 [kksfbc-reparse-infinite-loop] can occur 

with interdependent PLSQL packages.

#####################################

Subject: 
ORA-7445 (selexe)
 
: 
460210.1
Type: 
REFERENCE
 
Modified Date : 
15-SEP-2008
Status: 
PUBLISHED

Note: For additional ORA-7445 related information please read 

PURPOSE:

  This article provides information on one or more bugs that are 
  known to result in the given ORA-7445 error.

SUGGESTIONS:

  If the Known Issues section below does not help in terms of identifying
  a solution, please submit the trace files and alert.log to Oracle 
  Support Services for further analysis.

  Known Issues:
  Bug# 5096560   See 
      Dump (selexe) when recompiling a materialized view with a UNION
      Fixed: 10.2.0.4, 11.1.0.6
 
***************************************
 

Bug 5096560 - Dump (selexe) when recompiling a materialized view with a UNION
	:	5096560.8	Type:	PATCH
	Modified Date :	24-SEP-2008	Status:	PUBLISHED

Bug 5096560  Dump (selexe) when recompiling a materialized view with a UNION

 This note gives a brief overview of bug 5096560.
 The content was last updated on: 05-SEP-2008
 Click for details of each of the sections below.

Affects:

Product (Component)	Oracle Server (Rdbms)
Range of versions believed to be affected	Versions < 11
Versions confirmed as being affected
Platforms affected	Generic (all / most platforms affected)

Fixed:

This issue is fixed in

Symptoms:	Related To:
Dump in or under

Description

Alter materialized view statement can signal a parse error or dump.

Workaround
 Set "_push_join_union_view" = false

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with Oracle Support for advice.

References

(This link will only work for PUBLISHED bugs)
Information on the sections in this article

************实际环境解决方案**********

打上10。2。0。4补丁后，问题解决。