oracle ora-00600:内部错误代码怎么解决

[xiaojinchao]

我对一个视图进行 group by 总数,运行好久就 出错下列提示
ora-00600:内部错误代码，参数:[15160],[],[],[],[],[],[],[]

[vc555]

看看alert.log告警日志，才能确定原因。

[xiaojinchao]

trc文件的一部分

ORA-00600: 内部错误代码, 参数: [15160], [], [], [], [], [], [], []
Current SQL statement for this session:
select * from v_tj_bdz_byqtj t
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_ksedst+38 CALLrel _ksedst1+0 0 1
_ksedmp+898 CALLrel _ksedst+0 0
_ksfdmp+14 CALLrel _ksedmp+0 3
_kgeriv+146 CALLreg 00000000 8AD8E90 3
_kgesiv+85 CALLrel _kgeriv+0 8AD8E90 7FB1F60 3B38 0
80CA3F0
_ksesic0+59 CALLrel _kgesiv+0 8AD8E90 7FB1F60 3B38 0
80CA3F0 3B38 0 80CA3F0
__VInfreq__kkotap+2 CALLrel _ksesic0+0 3B38
8190
_kkoqbc+3521 CALLrel _kkoipt+0 8D6F984
_apakkoqb+151 CALLrel _kkoqbc+0 80CBC44 603AEE54
_apaqbd+383 CALLrel _apakkoqb+0 80CC064 7FAA6B4 30CAC374
_apadrv+459 CALLrel _apaqbd+0
_opitca+1445 CALLrel _apadrv+0 30CAC374
_kksLoadChild+5750 CALLrel _opitca+0 80FA13C 30CAC374
_kkslod+98 CALLrel _kksLoadChild+0 8AD8E90 33D7D534 80CD3C4
_kglobld+837 CALLreg 00000000 8AD8E90 33D7D534 80CD3C4
_kglobpn+1224 CALLrel _kglobld+0 8AD8E90 2FEFF75C 80CD3C4
31B18348 0
_kglpim+264 CALLrel _kglobpn+0 8AD8E90 31B18348 80CD3C4 1
_kglpin+1078 CALLrel _kglpim+0 8AD8E90 80CD3C4 31B18348
_kxsGetRuntimeLock+ CALLrel _kglpin+0 8AD8E90 80CD3C4 31B9A8D4
1936 33D7D534 3 3 80FA164
_kksfbc+7232 CALLrel _kxsGetRuntimeLock+ 8AD8E90 80FA13C 80CD3C4 3 1
0
_kkspsc0+2094 CALLrel _kksfbc+0 80FA13C 3 108 80CE274 20 0 0
0
_kksParseCursor+143 CALLrel _kkspsc0+0
_opiosq0+1965 CALLrel _kksParseCursor+0 80CD8A0
_kpooprx+232 CALLrel _opiosq0+0 3 E 80CD9D8 A4
_kpoal8+775 CALLrel _kpooprx+0 80CF6F8 80CE274 1F 1 0 A4
_opiodr+1099 CALLreg 00000000 5E 17 80CF6F4
_ttcpip+1273 CALLreg 00000000 5E 17 80CF6F4 0
_opitsk+1017 CALL??? 00000000
_opiino+1087 CALLrel _opitsk+0 0 0
_opiodr+1099 CALLreg 00000000 3C 4 80CFC8C
_opidrv+819 CALLrel _opiodr+0 3C 4 80CFC8C 0
_sou2o+45 CALLrel _opidrv+0 3C 4 80CFC8C
_opimai_real+112 CALLrel _sou2o+0 80CFC80 3C 4 80CFC8C
_opimai+92 CALLrel _opimai_real+0 2 80CFCB8
_OracleThreadStart@ CALLrel _opimai+0
4+708
7C80B680 CALLreg 00000000

--------------------- Binary Stack Dump ---------------------

========== FRAME [1] (_ksedst+38 -> _ksedst1+0) ==========
Dump of memory from 0x080CA298 to 0x080CA2A8
80CA290 080CA2A8 0040468B [.....F@.]
80CA2A0 00000000 00000001 [........]
========== FRAME [2] (_ksedmp+898 -> _ksedst+0) ==========
Dump of memory from 0x080CA2A8 to 0x080CA368
80CA2A0 080CA368 00403083 [h....0@.]
80CA2B0 00000000 080CA770 08D6F984 014465A5 [....p........eD.]
80CA2C0 08D6F984 FFFFFFFF 7FEFFFFF 00000001 [................]
80CA2D0 08CEC018 00000005 08AD8F94 00000000 [................]
80CA2E0 08AD8F8C 00000000 00000000 00000000 [................]
80CA2F0 00000000 00000000 08AD8F94 00000000 [................]
80CA300 00000000 080CA320 00000001 00000005 [.... ...........]
80CA310 00000000 00000000 00000000 080CA3F0 [................]
80CA320 36313531 00000001 00000000 00000000 [1516............]
80CA330 00000000 00000001 00000000 00000000 [................]
80CA340 08AD8E90 07FB1F60 031DAC40 00000005 [....`...@.......]
80CA350 080CA2B4 080CA390 080CC2D0 0261348C [.............4a.]
80CA360 031C1800 FFFFFFFF [........]
========== FRAME [3] (_ksfdmp+14 -> _ksedmp+0) ==========
Dump of memory from 0x080CA368 to 0x080CA374
80CA360 080CA374 0043AB6F [t...o.C.]
80CA370 00000003 [....]
========== FRAME [4] (_kgeriv+146 -> 00000000) ==========
Dump of memory from 0x080CA374 to 0x080CA390
80CA370 080CA390 603A816C 08AD8E90 [....l.:`....]
80CA380 00000003 08AD8E90 07FB1F60 08AD8A30 [........`...0...]
========== FRAME [5] (_kgesiv+85 -> _kgeriv+0) ==========
Dump of memory from 0x080CA390 to 0x080CA3B4
80CA390 080CA3B4 603A8404 08AD8E90 07FB1F60 [......:`....`...]
80CA3A0 00003B38 00000000 080CA3F0 08D6FE5C [8;..........\...]
80CA3B0 080CA3F0 [....]
========== FRAME [6] (_ksesic0+59 -> _kgesiv+0) ==========
Dump of memory from 0x080CA3B4 to 0x080CA3E4
80CA3B0 080CA3E4 004025C4 08AD8E90 [.....%@.....]
80CA3C0 07FB1F60 00003B38 00000000 080CA3F0 [`...8;..........]
80CA3D0 00003B38 00000000 080CA3F0 07FA99D4 [8;..............]
80CA3E0 08C91814 [....]
========== FRAME [7] (__VInfreq__kkotap+28190 -> _ksesic0+0) ==========
Dump of memory from 0x080CA3E4 to 0x080CA774
80CA3E0 080CA774 02FB2DEB 00003B38 [t....-..8;..]
80CA3F0 00000000 07FA0038 08CD7FFC 000017F8 [....8...........]
80CA400 00000000 000000FF 00000000 07FA00B8 [................]
80CA410 07FA00AC 00000000 07FA00AC 00000000 [................]
80CA420 00000000 080CA474 603BC5F8 08AD8E90 [....t.....;`....]
80CA430 00000000 07FA0038 00002010 603C5AC5 [....8.... ...Z<`]
80CA440 30372B4C 00000002 30372BB8 00003BF0 [L+70.....+70.;..]
80CA450 30372BB8 00000002 30372B4C 080CA3B0 [.+70....L+70....]
80CA460 00002000 0000009E 00000008 329444E8 [. ...........D.2]
80CA470 080CA4F8

[范佩西_11]

很难搞定。内部错误你重启下服务之类的试试。

[xiaojinchao]

哪位高手 加一下我QQ 21095807 我发日志和trc文件 这里附件没发上去，

[xiaojinchao]

我都重启过服务了

[xiaojinchao]

试图用的太多了，嵌套了很多，

[vc555]

你贴报错那部分的告警日志。trace文件看不出来。

[fdfdfzz]

学习

[oracledbalgtu]

ora-600多数都是bug导致的。
你的是什么版本的oracle?什么平台?
如果是10g，解决办法有三个:
1。设置optimizer_features_enable=9.2.0
或者
2.打上oracle的补丁patch 5694466 ;
或者
3。在你的view sql语句中添加hint： NO_UNNEST


[Quote=引用楼主 xiaojinchao 的帖子:]
我对一个视图进行 group by 总数,运行好久就 出错下列提示
ora-00600:内部错误代码，参数:[15160],[],[],[],[],[],[],[]
[/Quote]

[dlpseeyou]

我也遇到见,我备份数据库,删除数据库,重建数据库

[lionghwo]

你不会是做了DML操作，用了GROUP BY？