ORA-00600: [ktspfupdst-1]

老杨 2019-04-18
6
0 0
摘要:客户9208数据库出现ORA-600[ktspfupdst-1]错误。错误信息为:SatMar3102:50:482012ErrorsIN...

问题描述

客户9208数据库出现ORA-600[ktspfupdst-1]错误。
错误信息为:

Sat Mar 31 02:50:48 2012
Errors IN file /oracle/app/admin/orcl/udump/orcl1_ora_1896900.trc:
ORA-00600: internal error code, arguments: [ktspfupdst-1], [], [], [], [], [], [], []
ORA-00604: error occurred at recursive SQL level 1
ORA-01013: USER requested cancel OF CURRENT operation


专家解答

其实从错误信息本身就可以初步判断,问题应该和用户取消当前的操作有关。问题多半是由于用户取消当前操作后,Oracle在进行恢复处理时,引发了异常。
详细TRACE信息为:

*** 2012-03-31 02:50:48.509
ksedmp: internal OR fatal error
ORA-00600: internal error code, arguments: [ktspfupdst-1], [], [], [], [], [], [], []
ORA-00604: error occurred at recursive SQL level 1
ORA-01013: USER requested cancel OF CURRENT operation
CURRENT SQL statement FOR this SESSION:
INSERT INTO TAB001_3
(
  COL_CODE      ,
  A_CODE          ,
  C_CODE        ,
  S_ID            ,
  SER_NUM        ,
  S_TYPE          ,
  C_ID            ,
  A_ID            ,
  N_TYPE           ,
  B_ID           ,
  P_ID            , 
  P_ID_N       ,
  S_STAT        ,
  U_TIME        ,
  P_MODE           ,
  S_KIND          ,
  V_TYPE         ,
  O_MODE          ,
  A_TIME       ,
  C_TIME      ,
  AC_TIME        ,
  A_R_TIME   ,
  S_MODE          ,
  T_CODE      ,
  S_NUMBER         ,
  P_CODE       ,
  D_CODE      ,
  S_FLAG      ,
  S_TIME      ,
  DE_CODE     ,
  D_C_CODE  ,
  D_STAFF         ,
  CI_TYPE       ,
  O_TIME          ,
  SU_FLAG          ,
  SU_FLAG       ,
  D_A_CODE,
  CH_CODE          ,
  GR_ID           ,
  RE_CODE        )
SELECT '30',c.b_region,'',a.id_no,TRIM(a.p_no),'',a.c_id,a.c_no,'',a.s_code,'',
       '',decode(substr(a.r_code,2,1),'A','1','K','1','C','2','I','4','J','4','a','5','b','5','3'),
       to_char(a.r_time,'yyyymmddhh24miss'),decode(b.c_flag,'A','2','B','1'),
       '','01','1',to_char(a.o_time,'yyyymmddhh24miss'),to_char(a.o_time,'yyyymmddhh24miss'),'',to_char(a.o_time,'yyyymmddhh24miss'),
       'S','','','','','2','',
       '','','','',to_char(a.o_time,'yyyymmddhh24miss'),'U',decode(substr(a.r_code,2,1),'A','0','K','0','1'),
       c.b_region,'',a.g_id,c.r_code
  FROM tab2 a,tab3 b, tab4 c
 WHERE a.s_code = b.s_code
   AND substr(a.b_code,0,2) = b.r_code
   AND b.r_code = c.r_code
   AND MOD(a.id_no,10) = 3
----- Call Stack Trace -----
calling              CALL     entry                argument VALUES IN hex
location             TYPE     point                (? means dubious VALUE)
-------------------- -------- -------------------- ----------------------------
ksedmp+0148          bl       ksedst               1029746FC ?
ksfdmp+0018          bl       01FD4014
kgerinv+00e8         bl       _ptrgl
kgeasnmierr+004c     bl       kgerinv              000000001 ? 000000000 ?
                                                   000000005 ? 000000001 ?
                                                   000000001 ?
ktspfupdst+0540      bl       kgeasnmierr          110006308 ? 1103994E8 ?
                                                   102A9239C ? 000000000 ?
                                                   000000005 ? 000000010 ?
                                                   000000020 ? 000000006 ?
ktspstchg+00e4       bl       ktspfupdst           000000060 ? 300000004 ?
                                                   FFFFFFFFFFF6E48 ?
                                                   50601CE000000ED ?
                                                   3B401B34C5D02F2A ?
                                                   B92000004000020 ?
kdoiur+062c          bl       ktspstchg            000000000 ? 700000C39D779E8 ?
                                                   000000000 ?
kcoubk+00e4          bl       _ptrgl
ktundo+0988          bl       kcoubk               1010CCD80 ? FFFFFFFFFFF76C0 ?
                                                   100ED51C0 ? FFFFFFFFFFF7150 ?
                                                   1101FAF78 ? 1102567C0 ?
                                                   700000C396A1300 ? 000000002 ?
ktubko+03bc          bl       ktundo               1840DFB30 ?
                                                   3B401B3400000002 ?
                                                   000000000 ? 000000000 ?
                                                   FFFFFFFFFFF85D8 ?
                                                   700000C80A1E880 ? 2FFFF8540 ?
                                                   FFFFFFFFFFF8780 ?
ktuabt+0638          bl       ktubko               DF000000DF ?
                                                   FFFFFFFFFFF8690 ? 000000000 ?
                                                   FFFFFFFFFFF85D8 ? 102973880 ?
                                                   700000C844FA418 ?
ktcrab+02b4          bl       ktuabt               700000C80A1E840 ? 200017CD8 ?
ktcrsp+026c          bl       ktcrab               100F698E4 ? 000000001 ?
ksures+0074          bl       ktcrsp               700000C844FA448 ?
opiexe+3380          bl       01FD4138
opiall0+102c         bl       opiexe               400000000 ? 110002A48 ?
                                                   FFFFFFFFFFFA0A0 ?
kpoal8+0a78          bl       opiall0              5EFFFFBED4 ? 22103A43F8 ?
                                                   FFFFFFFFFFFA5B8 ? 000000000 ?
                                                   FFFFFFFFFFFA508 ? 1103A4B00 ?
                                                   6FF00000738 ?
                                                   24000000007FFF ?
opiodr+08cc          bl       _ptrgl
ttcpip+0cc4          bl       _ptrgl
opitsk+0d60          bl       ttcpip               11000CF90 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
opiino+0758          bl       opitsk               000000000 ? 000000000 ?
opiodr+08cc          bl       _ptrgl
opidrv+032c          bl       opiodr               3C00000018 ? 4101FAF78 ?
                                                   FFFFFFFFFFFF7B0 ? 0A000F350 ?
sou2o+0028           bl       opidrv               3C0C000000 ? 4A00E8B50 ?
                                                   FFFFFFFFFFFF7B0 ?
main+0138            bl       01FD3A28
__start+0098         bl       main                 000000000 ? 000000000 ?

可以看到,当前执行的是一条插入语句。查询MOS发现,问题和ORA-00600 [ktspfupdst-1] During DML on ASSM Segment [ID 388599.1]描述的完全一致。
首先当前插入的表所在表空间使用的是ASSM,其次这个插入操作被取消,而且所有堆栈信息与bug 3370468描述的完全一致。
虽然这个bug在9.2.0.5被fixed,但是不排除在9.2.0.8被重新引入的可能性。Oracle给出的解决方案除了升级到10.2以及10.1.0.3以上外,还可以尝试用dbms_repair.segment_fix_status过程来修正问题对象。
如果只是单次的问题,且无法重现,最简单的方法莫过于直接MOVE,确保ASSM空间管理的异常不会导致表中后续数据的插入和读取。

「喜欢文章,快来给作者赞赏墨值吧」

评论

0
0
Oracle
订阅
欢迎订阅Oracle频道,订阅之后可以获取最新资讯和更新通知。
墨值排行
今日本周综合
热门文章
近期活动
全部
相关课程
全部