ORA-600(qerrmObnd1)(932)错误(二)

另外一个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问题。

 

 

请使用浏览器的分享功能分享到微信等