首页 > 代码库 > 偶遇问题之ORA 600 [kkpoxgsoh1
偶遇问题之ORA 600 [kkpoxgsoh1
alert.log中报错,查看如下:
Fri Jul 18 09:25:50 2014
Errors in file /apps/oracle/diag/rdbms/smsrac/smsrac2/trace/smsrac2_ora_15454.trc (incident=16321):
ORA-00600: 内部错误代码, 参数: [kkpoxgsoh1], [0], [], [], [], [], [], [], [], [], [], []
Incident details in: /apps/oracle/diag/rdbms/smsrac/smsrac2/incident/incdir_16321/smsrac2_ora_15454_i16321.trc
Fri Jul 18 09:25:50 2014
Errors in file /apps/oracle/diag/rdbms/smsrac/smsrac2/trace/smsrac2_ora_15462.trc (incident=16529):
ORA-00600: 内部错误代码, 参数: [kkpoxgsoh1], [0], [], [], [], [], [], [], [], [], [], []
Incident details in: /apps/oracle/diag/rdbms/smsrac/smsrac2/incident/incdir_16529/smsrac2_ora_15462_i16529.trc
Fri Jul 18 09:25:52 2014
Dumping diagnostic data in directory=[cdmp_20140718092552], requested by (instance=2, osid=15454), summary=[incident=16321].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Fri Jul 18 09:25:52 2014
Sweep [inc][16321]: completed
Sweep [inc2][16321]: completed
Fri Jul 18 09:25:52 2014
Sweep [inc][16529]: completed
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Fri Jul 18 09:25:53 2014
Sweep [inc2][16529]: completed
查看相关trc文件,可以得出相关sql,看看到底是什么引起的
Dump continued from file: /apps/oracle/diag/rdbms/smsrac/smsrac2/trace/smsrac2_ora_15454.trc
ORA-00600: 内部错误代码, 参数: [kkpoxgsoh1], [0], [], [], [], [], [], [], [], [], [], []
========= Dump for incident 16321 (ORA 600 [kkpoxgsoh1]) ========
*** 2014-07-18 09:25:50.671
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=fcugjhv161x8v) -----
SELECT * FROM (SELECT
由select语句引起。
mos上给出这是bug
This problem is introduced by the fix for 11659002 included in 11.2.0.3.
With that fix there is a small timing window where SELECT statements could hit
ORA-600 when the select uses a partitioned index that is concurrently dropped
right around the time of the parse (hard or soft) of the SELECT.
当使用分区索引时,并发drop会引发此bug。
本文出自 “刚刚出壳的小鸟” 博客,请务必保留此出处http://qhd2004.blog.51cto.com/629417/1439814