600错误，哪位给点思路？

显示全部楼层 · 2012-1-4 11:51:22

以下是alert.log中截取出来的，哪位遇到过类似问题，给个头绪好吗？
Errors in file /opt/oracle/admin/DOCPRD/udump/docprd1_ora_12269.trc:
ORA-00600: internal error code, arguments: [17059], [0xC00000015CDD49A0], [], [], [], [], [], []
Mon Jun 23 07:26:38 2008
Trace dumping is performing id=[cdmp_20080623072638]
Mon Jun 23 07:26:38 2008
Errors in file /opt/oracle/admin/DOCPRD/udump/docprd1_ora_12269.trc:
ORA-00600: internal error code, arguments: [17059], [0xC00000015CDD49A0], [], [], [], [], [], []
Mon Jun 23 07:26:41 2008
Errors in file /opt/oracle/admin/DOCPRD/udump/docprd1_ora_12269.trc:
ORA-00600: internal error code, arguments: [17059], [0xC00000015CDD49A0], [], [], [], [], [], []
Mon Jun 23 07:26:44 2008
Errors in file /opt/oracle/admin/DOCPRD/udump/docprd1_ora_12269.trc:
ORA-00600: internal error code, arguments: [17059], [0xC00000015CDD49A0], [], [], [], [], [], []
Mon Jun 23 07:26:47 2008
Errors in file /opt/oracle/admin/DOCPRD/udump/docprd1_ora_12269.trc:
ORA-00600: internal error code, arguments: [17059], [0xC00000015CDD49A0], [], [], [], [], [], []
Mon Jun 23 07:26:50 2008
Errors in file /opt/oracle/admin/DOCPRD/udump/docprd1_ora_12269.trc:
ORA-00600: internal error code, arguments: [17059], [0xC00000015CDD49A0], [], [], [], [], [], []
Mon Jun 23 07:26:52 2008
Errors in file /opt/oracle/admin/DOCPRD/udump/docprd1_ora_12269.trc:
ORA-00600: internal error code, arguments: [17059], [0xC00000015CDD49A0], [], [], [], [], [], []
Mon Jun 23 07:26:55 2008
Errors in file /opt/oracle/admin/DOCPRD/udump/docprd1_ora_12269.trc:
ORA-00600: internal error code, arguments: [17059], [0xC00000015CDD49A0], [], [], [], [], [], []
Mon Jun 23 07:26:58 2008
Errors in file /opt/oracle/admin/DOCPRD/udump/docprd1_ora_12269.trc:

千问 · 2012-1-4 11:51:22

参见METALINK Note:138554.1

千问 · 2012-1-4 11:51:22

metalink

千问 · 2012-1-4 11:51:22

没有metalink账号，可怜！

千问 · 2012-1-4 11:51:22

从metalink帮你搜索了一个结果，供参考：
Subject:ORA-600 [17059]
Doc ID:Note:138554.1 Type:REFERENCE
Last Revision Date:09-MAY-2008 Status:PUBLISHED

Note: For additional ORA-600 related information please read Note 146580.1
PURPOSE:

This article discusses the internal error "ORA-600 [17059]", what
it means and possible actions. The information here is only applicable
to the versions listed and is provided only for guidance.
ERROR:
ORA-600 [17059] [a]
VERSIONS:
versions 7.1 to 11.1
DESCRIPTION:
While building a table to hold the list of child cursor dependencies
relating to a given parent cursor, we exceed the maximum possible size
of the table.
ARGUMENTS:
Arg [a] Object containing the table
FUNCTIONALITY:
Kernel Generic Library cache manager
IMPACT:
PROCESS FAILURE
NON CORRUPTIVE - No underlying data corruption.
SUGGESTIONS:
One symptom of this error is that the session will appear to hang for a
period of time prior to this error being reported.
Issuing this SQL as SYS (SYSDBA) may help show any problem
objects in the dictionary:
select do.obj#,
po.obj# ,
p_timestamp,
po.stime ,
decode(sign(po.stime-p_timestamp),0,'SAME','*DIFFER*') X
from sys.obj$ do, sys.dependency$ d,sys.obj$ po
where P_OBJ#=po.obj#(+)
and D_OBJ#=do.obj#
and do.status=1 /*dependent is valid*/
and po.status=1 /*parent is valid*/
and po.stime!=p_timestamp /*parent timestamp not match*/
order by 2,1
;
Normally the above select would return no rows. If any rows are
returned the listed dependent objects may need recompiling.
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# 5177766 See Note 5177766.8
OERI[17059] with SESSION_CACHED_CURSORS
Fixed: 10.2.0.4, 11.1.0.6

Bug# 4559728 See Note 4559728.8
Select lob from view loops / OERI [17059] if synonym dropped
Fixed: 9.2.0.8, 10.2.0.4, 11.1.0.6

Bug# 4203874 See Note 4203874.8
Dictionary corruption after DROP partition (can cause OERI:17059)
Fixed: 9.2.0.8, 10.1.0.5, 10.2.0.1

Bug# 3555003 See Note 3555003.8
View compilation hangs / OERI:17059 after DBMS_APPLY_ADM.SET_DML_HANDLER
Fixed: 9.2.0.6

Bug# 2707304 See Note 2707304.8
OERI:17059 / OERI:kqlupd2 / PLS-907 after adding partitions to Partitioned IOT
Fixed: 9.2.0.3, 10.1.0.2

Bug# 2636685 See Note 2636685.8
Hang / OERI:[17059] after adding a list value to a partition
Fixed: 9.2.0.3, 10.1.0.2

Bug# 2626347 See Note 2626347.8
OERI:17059 accessing view after ADD / SPLIT PARTITION
Fixed: 9.2.0.3, 10.1.0.2

Bug# 2306331 See Note 2306331.8
Hang / OERI[17059] on view after SET_KEY or SET_DML_INVOKATION on base table
Fixed: 9.2.0.2

Bug# 1115424 See Note 1115424.8
Cursor authorization and dependency lists too long - can impact shared pool / OERI:17059
Fixed: 8.0.6.2, 8.1.6.2, 8.1.7.0

Bug# 631335 See Note 631335.8
OERI:17059 from extensive re-user of a cursor
Fixed: 8.0.4.2, 8.0.5.0, 8.1.5.0

Bug# 558160 See Note 558160.8
OERI:17059 from granting privileges multiple times
Fixed: 8.0.3.2, 8.0.4.0, 8.1.5.0