首页 > 代码库 > 偶遇问题之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