ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-600[6122]错误处理

ORA-600[6122]错误处理

原创 Linux操作系统 作者:tian1982tian 时间:2011-09-09 11:45:08 0 删除 编辑

接到一个ORA-600[6122]的报错:

Fri Aug  5 04:03:41 2011
Errors in file /ora/admin/SCRM01P/udump/scrm01p5_ora_11314.trc:
ORA-00600: internal error code, arguments: [6122], [0], [1], [0], [], [], [], []

根据oracle metalink的Doc ID 99300.1,这是关于index block corrupt的问题,我们来看看该报错的trace文件:

  1. au11qapcwctels2:SCRM01P5:/ora/admin>more /ora/admin/SCRM01P/udump/scrm01p5_ora_11314.trc
  2. Dump file /ora/admin/SCRM01P/udump/scrm01p5_ora_11314.trc
  3. Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
  4. With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
  5. JServer Release 9.2.0.8.0 - Production
  6. ORACLE_HOME = /ora/product/v920
  7. System name:    SunOS
  8. Node name:      au11qapcwctels2
  9. Release:        5.9
  10. Version:        Generic_118558-39
  11. Machine:        sun4u
  12. Instance name: SCRM01P5
  13. Redo thread mounted by this instance: 5
  14. Oracle process number: 959
  15. Unix process pid: 11314, image: oracle@au11qapcwctels2 (TNS V1-V3)
  16. *** 2011-08-05 04:03:41.468
  17. *** SESSION ID:(261.840) 2011-08-05 04:03:41.466
  18. Block header dump:  0xab6090bc
  19. Object id on Block? Y
  20. seg/obj: 0xedddb  csc: 0x9d0.1d45fd41  itc: 10  flg: -  typ: 2 - INDEX
  21.      fsl: 0  fnx: 0x0 ver: 0x01
  22. Itl           Xid                  Uba         Flag  Lck        Scn/Fsc
  23. 0x01   0x0001.002.00f3ce75  0x00877e5e.5d45.05  ----    0  fsc 0x0000.00000000
  24. 0x02   0x1c44.01b.0014993c  0xa143d1c8.30ce.30  ----    5  fsc 0x0000.00000000
  25. 0x03   0x0001.00a.00f3c429  0x00877e5d.5d45.07  ----    1  fsc 0x0000.00000000
  26. 0x04   0x1c45.004.00141e72  0xa19659c7.2eb5.05  ----    1  fsc 0x0000.00000000
  27. 0x05   0x0038.008.0039ef23  0x59191962.a400.2c  ----    1  fsc 0x0000.00000000
  28. 0x06   0x003b.008.0065798f  0x649294b0.e711.29  ----   11  fsc 0x0000.00000000
  29. 0x07   0x1c3f.01a.001a0ab9  0xa1055a58.3755.27  ----    8  fsc 0x0000.00000000
  30. 0x08   0x0015.023.0171bc31  0x5751427a.ca2b.51  C---    0  scn 0x09d0.1d45e782
  31. 0x09   0x1c42.023.00158df3  0xa104bee5.3164.33  ----   12  fsc 0x0000.00000000
  32. 0x0a   0x0027.014.00a83bf4  0x571a0f28.2a8d.46  C---    0  scn 0x09d0.1d45e27f
  33. Leaf block dump
  34. ===============
  35. header address 30216397084=0x70909a11c
  36. kdxcolev 0
  37. KDXCOLEV Flags = - - -
  38. kdxcolok 0
  39. kdxcoopc 0x80: pcode=0: iot flags=--- is converted=Y
  40. kdxconco 4
  41. kdxcosdc 0
  42. kdxconro 302
  43. kdxcofbo 640=0x280
  44. kdxcofeo 659=0x293
  45. kdxcoavs 19
  46. kdxlespl 0
  47. kdxlende 0
  48. kdxlenxt 2588061200=0x9a42ae10
  49. kdxleprv 2875232442=0xab6090ba
  50. kdxledsz 6
  51. kdxlebksz 7840
  52. row#0[4187] flag: -----, lock: 0, data:(6):  2f c4 92 6c 00 01
  53. col 0; len 9; (9):  31 2d 57 57 34 4a 4c 55 51
  54. ......
  55. row#300[7794] flag: -----, lock: 0, data:(6):  1e 82 16 2d 00 13
  56. col 0; len 8; (8):  31 2d 57 57 35 41 4b 4a
  57. col 1; len 2; (2):  c1 07
  58. col 2; NULL
  59. col 3; len 1; (1):  30
  60. row#301[7817] flag: -----, lock: 0, data:(6):  1e 82 14 ba 00 1c
  61. col 0; len 8; (8):  31 2d 57 57 35 41 4b 4a
  62. col 1; len 2; (2):  c1 08
  63. col 2; NULL
  64. col 3; len 1; (1):  30
  65. ----- end of leaf block dump -----
  66. *** 2011-08-05 04:03:41.492
  67. ksedmp: internal or fatal error
  68. ORA-00600: internal error code, arguments: [6122], [0], [1], [0], [], [], [], []
  69. Current SQL statement for this session:
  70. SELECT /*+ ALL_ROWS */
  71.       T55.CONFLICT_ID,
  72.       T**ST_UPD,
  73.       T55.CREATED,
  74.       T**ST_UPD_BY,
  75.       T55.CREATED_BY,
  76.       T55.MODIFICATION_NUM,
  77.       T55.ROW_ID,
  78.       T55.ROW_ID,
  79.       T55.CREATED,
  80.       T55.ATP_MSG,
  81.       T55.ATP_STATUS_CD,
  82.       T55.ATP_STATUS_DT,
  83.       T14.X_FIRST_NAME,
  84.       T28.ACCNT_ID,
  85.       T14.NAME,
  86.       T15.ZIPCODE,
  87.       T13.OU_TYPE_CD,
  88.       T55.ACTION_CD,
  89.       T26.ACTIVITY_ID,
  90.       T55.ACT_PRDINT_ID,
  91.       T55.ADJ_UNIT_PRI,
  92.       T55.CD_X_OLI_SVC_ALL,
  93.       T28.X_APPLICATION_DT,
  94.       T55.X_APPOINTMENT_ID,
  95.       T55.X_APP_NOTES,
  96.       T55.X_APP_OVRIDE_FLG,
  97.       T55.X_APP_OVERIDE_REAS,
  98.       T55.X_APPOINTMENT_FLG,
  99.       T28.APPROVED_FLG,
  100.       T55.STATUS_DT,
  101.       T55.X_ASSET_FLG,
  102.       T55.ASSET_ID,
  103.       T55.ASSET_INTEG_ID,
  104.       T1.PROMOTION_ID,
  105.       T1.START_DT,
  106.       T55.AUC_ITEM_ID,
  107.       T55.X_AUDIT_ETC_MSG,
  108.       T39.X_AUTO_COMPLETION,
  109.       T39.AUTO_UNGROUP_FLG,
  110.       T55.AVAIL_DT,
  111.       T55.AVAIL_QTY,
  112.       T29.PROMOTION_ID,
  113.       T55.LINE_NOTE,
  114.       T55.BASE_UNIT_PRI,
  115.       T49.ATTRIB_08,
  116.       T55.BILLABLE_FLG,
  117.       T46.NAME,
  118.       T55.BILL_ACCNT_ID,
  119.       T55.BONUS_QTY,
  120.       T55.BONUS_THRESHOLD,
  121.       T39.EVENT_SOURCE_CHECK_X_BYPASS,
  122.       T55.X_CCB_ASSET_INTEG_ID,
  123.       T31.BR_ACTN_SET_ID,
  124.       T21.X_KEY_ADDR_ID,
  125.       T55.X_CCB_CFG_STATUS,
  126.       T55.X_CFG_TIME_DT,
  127.       T55.X_CCB_MSB_FLG,
  128.       T39.ONL_PAGESET_ID,
  129.       T39.NAME,
  130.       T55.ORG_PROD_ID,
  131.       T1.SERIAL_NUM,
  132.       T55.X_CALCULATE_ETC,
  133.       T55.CARRIER_CD,
  134.       T39.CASE_PACK,
  135.       T6.RELEASED_FLG,
  136.       T55.CFG_STATE_CD,
  137.       T55.CFG_TYPE_CD,
  138.       T6.VER_NUM,
  139.       T43.LAST_PAY_DUE_DT,
  140.       T55.CRSE_OFFR_ID,
  141.       T55.CRSE_REG_ID,
  142.       T3.STATUS_CD,
  143.       T55.X_COMMIT_DT,
  144.       T55.X_COMMIT_FROM_DT,
  145.       T55.X_COMMIT_TO_DT,
  146.       T55.X_COMMITMENT_FLG,
  147.       T17.CMPND_PROD_NUM,
  148.       T39.CFG_MODEL_ID,
  149.       T4.FST_NAME,
  150.       T55.CONTACT_ID,
  151.       T4.LAST_NAME,
  152.       T55.X_CONTACT_REL_TYPE,
  153.       T55.X_CNTRACT_END_DT,
  154.       T41.LN_NUM,
  155.       T48.NAME,
  156.       T41.ADJ_UNIT_PRI,
  157.       T41.DISCNT_AMT,
  158.       T41.DISCNT_PERCENT,
  159.       T55.SVCD_PROD_ID,
  160.       T41.NET_PRI,
  161.       T41.ROLLUP_PRI,
  162.       T41.UNIT_PRI,
  163.       T55.SVCD_ORDER_ITEM_ID,
  164.       T54.LOGIN,
  165.       T39.CRITICAL_CD,
  166.       T55.ORDER_ITM_CURCY_CD,
  167.       T13.OU_NUM,
  168.       T55.X_CUST_REQ_DT,
  169.       T49.ATTRIB_41,
  170.       T55.X_DSL_STATUS,
  171.       T30.OU_NUM,
  172.       T55.DLVRY_STATUS_CD,
  173.       T55.X_DEPENDANT_ITEM_ID,
  174.       T55.X_DEPENDENT_PRODUCT_ID,
  175.       T49.ATTRIB_34,
  176.       T55.DEST_INVLOC_ID,
  177.       T35.NAME,
  178.       T28.X_DEVICE_PERIOD_THRESHOLD,
  179.       T28.X_DEVICE_VALUE_THRESHOLD,
  180.       T55.DISCNT_AMT,
  181.       T55.DISCNT_PERCENT,
  182.       T55.DISCNT_SRC_CD,
  183.       T55.REQ_SHIP_DT,
  184.       T55.EAI_SYNC_DT,
  185.       T55.X_ETC_PAYMENT_METHOD,
  186.       T55.X_EFF_BILLEND_DT,
  187.       T55.X_EFF_BILLSTART_DT,
  188.       T55.ELIG_REASON,
  189.       T55.ELIG_STATUS_CD,
  190.       T55.ENTLMNT_ID,
  191.       T47.NAME,
  192.       T39.X_EVENT_SRC_OVRRIDE,
  193.       T39.X_EVENT_SRC_TYPE,
  194.       T55.ORDER_ITM_EXCH_DT,
  195.       T55.EXCL_PRICING_FLG,
  196.       T55.EXTD_QTY,
  197.       T55.FRGHT_AMT,
  198.       T55.FRGHT_TERMS_CD,
  199.       T55.X_FULL_FACE_VALUE,
  200.       T55.X_HIBIS_FLG,
  201.       T55.X_HIBIS_ELIG,
  202.       T55.X_HWARE_SUPPLD_FLG,
  203.       T11.OU_NUM,
  204.       T28.X_ID_CHECK_FLG,
  205.       T55.CMPNS_STATUS_CD,
  206.       T55.STATUS_CHANGED_FLG,
  207.       T55.X_INSTALL_DT,
  208.       T55.INTEGRATION_ID,
  209.       T44.NAME,
  210.       T55.PRI_LST_ID,
  211.       T55.RESERVE_STATUS_CD,
  212.       T29.SERVICE_NUM,
  213.       T2.X_EVENT_SRC_TYPE,
  214.       T28.ACCNT_ID,
  215.       T28.PRI_LST_ID,
  216.       T28.TAX_LIST_ID,
  217.       T22.COST_PER_PT,
  218.       T45.DEST_AIRPORT_CD,
  219.       T45.DEST_ZONE_CD,
  220.       T45.ORIG_AIRPORT_CD,
  221.       T45.ORIG_ZONE_CD,
  222.       T51.INTERNAL_NAME,
  223.       T45.LOY_NUM_POINTS,
  224.       T22.NUM_POINTS,
  225.       T45.LOY_PROD_POINT_ID,
  226.       T45.LOY_TXN_TYPE_CD,
  227.       T39.DOWN_TIME,
  228.       T39.ADDL_LEAD_TIME,
  229.       T55.LN_NUM,
  230.       T55.LN_NUM2,
  231.       T55.UNIT_TAX_AMT,
  232.       T29.X_EFF_BILLSTART_DT,
  233.       T29.X_NO_RETAIN,
  234.       T2.PART_NUM,
  235.       T29.X_RECONTRACT_FLAG,
  236.       T29.X_REMEDIATE_FLG,
  237.       T2.PROD_CATG_CD,
  238.       T29.STATUS_CD,
  239.       T29.X_TRANSFER_TYPE,
  240.       T55.PER_MTH_CHG_SUBTOT,
  241.       T55.X_MRC_NET_PRC,
  242.       T39.X_PRC_OVERRIDE_FLG,
  243.       T24.MAX_PRI,
  244.       T39.MAX_ORDER_UNITS,
  245.       T24.MIN_PRI,
  246.       T28.X_MIN_CONTRACTCOST,
  247.       T39.MIN_ORDER_UNITS,
  248.       T55.X_MOLI_EVT_SRC_CD,
  249.       T23.FST_NAME,
  250.       T23.LAST_NAME,
  251.       T55.ONETIME_CHG_SUBTOT,
  252.       T55.X_NRC_NET_PRC,
  253.       T55.X_NRC_OVERRIDE_AMT,
  254.       T55.X_OVRD_REASON_CODE,
  255.       T39.X_NRC_OVRDEN_FLG,
  256.       T55.X_NRC_PRC_OVERRIDE,
  257.       T55.NET_PRI,
  258.       T39.NET_ELMT_TYPE_CD,
  259.       T55.X_NO_RETAIN,
  260.       T55.LINE_NOTE,
  261.       T55.X_NUMBER_MOVE,
  262.       T55.X_O2A_STATUS,
  263.       T49.ATTRIB_02,
  264.       T55.X_OLD_EVENT_SRC,
  265.       T55.X_ORDER_DATE,
  266.       T28.REV_NUM,
  267.       T55.ORDER_ID,
  268.       T28.PAR_ORDER_ID,
  269.       T25.OU_NUM,
  270.       T28.STATUS_CD,
  271.       T38.ATTRIB_03,
  272.       T34.NAME,
  273.       T28.ORDER_TYPE_ID,
  274.       T28.BU_ID,
  275.       T49.ATTRIB_38,
  276.       T28.ACCNT_ID,
  277.       T55.X_PSTN_TRANSFER_CD,
  278.       T55.ITEM_GROUP_NAME,
  279.       T7.TYPE_CD,
  280.       T40.EXTENDED_QTY,
  281.       T55.PAR_ORDER_ITEM_ID,
  282.       T40.ITEM_GROUP_NAME,
  283.       T8.TAX_SUBCOMP_FLG,
  284.       T39.PART_NUM,
  285.       T28.X_PTNR_ORG_ID,
  286.       T55.X_PASSWORD_FLAG,
  287.       T55.X_PATH_ID,
  288.       T55.X_PATH_SEL_OPT_CD,
  289.       T51.DISPLAY_NAME,
  290.       T55.X_PORT_ACCT_NUM,
  291.       T55.X_PORT_BATCH_REF,
  292.       T55.X_PORT_CA_DT,
  293.       T55.X_PORT_CATEGORY,
  294.       T55.X_PORT_DOB,
  295.       T55.X_PORT_GRP_REF,
  296.       T18.FAX_PH_NUM,
  297.       T18.FST_NAME,
  298.       T55.X_PORT_PM_ID,
  299.       T18.LAST_NAME,
  300.       T18.CELL_PH_NUM,
  301.       T18.WORK_PH_NUM,
  302.       T55.X_PORT_REF,
  303.       T55.X_PT_RQST_FST_NAME,
  304.       T55.X_PT_RQST_LST_NAME,
  305.       T55.X_PT_RQST_MOB_PH,
  306.       T55.X_PT_RQST_PH,
  307.       T44.NAME,
  308.       T39.PRICE_TYPE_CD,
  309.       T55.PRICING_COMMENT,
  310.       T53.NAME,
  311.       T42.X_PRIORITY_ASSIST,
  312.       T55.X_PRIORITY_ASSISTANCE,
  313.       T55.PORT_VALID_PROD_ID,
  314.       T55.PROMOTION_ID,
  315.       T55.PROM_INTEG_ID,
  316.       T55.PROM_ITEM_ID,
  317.       T55.PROM_SRC_INTG_ID,
  318.       T20.PROMO_TYPE_CD,
  319.       T39.NAME,
  320.       T39.X_PROD_BILL_FREQ,
  321.       T39.PROD_TYPE_CD,
  322.       T39.EFF_START_DT,
  323.       T39.EFF_END_DT,
  324.       T39.X_GROUP_IDENTIFIER,
  325.       T55.PROD_ID,
  326.       T39.INTEGRATION_ID,
  327.       T55.PROD_PORT_ID,
  328.       T39.PR_PROD_LN_ID,
  329.       T39.CLASS_PARTNUM_ID,
  330.       T55.PROD_STATUS_CD,
  331.       T39.TYPE,
  332.       T39.PROD_CD,
  333.       T39.UOM_CD,
  334.       T52.PAR_VOD_ID,
  335.       T39.NAME,
  336.       T55.PROMO_ID,
  337.       T55.PROMO_ITEM_FLG,
  338.       T39.PROMO_TYPE_CD,
  339.       T39.X_PROVN_FLG,
  340.       T55.X_PRV_COM_DT,
  341.       T55.QTY_MAIN,
  342.       T55.QTY_MINOR,
  343.       T55.X_QTY_ON_ORD,
  344.       T55.QTY_REQ,
  345.       T55.X_QTY_STOCK,
  346.       T55.X_QTY_BK_ORD,
  347.       T55.X_RAPID_CHURN,
  348.       T28.X_REAS_CD,
  349.       T55.X_RECONTRACT_FLAG,
  350.       T28.X_RECORDS_ONLY_FLG,
  351.       T55.X_REMEDIATE_FLG,
  352.       T39.X_REQ_SRV_DEP_FLG,
  353.       T55.X_RETAIN_PROMOTION,
  354.       T55.RTRN_ADDR_ID,
  355.       T55.RTRN_CON_ID,
  356.       T55.PREV_ITEM_REV_ID,
  357.       T28.REVISION_DT,
  358.       T55.ROLLUP_PRI,
  359.       T29.ACTION_CD,
  360.       T29.ASSET_INTEG_ID,
  361.       T29.X_BOOKING_REQ_FLG,
  362.       T29.CFG_TYPE_CD,
  363.       T29.PRI_LST_ID,
  364.       T29.QTY_REQ,
  365.       T29.REQ_SHIP_DT,
  366.       T55.ROOT_ORDER_ITEM_ID,
  367.       T29.ITEM_GROUP_NAME,
  368.       T2.PROD_TYPE_CD,
  369.       T29.PROD_ID,
  370.       T2.NAME,
  371.       T2.TYPE,
  372.       T2.SERV_INST_FLG,
  373.       T50.NAME,
  374.       T55.X_SIM_REPLACE_REAS,
  375.       T55.X_SIM_VALIDITY,
  376.       T55.X_SQ_DT,
  377.       T55.X_SQ_INITIATOR,
  378.       T55.X_SQ_OVRD_FLG,
  379.       T55.X_SQ_OVRD_REAS,
  380.       T39.SALES_SRVC_FLG,
  381.       T42.NAME,
  382.       T55.SERV_ACCNT_ID,
  383.       T19.X_KEY_ADDR_ID,
  384.       T39.X_SRV_ACCNT_REQ,
  385.       T17.SERVICE_END_DT,
  386.       T55.SERVICE_NUM,
  387.       T39.SERV_INST_FLG,
  388.       T17.SERVICE_LENGTH,
  389.       T17.SERV_LENGTH_UOM_CD,
  390.       T55.SVC_PER_PROD_AMT,
  391.       T55.PRI_METH_CD,
  392.       T55.SVC_PER_PROD_PCT,
  393.       T17.SERVICE_START_DT,
  394.       T39.PROD_CATG_CD,
  395.       T39.X_SRV_AVL_CHK_FLG,
  396.       T55.X_SERVICE_RESULTS,
  397.       T55.SHIP_COMPLETE_FLG,
  398.       T55.X_SHIP_TO_ADDR,
  399.       T14.NAME,
  400.       T55.SHIP_OU_ID,
  401.       T14.INTEGRATION_ID,
  402.       T55.SHIP_ADDR_ID,
  403.       T55.SHIP_ADDR_ID,
  404.       T12.FST_NAME,
  405.       T12.LAST_NAME,
  406.       T55.SHIP_CON_ID,
  407.       T39.X_SHIP_TO_ADDR_REQ,
  408.       T28.X_SIGNATURE_REF,
  409.       T39.X_SINGLE_BILL_FLG,
  410.       T55.X_AVAIL_CD,
  411.       T55.X_SITE_CONTACT,
  412.       T55.X_SITE_CONTACT_PH,
  413.       T55.SP_NUM,
  414.       T55.SRC_INVLOC_ID,
  415.       T50.INTEGRATION_ID,
  416.       T50.NAME,
  417.       T50.RECV_TO_ADDR_ID,
  418.       T10.ZIPCODE,
  419.       T55.STATUS_CD,
  420.       T55.EXTND_PRICE,
  421.       T55.EXTND_TAX,
  422.       T39.X_SUS_RES_CUS_FLG,
  423.       T39.X_SUSP_SERV_FLG,
  424.       T28.X_TC_GENERATE_FLG,
  425.       T55.TAX_AMT,
  426.       T55.TAX_EXEMPT_FLG,
  427.       T36.NAME,
  428.       T39.TAX_SUBCOMP_FLG,
  429.       T39.X_CONN_BOOK_FLG,
  430.       T55.X_TRANSFER_TYPE,
  431.       T55.UNIT_PRI,
  432.       T39.UOM_CD,
  433.       T5.PROD_CATG_CD,
  434.       T27.ROW_ID,
  435.       T55.X_VALID_FLG,
  436.       T55.VOL_DISCNT_ID,
  437.       T55.VOL_DISCNT_ITEM_ID,
  438.       T9.MAX_QTY,
  439.       T55.DISCNT_METH_CD,
  440.       T9.MIN_QTY,
  441.       T55.VOL_UPSELL_ITEM_ID,
  442.       T55.VOL_UPSELL_MSG_TXT,
  443.       T55.X_VOL_SUSP_DT,
  444.       T39.X_WAIVABLE_FLG,
  445.       T55.X_WAIVE_ETC_FLG,
  446.       T55.X_WAIVE_ETC_REAS,
  447.       T55.X_WORKFORCE_INDICATOR_ID,
  448.       T55.PROD_NAME,
  449.       T39.X_ALP_C01,
  450.       T28.X_ACTION_TYPE_V30,
  451.       T39.PART_NUM,
  452.       T39.X_ACTIVATION_C01,
  453.       T39.BILLABLE_FLG,
  454.       T13.MARKET_CLASS_CD,
  455.       T33.BILL_FREQ_CD,
  456.       T46.X_TIPO_CUENTA_C30,
  457.       T55.X_BILL_ADD_FLAG,
  458.       T2.X_PAYMENT_MODALITY_V30,
  459.       T39.X_PAYMENT_MODALITY_V30,
  460.       T46.X_TIPO_CUENTA_C30,
  461.       T13.MARKET_CLASS_CD,
  462.       T32.ADDR,
  463.       T32.CITY,
  464.       T32.COUNTRY,
  465.       T32.ZIPCODE,
  466.       T43.ROW_ID,
  467.       T43.MODIFICATION_NUM,
  468.       T43.CREATED_BY,
  469.       T43.LAST_UPD_BY,
  470.       T43.CREATED,
  471.       T43.LAST_UPD,
  472.       T43.CONFLICT_ID,
  473.       T43.PAR_ROW_ID,
  474.       T17.ROW_ID,
  475.       T17.MODIFICATION_NUM,
  476.       T17.CREATED_BY,
  477.       T17.LAST_UPD_BY,
  478.       T17.CREATED,
  479.       T17.LAST_UPD,
  480.       T17.CONFLICT_ID,
  481.       T17.PAR_ROW_ID,
  482.       T49.ROW_ID,
  483.       T49.MODIFICATION_NUM,
  484.       T49.CREATED_BY,
  485.       T49.LAST_UPD_BY,
  486.       T49.CREATED,
  487.       T49.LAST_UPD,
  488.       T49.CONFLICT_ID,
  489.       T49.PAR_ROW_ID,
  490.       T24.ROW_ID,
  491.       T24.MODIFICATION_NUM,
  492.       T24.CREATED_BY,
  493.       T24.LAST_UPD_BY,
  494.       T24.CREATED,
  495.       T24.LAST_UPD,
  496.       T24.CONFLICT_ID,
  497.       T24.PAR_ROW_ID,
  498.       T45.ROW_ID,
  499.       T45.MODIFICATION_NUM,
  500.       T45.CREATED_BY,
  501.       T45.LAST_UPD_BY,
  502.       T45.CREATED,
  503.       T45.LAST_UPD,
  504.       T45.CONFLICT_ID,
  505.       T45.PAR_ROW_ID,
  506.       T32.ROW_ID
  507.    FROM
  508.        BELSIE.S_ASSET T1,
  509.        BELSIE.S_PROD_INT T2,
  510.        BELSIE.S_SRC_EVT_REG T3,
  511.        BELSIE.S_CONTACT T4,
  512.        BELSIE.S_PROD_INT T5,
  513.        BELSIE.S_VOD_VER T6,
  514.        BELSIE.S_CTLG_CAT T7,
  515.        BELSIE.S_PROD_INT T8,
  516.        BELSIE.S_VDISCNT_ITEM T9,
  517.        BELSIE.S_ADDR_PER T10,
  518.        BELSIE.S_ORG_EXT T11,
  519.        BELSIE.S_CONTACT T12,
  520.        BELSIE.S_ORG_EXT T13,
  521.        BELSIE.S_ORG_EXT T14,
  522.        BELSIE.S_ADDR_PER T15,
  523.        BELSIE.S_ASSET T16,
  524.        BELSIE.ITEM_S_ORDER_OM T17,
  525.        BELSIE.S_CONTACT T18,
  526.        BELSIE.S_ADDR_PER T19,
  527.        BELSIE.S_PROD_INT T20,
  528.        BELSIE.S_ADDR_PER T21,
  529.        BELSIE.S_LOY_PROD_PT T22,
  530.        BELSIE.S_CONTACT T23,
  531.        BELSIE.S_ORDER_ITM_PRI T24,
  532.        BELSIE.S_ORG_EXT T25,
  533.        BELSIE.S_ACT_PRDINT T26,
  534.        BELSIE.S_VOD T27,
  535.        BELSIE.S_ORDER T28,
  536.        BELSIE.ITEM_S_ORDER T29,
  537.        BELSIE.S_ORG_EXT T30,
  538.        BELSIE.S_ORDER_ACTNSET T31,
  539.        BELSIE.S_ADDR_PER T32,
  540.        BELSIE.S_INV_PROF T33,
  541.        BELSIE.S_ORDER_TYPE T34,
  542.        BELSIE.S_INVLOC T35,
  543.        BELSIE.S_PRI_LST T36,
  544.        BELSIE.S_CTLG_CAT T37,
  545.        BELSIE.S_ORDER_X T38,
  546.        BELSIE.S_PROD_INT T39,
  547.        BELSIE.ITEM_S_ORDER T40,
  548.        BELSIE.ITEM_S_ORDER T41,
  549.        BELSIE.S_ORG_EXT T42,
  550.        BELSIE.TRMS_S_ORDERITM T43,
  551.        BELSIE.S_PRI_LST T44,
  552.        BELSIE.S_ORD_ITM_LOYX T45,
  553.        BELSIE.S_ORG_EXT T46,
  554.        BELSIE.S_ENTLMNT T47,
  555.        BELSIE.S_PROD_INT T48,
  556.        BELSIE.ITEM_S_ORDER_X T49,
  557.        BELSIE.S_INVLOC T50,
  558.        BELSIE.S_LOY_ATTRDEFN T51,
  559.        BELSIE.S_ISS_OBJ_DEF T52,
  560.        BELSIE.S_PROD_LN T53,
  561.        BELSIE.S_USER T54,
  562.        BELSIE.ITEM_S_ORDER T55
  563.    WHERE
  564.       T42.PR_ADDR_ID = T19.ROW_ID (+) AND
  565.       T16.PROD_ID = T5.ROW_ID (+) AND
  566.       T28.TAX_LIST_ID = T36.ROW_ID (+) AND
  567.       T55.SRC_INVLOC_ID = T50.ROW_ID (+) AND
  568.       T55.SHIP_CON_ID = T12.PAR_ROW_ID (+) AND
  569.       T55.SHIP_OU_ID = T14.PAR_ROW_ID (+) AND
  570.       T50.RECV_TO_ADDR_ID = T10.ROW_ID (+) AND
  571.       T55.SERV_ACCNT_ID = T42.PAR_ROW_ID (+) AND
  572.       T27.ROW_ID = T6.VOD_ID (+) AND
  573.       T39.CFG_MODEL_ID = T27.OBJECT_NUM (+) AND
  574.       T55.VOL_DISCNT_ITEM_ID = T9.ROW_ID (+) AND
  575.       T55.PROD_ID = T39.ROW_ID (+) AND
  576.       T55.ORDER_ID = T38.ROW_ID (+) AND
  577.       T28.ORDER_TYPE_ID = T34.ROW_ID (+) AND
  578.       T55.ORDER_ID = T31.ORDER_ID (+) AND
  579.       T55.ORDER_ID = T28.ROW_ID (+) AND
  580.       T27.ROW_ID = T52.VOD_ID (+) AND
  581.       T55.BILL_ACCNT_ID = T33.ACCNT_ID (+) AND
  582.       T55.ENTLMNT_ID = T47.ROW_ID (+) AND
  583.       T55.CONTACT_ID = T4.ROW_ID (+) AND
  584.       T55.ASSET_ID = T16.ROW_ID (+) AND
  585.       T55.PRI_LST_ID = T44.ROW_ID (+) AND
  586.       T55.PROMOTION_ID = T20.ROW_ID (+) AND
  587.       T13.PR_ADDR_ID = T15.ROW_ID (+) AND
  588.       T55.ACT_PRDINT_ID = T26.ROW_ID (+) AND
  589.       T29.PROD_ID = T2.ROW_ID (+) AND
  590.       T55.ROOT_ORDER_ITEM_ID = T29.ROW_ID (+) AND
  591.       T2.PR_PROD_LN_ID = T53.ROW_ID (+) AND
  592.       T28.BU_ID = T30.PAR_ROW_ID (+) AND
  593.       T55.X_PORT_PM_ID = T18.ROW_ID (+) AND
  594.       T28.X_PTNR_ORG_ID = T11.PAR_ROW_ID (+) AND
  595.       T40.PROD_ID = T8.ROW_ID (+) AND
  596.       T55.PAR_ORDER_ITEM_ID = T40.ROW_ID (+) AND
  597.       T37.CG_PAR_CTLG_CAT_ID = T7.ROW_ID (+) AND
  598.       T28.X_PTNR_ORG_ID = T25.PAR_ROW_ID (+) AND
  599.       T28.ACCNT_ID = T13.PAR_ROW_ID (+) AND
  600.       T49.ATTRIB_05 = T23.PAR_ROW_ID (+) AND
  601.       T45.LOY_PROD_POINT_ID = T22.ROW_ID (+) AND
  602.       T22.POINT_TYPE_ID = T51.ROW_ID (+) AND
  603.       T55.DEST_INVLOC_ID = T35.ROW_ID (+) AND
  604.       T55.CREATED_BY = T54.PAR_ROW_ID (+) AND
  605.       T55.SVCD_PROD_ID = T48.ROW_ID (+) AND
  606.       T55.SVCD_ORDER_ITEM_ID = T41.ROW_ID (+) AND
  607.       T55.CRSE_REG_ID = T3.ROW_ID (+) AND
  608.       T55.PROD_SUB_CAT_ID = T37.ROW_ID (+) AND
  609.       T46.PR_BL_ADDR_ID = T21.ROW_ID (+) AND
  610.       T55.ASSET_INTEG_ID = T1.INTEGRATION_ID (+) AND
  611.       T55.BILL_ACCNT_ID = T46.PAR_ROW_ID (+) AND
  612.       T55.ROW_ID = T43.PAR_ROW_ID (+) AND
  613.       T55.ROW_ID = T17.PAR_ROW_ID (+) AND
  614.       T55.ROW_ID = T49.PAR_ROW_ID (+) AND
  615.       T55.ROW_ID = T24.PAR_ROW_ID (+) AND
  616.       T55.ROW_ID = T45.PAR_ROW_ID (+) AND
  617.       T55.SHIP_ADDR_ID = T32.ROW_ID (+) AND
  618.       (T55.PROD_ID IS NULL OR T6.RELEASED_FLG = 'Y' AND T6.START_DT <= TO_DATE(:1,'MM/DD/YYYY HH24:MI:SS') AND (T6.END_DT IS NULL OR
  619.  T6.END_DT > TO_DATE(:2,'MM/DD/YYYY HH24:MI:SS')) AND T52.FIRST_VERS <= T6.VER_NUM AND T52.LAST_VERS >= T6.VER_NUM) AND
  620.       (T55.ORDER_ID = :3 AND T55.X_TRANSFER_TYPE IS NOT NULL) AND
  621.       (T55.ORDER_ID = :4)
  622.    ORDER BY
  623.       T55.ORDER_ID, T55.LN_NUM

从trace文件中,我们可以获得一些信息:
在21行,seg/obj: 0xedddb,这里显示了data object id,在72行开始,还显示了一个很长的sql,这个sql就是引起ora600[6122]的sql。

那么究竟是这个sql中的哪个表,哪个索引引起了ora600?

根据21行的seg/obj: 0xedddb,我们把edddb从16进制转换成十进制,974299,然后找其对象:

1* select OBJECT_NAME,OWNER,OBJECT_TYPE from dba_objects where DATA_OBJECT_ID=974299
SQL> /
 
OBJECT_NAME                    OWNER                          OBJECT_TYPE
------------------------------ ------------------------------ ------------------
ITEM_S_ORDER_U1                BELSIE                         INDEX

我们检验一下这个索引说对应的表,是不是trace文件中的表:

SQL> select owner,table_name from dba_indexes where index_name='ITEM_S_ORDER_U1';
 
OWNER                          TABLE_NAME
------------------------------ ------------------------------
BELSIE                         ITEM_S_ORDER
 
SQL>

我们看到该表确实是在539行出现。

因此,找到该对象后,找个时间进行索引的drop,create重建,问题解决。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16400082/viewspace-707020/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-12-29

  • 博文量
    70
  • 访问量
    164284