ORA-600[6122]錯誤處理

tian1982tian發表於2011-09-09

接到一個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檔案：

au11qapcwctels2:SCRM01P5:/ora/admin>more /ora/admin/SCRM01P/udump/scrm01p5_ora_11314.trc
Dump file /ora/admin/SCRM01P/udump/scrm01p5_ora_11314.trc
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
ORACLE_HOME = /ora/product/v920
System name: SunOS
Node name: au11qapcwctels2
Release: 5.9
Version: Generic_118558-39
Machine: sun4u
Instance name: SCRM01P5
Redo thread mounted by this instance: 5
Oracle process number: 959
Unix process pid: 11314, image: oracle@au11qapcwctels2 (TNS V1-V3)
*** 2011-08-05 04:03:41.468
*** SESSION ID:(261.840) 2011-08-05 04:03:41.466
Block header dump: 0xab6090bc
Object id on Block? Y
seg/obj: 0xedddb csc: 0x9d0.1d45fd41 itc: 10 flg: - typ: 2 - INDEX
fsl: 0 fnx: 0x0 ver: 0x01
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0001.002.00f3ce75 0x00877e5e.5d45.05 ---- 0 fsc 0x0000.00000000
0x02 0x1c44.01b.0014993c 0xa143d1c8.30ce.30 ---- 5 fsc 0x0000.00000000
0x03 0x0001.00a.00f3c429 0x00877e5d.5d45.07 ---- 1 fsc 0x0000.00000000
0x04 0x1c45.004.00141e72 0xa19659c7.2eb5.05 ---- 1 fsc 0x0000.00000000
0x05 0x0038.008.0039ef23 0x59191962.a400.2c ---- 1 fsc 0x0000.00000000
0x06 0x003b.008.0065798f 0x649294b0.e711.29 ---- 11 fsc 0x0000.00000000
0x07 0x1c3f.01a.001a0ab9 0xa1055a58.3755.27 ---- 8 fsc 0x0000.00000000
0x08 0x0015.023.0171bc31 0x5751427a.ca2b.51 C--- 0 scn 0x09d0.1d45e782
0x09 0x1c42.023.00158df3 0xa104bee5.3164.33 ---- 12 fsc 0x0000.00000000
0x0a 0x0027.014.00a83bf4 0x571a0f28.2a8d.46 C--- 0 scn 0x09d0.1d45e27f
Leaf block dump
===============
header address 30216397084=0x70909a11c
kdxcolev 0
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: pcode=0: iot flags=--- is converted=Y
kdxconco 4
kdxcosdc 0
kdxconro 302
kdxcofbo 640=0x280
kdxcofeo 659=0x293
kdxcoavs 19
kdxlespl 0
kdxlende 0
kdxlenxt 2588061200=0x9a42ae10
kdxleprv 2875232442=0xab6090ba
kdxledsz 6
kdxlebksz 7840
row#0[4187] flag: -----, lock: 0, data:(6): 2f c4 92 6c 00 01
col 0; len 9; (9): 31 2d 57 57 34 4a 4c 55 51
......
row#300[7794] flag: -----, lock: 0, data:(6): 1e 82 16 2d 00 13
col 0; len 8; (8): 31 2d 57 57 35 41 4b 4a
col 1; len 2; (2): c1 07
col 2; NULL
col 3; len 1; (1): 30
row#301[7817] flag: -----, lock: 0, data:(6): 1e 82 14 ba 00 1c
col 0; len 8; (8): 31 2d 57 57 35 41 4b 4a
col 1; len 2; (2): c1 08
col 2; NULL
col 3; len 1; (1): 30
----- end of leaf block dump -----
*** 2011-08-05 04:03:41.492
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [6122], [0], [1], [0], [], [], [], []
Current SQL statement for this session:
SELECT /*+ ALL_ROWS */
T55.CONFLICT_ID,
T**ST_UPD,
T55.CREATED,
T**ST_UPD_BY,
T55.CREATED_BY,
T55.MODIFICATION_NUM,
T55.ROW_ID,
T55.ROW_ID,
T55.CREATED,
T55.ATP_MSG,
T55.ATP_STATUS_CD,
T55.ATP_STATUS_DT,
T14.X_FIRST_NAME,
T28.ACCNT_ID,
T14.NAME,
T15.ZIPCODE,
T13.OU_TYPE_CD,
T55.ACTION_CD,
T26.ACTIVITY_ID,
T55.ACT_PRDINT_ID,
T55.ADJ_UNIT_PRI,
T55.CD_X_OLI_SVC_ALL,
T28.X_APPLICATION_DT,
T55.X_APPOINTMENT_ID,
T55.X_APP_NOTES,
T55.X_APP_OVRIDE_FLG,
T55.X_APP_OVERIDE_REAS,
T55.X_APPOINTMENT_FLG,
T28.APPROVED_FLG,
T55.STATUS_DT,
T55.X_ASSET_FLG,
T55.ASSET_ID,
T55.ASSET_INTEG_ID,
T1.PROMOTION_ID,
T1.START_DT,
T55.AUC_ITEM_ID,
T55.X_AUDIT_ETC_MSG,
T39.X_AUTO_COMPLETION,
T39.AUTO_UNGROUP_FLG,
T55.AVAIL_DT,
T55.AVAIL_QTY,
T29.PROMOTION_ID,
T55.LINE_NOTE,
T55.BASE_UNIT_PRI,
T49.ATTRIB_08,
T55.BILLABLE_FLG,
T46.NAME,
T55.BILL_ACCNT_ID,
T55.BONUS_QTY,
T55.BONUS_THRESHOLD,
T39.EVENT_SOURCE_CHECK_X_BYPASS,
T55.X_CCB_ASSET_INTEG_ID,
T31.BR_ACTN_SET_ID,
T21.X_KEY_ADDR_ID,
T55.X_CCB_CFG_STATUS,
T55.X_CFG_TIME_DT,
T55.X_CCB_MSB_FLG,
T39.ONL_PAGESET_ID,
T39.NAME,
T55.ORG_PROD_ID,
T1.SERIAL_NUM,
T55.X_CALCULATE_ETC,
T55.CARRIER_CD,
T39.CASE_PACK,
T6.RELEASED_FLG,
T55.CFG_STATE_CD,
T55.CFG_TYPE_CD,
T6.VER_NUM,
T43.LAST_PAY_DUE_DT,
T55.CRSE_OFFR_ID,
T55.CRSE_REG_ID,
T3.STATUS_CD,
T55.X_COMMIT_DT,
T55.X_COMMIT_FROM_DT,
T55.X_COMMIT_TO_DT,
T55.X_COMMITMENT_FLG,
T17.CMPND_PROD_NUM,
T39.CFG_MODEL_ID,
T4.FST_NAME,
T55.CONTACT_ID,
T4.LAST_NAME,
T55.X_CONTACT_REL_TYPE,
T55.X_CNTRACT_END_DT,
T41.LN_NUM,
T48.NAME,
T41.ADJ_UNIT_PRI,
T41.DISCNT_AMT,
T41.DISCNT_PERCENT,
T55.SVCD_PROD_ID,
T41.NET_PRI,
T41.ROLLUP_PRI,
T41.UNIT_PRI,
T55.SVCD_ORDER_ITEM_ID,
T54.LOGIN,
T39.CRITICAL_CD,
T55.ORDER_ITM_CURCY_CD,
T13.OU_NUM,
T55.X_CUST_REQ_DT,
T49.ATTRIB_41,
T55.X_DSL_STATUS,
T30.OU_NUM,
T55.DLVRY_STATUS_CD,
T55.X_DEPENDANT_ITEM_ID,
T55.X_DEPENDENT_PRODUCT_ID,
T49.ATTRIB_34,
T55.DEST_INVLOC_ID,
T35.NAME,
T28.X_DEVICE_PERIOD_THRESHOLD,
T28.X_DEVICE_VALUE_THRESHOLD,
T55.DISCNT_AMT,
T55.DISCNT_PERCENT,
T55.DISCNT_SRC_CD,
T55.REQ_SHIP_DT,
T55.EAI_SYNC_DT,
T55.X_ETC_PAYMENT_METHOD,
T55.X_EFF_BILLEND_DT,
T55.X_EFF_BILLSTART_DT,
T55.ELIG_REASON,
T55.ELIG_STATUS_CD,
T55.ENTLMNT_ID,
T47.NAME,
T39.X_EVENT_SRC_OVRRIDE,
T39.X_EVENT_SRC_TYPE,
T55.ORDER_ITM_EXCH_DT,
T55.EXCL_PRICING_FLG,
T55.EXTD_QTY,
T55.FRGHT_AMT,
T55.FRGHT_TERMS_CD,
T55.X_FULL_FACE_VALUE,
T55.X_HIBIS_FLG,
T55.X_HIBIS_ELIG,
T55.X_HWARE_SUPPLD_FLG,
T11.OU_NUM,
T28.X_ID_CHECK_FLG,
T55.CMPNS_STATUS_CD,
T55.STATUS_CHANGED_FLG,
T55.X_INSTALL_DT,
T55.INTEGRATION_ID,
T44.NAME,
T55.PRI_LST_ID,
T55.RESERVE_STATUS_CD,
T29.SERVICE_NUM,
T2.X_EVENT_SRC_TYPE,
T28.ACCNT_ID,
T28.PRI_LST_ID,
T28.TAX_LIST_ID,
T22.COST_PER_PT,
T45.DEST_AIRPORT_CD,
T45.DEST_ZONE_CD,
T45.ORIG_AIRPORT_CD,
T45.ORIG_ZONE_CD,
T51.INTERNAL_NAME,
T45.LOY_NUM_POINTS,
T22.NUM_POINTS,
T45.LOY_PROD_POINT_ID,
T45.LOY_TXN_TYPE_CD,
T39.DOWN_TIME,
T39.ADDL_LEAD_TIME,
T55.LN_NUM,
T55.LN_NUM2,
T55.UNIT_TAX_AMT,
T29.X_EFF_BILLSTART_DT,
T29.X_NO_RETAIN,
T2.PART_NUM,
T29.X_RECONTRACT_FLAG,
T29.X_REMEDIATE_FLG,
T2.PROD_CATG_CD,
T29.STATUS_CD,
T29.X_TRANSFER_TYPE,
T55.PER_MTH_CHG_SUBTOT,
T55.X_MRC_NET_PRC,
T39.X_PRC_OVERRIDE_FLG,
T24.MAX_PRI,
T39.MAX_ORDER_UNITS,
T24.MIN_PRI,
T28.X_MIN_CONTRACTCOST,
T39.MIN_ORDER_UNITS,
T55.X_MOLI_EVT_SRC_CD,
T23.FST_NAME,
T23.LAST_NAME,
T55.ONETIME_CHG_SUBTOT,
T55.X_NRC_NET_PRC,
T55.X_NRC_OVERRIDE_AMT,
T55.X_OVRD_REASON_CODE,
T39.X_NRC_OVRDEN_FLG,
T55.X_NRC_PRC_OVERRIDE,
T55.NET_PRI,
T39.NET_ELMT_TYPE_CD,
T55.X_NO_RETAIN,
T55.LINE_NOTE,
T55.X_NUMBER_MOVE,
T55.X_O2A_STATUS,
T49.ATTRIB_02,
T55.X_OLD_EVENT_SRC,
T55.X_ORDER_DATE,
T28.REV_NUM,
T55.ORDER_ID,
T28.PAR_ORDER_ID,
T25.OU_NUM,
T28.STATUS_CD,
T38.ATTRIB_03,
T34.NAME,
T28.ORDER_TYPE_ID,
T28.BU_ID,
T49.ATTRIB_38,
T28.ACCNT_ID,
T55.X_PSTN_TRANSFER_CD,
T55.ITEM_GROUP_NAME,
T7.TYPE_CD,
T40.EXTENDED_QTY,
T55.PAR_ORDER_ITEM_ID,
T40.ITEM_GROUP_NAME,
T8.TAX_SUBCOMP_FLG,
T39.PART_NUM,
T28.X_PTNR_ORG_ID,
T55.X_PASSWORD_FLAG,
T55.X_PATH_ID,
T55.X_PATH_SEL_OPT_CD,
T51.DISPLAY_NAME,
T55.X_PORT_ACCT_NUM,
T55.X_PORT_BATCH_REF,
T55.X_PORT_CA_DT,
T55.X_PORT_CATEGORY,
T55.X_PORT_DOB,
T55.X_PORT_GRP_REF,
T18.FAX_PH_NUM,
T18.FST_NAME,
T55.X_PORT_PM_ID,
T18.LAST_NAME,
T18.CELL_PH_NUM,
T18.WORK_PH_NUM,
T55.X_PORT_REF,
T55.X_PT_RQST_FST_NAME,
T55.X_PT_RQST_LST_NAME,
T55.X_PT_RQST_MOB_PH,
T55.X_PT_RQST_PH,
T44.NAME,
T39.PRICE_TYPE_CD,
T55.PRICING_COMMENT,
T53.NAME,
T42.X_PRIORITY_ASSIST,
T55.X_PRIORITY_ASSISTANCE,
T55.PORT_VALID_PROD_ID,
T55.PROMOTION_ID,
T55.PROM_INTEG_ID,
T55.PROM_ITEM_ID,
T55.PROM_SRC_INTG_ID,
T20.PROMO_TYPE_CD,
T39.NAME,
T39.X_PROD_BILL_FREQ,
T39.PROD_TYPE_CD,
T39.EFF_START_DT,
T39.EFF_END_DT,
T39.X_GROUP_IDENTIFIER,
T55.PROD_ID,
T39.INTEGRATION_ID,
T55.PROD_PORT_ID,
T39.PR_PROD_LN_ID,
T39.CLASS_PARTNUM_ID,
T55.PROD_STATUS_CD,
T39.TYPE,
T39.PROD_CD,
T39.UOM_CD,
T52.PAR_VOD_ID,
T39.NAME,
T55.PROMO_ID,
T55.PROMO_ITEM_FLG,
T39.PROMO_TYPE_CD,
T39.X_PROVN_FLG,
T55.X_PRV_COM_DT,
T55.QTY_MAIN,
T55.QTY_MINOR,
T55.X_QTY_ON_ORD,
T55.QTY_REQ,
T55.X_QTY_STOCK,
T55.X_QTY_BK_ORD,
T55.X_RAPID_CHURN,
T28.X_REAS_CD,
T55.X_RECONTRACT_FLAG,
T28.X_RECORDS_ONLY_FLG,
T55.X_REMEDIATE_FLG,
T39.X_REQ_SRV_DEP_FLG,
T55.X_RETAIN_PROMOTION,
T55.RTRN_ADDR_ID,
T55.RTRN_CON_ID,
T55.PREV_ITEM_REV_ID,
T28.REVISION_DT,
T55.ROLLUP_PRI,
T29.ACTION_CD,
T29.ASSET_INTEG_ID,
T29.X_BOOKING_REQ_FLG,
T29.CFG_TYPE_CD,
T29.PRI_LST_ID,
T29.QTY_REQ,
T29.REQ_SHIP_DT,
T55.ROOT_ORDER_ITEM_ID,
T29.ITEM_GROUP_NAME,
T2.PROD_TYPE_CD,
T29.PROD_ID,
T2.NAME,
T2.TYPE,
T2.SERV_INST_FLG,
T50.NAME,
T55.X_SIM_REPLACE_REAS,
T55.X_SIM_VALIDITY,
T55.X_SQ_DT,
T55.X_SQ_INITIATOR,
T55.X_SQ_OVRD_FLG,
T55.X_SQ_OVRD_REAS,
T39.SALES_SRVC_FLG,
T42.NAME,
T55.SERV_ACCNT_ID,
T19.X_KEY_ADDR_ID,
T39.X_SRV_ACCNT_REQ,
T17.SERVICE_END_DT,
T55.SERVICE_NUM,
T39.SERV_INST_FLG,
T17.SERVICE_LENGTH,
T17.SERV_LENGTH_UOM_CD,
T55.SVC_PER_PROD_AMT,
T55.PRI_METH_CD,
T55.SVC_PER_PROD_PCT,
T17.SERVICE_START_DT,
T39.PROD_CATG_CD,
T39.X_SRV_AVL_CHK_FLG,
T55.X_SERVICE_RESULTS,
T55.SHIP_COMPLETE_FLG,
T55.X_SHIP_TO_ADDR,
T14.NAME,
T55.SHIP_OU_ID,
T14.INTEGRATION_ID,
T55.SHIP_ADDR_ID,
T55.SHIP_ADDR_ID,
T12.FST_NAME,
T12.LAST_NAME,
T55.SHIP_CON_ID,
T39.X_SHIP_TO_ADDR_REQ,
T28.X_SIGNATURE_REF,
T39.X_SINGLE_BILL_FLG,
T55.X_AVAIL_CD,
T55.X_SITE_CONTACT,
T55.X_SITE_CONTACT_PH,
T55.SP_NUM,
T55.SRC_INVLOC_ID,
T50.INTEGRATION_ID,
T50.NAME,
T50.RECV_TO_ADDR_ID,
T10.ZIPCODE,
T55.STATUS_CD,
T55.EXTND_PRICE,
T55.EXTND_TAX,
T39.X_SUS_RES_CUS_FLG,
T39.X_SUSP_SERV_FLG,
T28.X_TC_GENERATE_FLG,
T55.TAX_AMT,
T55.TAX_EXEMPT_FLG,
T36.NAME,
T39.TAX_SUBCOMP_FLG,
T39.X_CONN_BOOK_FLG,
T55.X_TRANSFER_TYPE,
T55.UNIT_PRI,
T39.UOM_CD,
T5.PROD_CATG_CD,
T27.ROW_ID,
T55.X_VALID_FLG,
T55.VOL_DISCNT_ID,
T55.VOL_DISCNT_ITEM_ID,
T9.MAX_QTY,
T55.DISCNT_METH_CD,
T9.MIN_QTY,
T55.VOL_UPSELL_ITEM_ID,
T55.VOL_UPSELL_MSG_TXT,
T55.X_VOL_SUSP_DT,
T39.X_WAIVABLE_FLG,
T55.X_WAIVE_ETC_FLG,
T55.X_WAIVE_ETC_REAS,
T55.X_WORKFORCE_INDICATOR_ID,
T55.PROD_NAME,
T39.X_ALP_C01,
T28.X_ACTION_TYPE_V30,
T39.PART_NUM,
T39.X_ACTIVATION_C01,
T39.BILLABLE_FLG,
T13.MARKET_CLASS_CD,
T33.BILL_FREQ_CD,
T46.X_TIPO_CUENTA_C30,
T55.X_BILL_ADD_FLAG,
T2.X_PAYMENT_MODALITY_V30,
T39.X_PAYMENT_MODALITY_V30,
T46.X_TIPO_CUENTA_C30,
T13.MARKET_CLASS_CD,
T32.ADDR,
T32.CITY,
T32.COUNTRY,
T32.ZIPCODE,
T43.ROW_ID,
T43.MODIFICATION_NUM,
T43.CREATED_BY,
T43.LAST_UPD_BY,
T43.CREATED,
T43.LAST_UPD,
T43.CONFLICT_ID,
T43.PAR_ROW_ID,
T17.ROW_ID,
T17.MODIFICATION_NUM,
T17.CREATED_BY,
T17.LAST_UPD_BY,
T17.CREATED,
T17.LAST_UPD,
T17.CONFLICT_ID,
T17.PAR_ROW_ID,
T49.ROW_ID,
T49.MODIFICATION_NUM,
T49.CREATED_BY,
T49.LAST_UPD_BY,
T49.CREATED,
T49.LAST_UPD,
T49.CONFLICT_ID,
T49.PAR_ROW_ID,
T24.ROW_ID,
T24.MODIFICATION_NUM,
T24.CREATED_BY,
T24.LAST_UPD_BY,
T24.CREATED,
T24.LAST_UPD,
T24.CONFLICT_ID,
T24.PAR_ROW_ID,
T45.ROW_ID,
T45.MODIFICATION_NUM,
T45.CREATED_BY,
T45.LAST_UPD_BY,
T45.CREATED,
T45.LAST_UPD,
T45.CONFLICT_ID,
T45.PAR_ROW_ID,
T32.ROW_ID
FROM
BELSIE.S_ASSET T1,
BELSIE.S_PROD_INT T2,
BELSIE.S_SRC_EVT_REG T3,
BELSIE.S_CONTACT T4,
BELSIE.S_PROD_INT T5,
BELSIE.S_VOD_VER T6,
BELSIE.S_CTLG_CAT T7,
BELSIE.S_PROD_INT T8,
BELSIE.S_VDISCNT_ITEM T9,
BELSIE.S_ADDR_PER T10,
BELSIE.S_ORG_EXT T11,
BELSIE.S_CONTACT T12,
BELSIE.S_ORG_EXT T13,
BELSIE.S_ORG_EXT T14,
BELSIE.S_ADDR_PER T15,
BELSIE.S_ASSET T16,
BELSIE.ITEM_S_ORDER_OM T17,
BELSIE.S_CONTACT T18,
BELSIE.S_ADDR_PER T19,
BELSIE.S_PROD_INT T20,
BELSIE.S_ADDR_PER T21,
BELSIE.S_LOY_PROD_PT T22,
BELSIE.S_CONTACT T23,
BELSIE.S_ORDER_ITM_PRI T24,
BELSIE.S_ORG_EXT T25,
BELSIE.S_ACT_PRDINT T26,
BELSIE.S_VOD T27,
BELSIE.S_ORDER T28,
BELSIE.ITEM_S_ORDER T29,
BELSIE.S_ORG_EXT T30,
BELSIE.S_ORDER_ACTNSET T31,
BELSIE.S_ADDR_PER T32,
BELSIE.S_INV_PROF T33,
BELSIE.S_ORDER_TYPE T34,
BELSIE.S_INVLOC T35,
BELSIE.S_PRI_LST T36,
BELSIE.S_CTLG_CAT T37,
BELSIE.S_ORDER_X T38,
BELSIE.S_PROD_INT T39,
BELSIE.ITEM_S_ORDER T40,
BELSIE.ITEM_S_ORDER T41,
BELSIE.S_ORG_EXT T42,
BELSIE.TRMS_S_ORDERITM T43,
BELSIE.S_PRI_LST T44,
BELSIE.S_ORD_ITM_LOYX T45,
BELSIE.S_ORG_EXT T46,
BELSIE.S_ENTLMNT T47,
BELSIE.S_PROD_INT T48,
BELSIE.ITEM_S_ORDER_X T49,
BELSIE.S_INVLOC T50,
BELSIE.S_LOY_ATTRDEFN T51,
BELSIE.S_ISS_OBJ_DEF T52,
BELSIE.S_PROD_LN T53,
BELSIE.S_USER T54,
BELSIE.ITEM_S_ORDER T55
WHERE
T42.PR_ADDR_ID = T19.ROW_ID (+) AND
T16.PROD_ID = T5.ROW_ID (+) AND
T28.TAX_LIST_ID = T36.ROW_ID (+) AND
T55.SRC_INVLOC_ID = T50.ROW_ID (+) AND
T55.SHIP_CON_ID = T12.PAR_ROW_ID (+) AND
T55.SHIP_OU_ID = T14.PAR_ROW_ID (+) AND
T50.RECV_TO_ADDR_ID = T10.ROW_ID (+) AND
T55.SERV_ACCNT_ID = T42.PAR_ROW_ID (+) AND
T27.ROW_ID = T6.VOD_ID (+) AND
T39.CFG_MODEL_ID = T27.OBJECT_NUM (+) AND
T55.VOL_DISCNT_ITEM_ID = T9.ROW_ID (+) AND
T55.PROD_ID = T39.ROW_ID (+) AND
T55.ORDER_ID = T38.ROW_ID (+) AND
T28.ORDER_TYPE_ID = T34.ROW_ID (+) AND
T55.ORDER_ID = T31.ORDER_ID (+) AND
T55.ORDER_ID = T28.ROW_ID (+) AND
T27.ROW_ID = T52.VOD_ID (+) AND
T55.BILL_ACCNT_ID = T33.ACCNT_ID (+) AND
T55.ENTLMNT_ID = T47.ROW_ID (+) AND
T55.CONTACT_ID = T4.ROW_ID (+) AND
T55.ASSET_ID = T16.ROW_ID (+) AND
T55.PRI_LST_ID = T44.ROW_ID (+) AND
T55.PROMOTION_ID = T20.ROW_ID (+) AND
T13.PR_ADDR_ID = T15.ROW_ID (+) AND
T55.ACT_PRDINT_ID = T26.ROW_ID (+) AND
T29.PROD_ID = T2.ROW_ID (+) AND
T55.ROOT_ORDER_ITEM_ID = T29.ROW_ID (+) AND
T2.PR_PROD_LN_ID = T53.ROW_ID (+) AND
T28.BU_ID = T30.PAR_ROW_ID (+) AND
T55.X_PORT_PM_ID = T18.ROW_ID (+) AND
T28.X_PTNR_ORG_ID = T11.PAR_ROW_ID (+) AND
T40.PROD_ID = T8.ROW_ID (+) AND
T55.PAR_ORDER_ITEM_ID = T40.ROW_ID (+) AND
T37.CG_PAR_CTLG_CAT_ID = T7.ROW_ID (+) AND
T28.X_PTNR_ORG_ID = T25.PAR_ROW_ID (+) AND
T28.ACCNT_ID = T13.PAR_ROW_ID (+) AND
T49.ATTRIB_05 = T23.PAR_ROW_ID (+) AND
T45.LOY_PROD_POINT_ID = T22.ROW_ID (+) AND
T22.POINT_TYPE_ID = T51.ROW_ID (+) AND
T55.DEST_INVLOC_ID = T35.ROW_ID (+) AND
T55.CREATED_BY = T54.PAR_ROW_ID (+) AND
T55.SVCD_PROD_ID = T48.ROW_ID (+) AND
T55.SVCD_ORDER_ITEM_ID = T41.ROW_ID (+) AND
T55.CRSE_REG_ID = T3.ROW_ID (+) AND
T55.PROD_SUB_CAT_ID = T37.ROW_ID (+) AND
T46.PR_BL_ADDR_ID = T21.ROW_ID (+) AND
T55.ASSET_INTEG_ID = T1.INTEGRATION_ID (+) AND
T55.BILL_ACCNT_ID = T46.PAR_ROW_ID (+) AND
T55.ROW_ID = T43.PAR_ROW_ID (+) AND
T55.ROW_ID = T17.PAR_ROW_ID (+) AND
T55.ROW_ID = T49.PAR_ROW_ID (+) AND
T55.ROW_ID = T24.PAR_ROW_ID (+) AND
T55.ROW_ID = T45.PAR_ROW_ID (+) AND
T55.SHIP_ADDR_ID = T32.ROW_ID (+) AND
(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
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
(T55.ORDER_ID = :3 AND T55.X_TRANSFER_TYPE IS NOT NULL) AND
(T55.ORDER_ID = :4)
ORDER BY
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/，如需轉載，請註明出處，否則將追究法律責任。

ORA-600[4000]/[4097]錯誤的處理
2009-06-25
ORA-600[kqlnrc_1]錯誤分析及處理
2015-06-10
oracle ora-600 Ktspgsb-1 錯誤處理案例
2011-04-29
Oracle
錯誤處理
2020-12-30
ORACLE11GRAC alert日誌ORA-600 [kqlnrc_1]錯誤處理
2014-11-27
Oracle
PHP 錯誤處理
2020-04-01
PHP
php錯誤處理
2021-09-09
PHP
Go 錯誤處理
2021-10-27
Go
Swift錯誤處理
2017-12-13
Swift
Zabbix錯誤處理
2011-01-31
mysqldump錯誤處理
2011-12-11
MySql
ORA-600(kffmXpGet)錯誤
2012-07-10
錯誤處理：如何通過 error、deferred、panic 等處理錯誤？
2021-02-04
Error
PHP錯誤處理和異常處理
2017-11-12
PHP
go的錯誤處理
2021-09-09
Go
Python錯誤處理
2020-11-11
Python
【ERROR】儲存鏈路問題造成oracle錯誤，ora-600[4193] 問題處理
2022-01-04
ErrorOracle
異常錯誤資訊處理
2019-12-16
PHP 核心特性 - 錯誤處理
2019-11-15
PHP
常用模組 PHP 錯誤處理
2019-10-26
PHP
laravel9 錯誤處理
2022-04-16
Laravel
淺談前端錯誤處理
2018-11-14
前端
Oracle異常錯誤處理
2018-11-14
Oracle
ORACLE 異常錯誤處理
2018-09-27
Oracle
15-錯誤處理（Error）
2020-11-16
Error
學習Rust 錯誤處理
2020-12-25
Rust
axios 的錯誤處理
2021-01-21
iOS
Go語言之錯誤處理
2020-10-01
Go
GOLANG錯誤處理最佳方案
2017-06-05
Golang
Objective-C:錯誤處理
2017-02-14
Object
javascript之處理Ajax錯誤
2016-04-10
JavaScript
搭建dataguard時，錯誤處理
2013-01-16
Oracle錯誤處理思路(一)
2011-08-05
Oracle
COM的錯誤處理 (轉)
2007-12-02
使用PHP錯誤處理 (轉)
2007-11-07
PHP
openGauss 處理錯誤表
2024-07-08
Python錯誤處理和異常處理（二）
2019-03-07
Python
【故障處理】CRS-1153錯誤處理
2016-11-27

ORA-600[6122]錯誤處理

相關文章