九乡新闻网防锈漆品牌:ORA-00600: [qerrmObnd1],
来源：百度文库 编辑：九乡新闻网 时间：2024/07/14 01:21:42
今天帮客户巡检数据库,数据库报以下错误:
ORA-00600: internal error code, arguments: [qerrmObnd1], [932], [ORA-00932: inconsistent datatypes: expected gotITPUB个人空间6g4}0PG f6d fyN
根据trace查出来的sql如下:
select to_char(bq.rk_rq,:"SYS_B_00") ZS_XM,:"SYS_B_01" ZS_PM,bq.bqrk_je BQRK_JE,to_char(bq.rk_rq,:"SYS_B_02") RK_RQ--,sq.bqrk_je SNTQ_JE,case when sq.bqrk_je>0 then (bq.bqrk_je-sq.bqrk_je)/sq.bqrk_je when sq.bqrk_je =0 then 1 end ZJL,bq.bqrk_je-nvl(sq.bqrk_je,0) ZJ_JEITPUB个人空间Q.i:X;isr4a
,decode((select nsrnbm from t_dcfx_dcfxbg where nsrnbm = :"SYS_B_03" and bgssq_z = to_char(bq.rk_rq,:"SYS_B_04") ),:"SYS_B_05",:"SYS_B_06",:"SYS_B_07") fxbgITPUB个人空间9G9| {} JV{{
from
Y9h%f.V/\0(select :"SYS_B_08" ZS_XM,:"SYS_B_09" ZS_PM,(sum(nvl(a.bqrkse,:"SYS_B_10")) -sum(nvl(a.bqtkse,:"SYS_B_11"))) BQRK_JE,trunc(a.sj,:"SYS_B_12") RK_RQITPUB个人空间r} V8YV
fromdw.fact_zdsyssfx@gzodsaITPUB个人空间(y? u aI e ?;`
whereITPUB个人空间.k.|qFzg
trunc(a.sj,:"SYS_B_13") = trunc(to_date(:"SYS_B_14",:"SYS_B_15"), :"SYS_B_16")ITPUB个人空间e Gh VR7P @0p W
and a.nsrnbm =:"SYS_B_17" group by trunc(a.sj,:"SYS_B_18"))bq,ITPUB个人空间a%v'M1Vu }k]
(select :"SYS_B_19" ZS_XM,:"SYS_B_20" ZS_PM,(sum(nvl(a.bqrkse,:"SYS_B_21")) -sum(nvl(a.bqtkse,:"SYS_B_22"))) BQRK_JE,trunc(a.sj,:"SYS_B_23") RK_RQITPUB个人空间6~+_M*kR Z
fromdw.fact_zdsyssfx@gzodsa
{9I9y-C+i5c z}-r0 whereITPUB个人空间 KO%C~.K&T7j+n.K
trunc(a.sj,:"SYS_B_24") = trunc(add_months(to_date(:"SYS_B_25",:"SYS_B_26"),-:"SYS_B_27"), :"SYS_B_28")ITPUB个人空间 W Q-nZ fb\mo
and a.nsrnbm =:"SYS_B_29" group by trunc(a.sj,:"SYS_B_30"))sqITPUB个人空间MxE)f#u I}
whereITPUB个人空间qP eGu!gBF#h
bq.RK_RQ = add_months(SQ.RK_RQ,:"SYS_B_31")
根据查metalink,有可能是bug
检查下数据库参数为 cursor_sharing=SIMILAR 触发这个bug
以下是metalink解释
Bug 4254094 - OERI[qerrmObnd1][932] possible for queries over DB links 文档 ID: 4254094.8 类型: PATCH 上次修订日期: 24-SEP-2008 状态: PUBLISHED
