另外一个ORA-600(qerrmObnd1)(932)的错误。
ORA-600(qerrmObnd1)(932)错误(一):http://yangtingkun.itpub.net/post/468/519508
和上一次碰到这个ORA-600错误的情况很像,也是10201版本的数据库,同样出现了ORA-600(qerrmObnd1)(932)的错误,也出现了ORA-7445的错误:
Thu Jan 27 14:46:21 2011
Errors in file /home/oracle/admin/RT/udump/rt_ora_7665.trc:
ORA-00600: internal error code, arguments: [qerrmObnd1], [932], [ORA-00932:
inconsistent datatypes: expected got
], [], [], [], [], []
Thu Jan 27 14:46:21 2011
Errors in file /home/oracle/admin/RT/udump/rt_ora_7665.trc:
ORA-07445: exception encountered: core dump [SIGSEGV] [Address not mapped to
object] [8] [] [] []
ORA-00600: internal error code, arguments: [qerrmObnd1], [932], [ORA-00932:
inconsistent datatypes: expected got
], [], [], [], [], []
不过这次有详细的trace记录,可以进一步分析问题的原因:
*** 2011-01-27 14:46:21.145
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [qerrmObnd1], [932], [ORA-00932:
inconsistent datatypes: expected got
], [], [], [], [], []
Current SQL statement for this session:
SELECT a.work_date,a.store_no,
cust_nbr,
Sales_qty,
Sales_amnt,
t_Sales_amnt,
t_sales_cost,
t_con_fore,
t_con_fore_oth,
c.seq_no
FROM
(SELECT work_date,store_no,
cust_nbr,
Sales_qty,
Sales_amnt
FROM SALES_DATA_DAILY
WHERE work_date > add_months(sysdate -
to_char(sysdate,:"SYS_B_0"),-:"SYS_B_1")
AND work_date < add_months(sysdate -
:"SYS_B_2",-:"SYS_B_3")
AND TYPE =
:"SYS_B_4") a,
( SELECT
store_no, work_date,
SUM (Sales_amnt) AS
t_Sales_amnt,
SUM (sales_cost) AS
t_sales_cost,
SUM (con_fore) AS
t_con_fore,
SUM (con_fore_oth) AS
t_con_fore_oth
FROM subgroup_stat_daily@rthis
WHERE work_date > add_months(sysdate -
to_char(sysdate,:"SYS_B_5"),-:"SYS_B_6")
AND work_date < add_months(sysdate -
:"SYS_B_7",-:"SYS_B_8")
GROUP BY store_no, work_date) b, store c
WHERE a.store_no = b.store_no
and a.store_no = c.store_no
and a.work_date = b.work_date
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+23 ? 0000000000000000 0014088EC 000000000 0FFDFBDA0
0FFFFFD7F
ksedmp()+796 ? 0000000000000000 0014073E1 000000000 006169DF8
000000000
ksfdmp()+16 ? 0000000000000000 001448E55 000000000 0FFDFBDE0
0FFFFFD7F
kgerinv()+194 ? 0000000000000000 003FCDC8F 000000000 0FFDFBEE8
0FFFFFD7F
kgesinv()+22 ? 0000000000000000 003FCE4AB 000000000 005BBD080
000000000
ksesin()+214 ? 0000000000000000 00140556B 000000000 0FFFFFFFF
000000000
OCIKSIN()+406 ? 0000000000000000 001D6747B 000000000 0FFDFBF40
0FFFFFD7F
qerrmObnd()+442 ? 0000000000000000 00322623F 000000000 006169DF8
000000000
qerrmOStart()+420 ? 0000000000000000 0032257D9 000000000 0FDA5ECE8
0FFFFFD7F
qerrmStart()+702 ? 0000000000000000 0032276C3 000000000 0CF96FF98
000000003
rwsfcd()+29 ? 0000000000000000 00325EB7A 000000000 0FFDFC640
0FFFFFD7F
qerhjFetch()+1139 ? 0000000000000000 0031F5180 000000000 005DE7440
000000000
qerflFetch()+168 ? 0000000000000000 0031ED525 000000000 0000001F4
000000000
qerghFetch()+293 ? 0000000000000000 0032DFD02 000000000 0000001F4
000000000
opifch2()+2239 ? 0000000000000000 00280F69C 000000000 000000000
000000000
kpoal8()+3491 ? 0000000000000000 001CCD258 000000000 000000000
000000000
opiodr()+1087 ? 0000000000000000 000E6EB1C 000000000 0FFDFD060
0FFFFFD7F
ttcpip()+1172 ? 0000000000000000 003CA6AE1 000000000 0FFDFEEF4
0FFFFFD7F
opitsk()+1210 ? 0000000000000000 000E6A96F 000000000 000E6E700
000000000
opiino()+930 ? 0000000000000000 000E6DDB7 000000000 005DE5E40
000000000
opiodr()+1087 ? 0000000000000000 000E6EB1C 000000000 000000000
000000000
opidrv()+748 ? 0000000000000000 000E69761 000000000 0FFDFF7D8
0FFFFFD7F
sou2o()+86 ? 0000000000000000 001C8A25B 000000000 000000000
000000000
opimai_real()+127 ? 0000000000000000 000E31BA4 000000000 000000000
000000000
main()+95 ? 0000000000000000 000E31A74 000000000 000000000
000000000
0000000000E318B7 ? 0000000000000000 000E318BC 000000000 000000000
000000000
--------------------- Binary Stack Dump ---------------------
虽然这个错误和metalink文档上的错误Bug 4254094十分接近,但是根据SQL语句,感觉和Bug 5015321更为接近一些。
不管到底是哪个bug,升级到10204以上的版本都可以fixed问题。