- 最后登录
- 2015-1-19
- 在线时间
- 27 小时
- 威望
- 0
- 金钱
- 106
- 注册时间
- 2014-7-8
- 阅读权限
- 10
- 帖子
- 13
- 精华
- 0
- 积分
- 0
- UID
- 1925
|
1#
发表于 2014-8-29 17:12:38
|
查看: 2902 |
回复: 1
内容:
Wed Aug 27 11:08:52 EAT 2014
Errors in file /oracle/admin/pmsxj/udump/pmsxj1_ora_12414.trc:
ORA-00600: internal error code, arguments: [kokegPinLob1], [], [], [], [], [], [], []
SELECT *
FROM (SELECT t0.*, ROWNUM AS count_id
FROM (select jh.obj_id,
dm.dmmc as dydj,
jh.sbbs,
jh.sblx lx,
jh.SCXSSJ,
jh.XSZQ,
jh.ZQDW,
jh.XSDQSJ,
jh.sbmc as xlmc,
deps.mc as yxdw,
sblx.sblx,
trunc(to_number(sysdate - jh.xsdqsj)) as cqts,
(select wmsys.wm_concat(d.mc)
from mw_sys.MWT_PD_DEPS d
where instr(jh.whbz, d.obj_id) > 0
and d.sfcx = '63785359-B0D9-4548-8F18-4F8FD682D684') whbz
from mw_app.MWT_UD_PD_YX_XS_ZQ jh,
mw_app.mwt_ud_gg_dm dm,
mw_sys.MWT_PD_DEPS deps,
mw_app.mwt_ud_pd_pz_sblx sblx
where jh.dydj = dm.bzdm
and dm.dmlb = '001'
and jh.sblx = sblx.sblxbm
and jh.yxdw = deps.obj_id
and jh.sbmc is not null
and exists
(select obj_id
from mw_sys.mwt_pd_deps
where dwjb in (3, 4, 6)
and obj_id = jh.yxdw
start with obj_id =
'F462EBCE-6E5D-4DC8-B3A8-799BA133855B-01792'
connect by prior obj_id = sjbm)
and jh.xsdqsj <= sysdate
and to_char(jh.xsdqsj, 'YYYY-MM') = '2014-08'
order by jh.xsdqsj) t0) t1
WHERE count_id BETWEEN 0 + 1 AND 9 --]时发生异常。详细信息为:[ORA-00600: internal error code, arguments: [kokegPinLob1], [], [], [], [], [], [], []
错误信息:
ORA-00600: internal error code, arguments: [kokegPinLob1], [], [], [], [], [], [], []
出现原因:
问题指向Bug 9824435 ORA-600 [kokegPinLob1] from aggregate returning a LOB。
确认受影响的版本包括10.2.0.5和11.2.0.2,这个bug在补丁集11.2.0.3和12.1中被解决。
解决办法:
在10.2.0.5上直接应用Patch 9824435
但这个BUG所对应的补丁号现在无法确认,哪位大神帮忙给传个补丁呀万分感谢! |
|