β

Troubleshooting ORA 600 [ktspfmdb:objdchk_kcbnew_

ANBOB 234 阅读

前段时间数据库出现了几次ORA 600 [ktspfmdb:objdchk_kcbnew_3]错误,引起该错误的是一条insert sql.

adrci> show incident

ADR Home = /oracle/app/oracle/diag/rdbms/anbob/anbob1:
*************************************************************************
INCIDENT_ID          PROBLEM_KEY                                                 CREATE_TIME                              
-------------------- ----------------------------------------------------------- ---------------------------------------- 
7                ORA 600 [ktspfmdb:objdchk_kcbnew_3]                         2015-10-04 19:12:15.790000 +08:00       
7                ORA 600 [ktspfmdb:objdchk_kcbnew_3]                         2015-10-04 19:12:44.975000 +08:00       
5                ORA 600 [ktspfmdb:objdchk_kcbnew_3]                         2015-10-04 19:14:37.997000 +08:00       
5                ORA 600 [ktspfmdb:objdchk_kcbnew_3]                         2015-10-04 19:22:14.982000 +08:00       
 rows fetched

adrci> show incident -mode detail -p "incident_id=73105"

ADR Home = /oracle/app/oracle/diag/rdbms/anbob/anbob1:
*************************************************************************

**********************************************************
INCIDENT INFO RECORD 1
**********************************************************
   INCIDENT_ID                   73105
   STATUS                        ready
   CREATE_TIME                   2015-10-04 19:22:14.982000 +08:00
   PROBLEM_ID                    1
   CLOSE_TIME
   FLOOD_CONTROLLED              none
   ERROR_FACILITY                ORA
   ERROR_NUMBER                  600
   ERROR_ARG1                    ktspfmdb:objdchk_kcbnew_3
   ERROR_ARG2                    11
   ERROR_ARG3                    66982
   ERROR_ARG4                    4
   ERROR_ARG5
   ERROR_ARG6
   ERROR_ARG7
   ERROR_ARG8
   ERROR_ARG9
   ERROR_ARG10
   ERROR_ARG11
   ERROR_ARG12
   SIGNALLING_COMPONENT          CACHE_RCV
   SIGNALLING_SUBCOMPONENT
   SUSPECT_COMPONENT
   SUSPECT_SUBCOMPONENT
   ECID
   IMPACTS                       0
   PROBLEM_KEY                   ORA 600 [ktspfmdb:objdchk_kcbnew_3]
   FIRST_INCIDENT                73017
   FIRSTINC_TIME                 2015-10-04 19:12:15.790000 +08:00
   LAST_INCIDENT                 73105
   LASTINC_TIME                  2015-10-04 19:22:14.982000 +08:00
   IMPACT1                       0
   IMPACT2                       0
   IMPACT3                       0
   IMPACT4                       0
   KEY_NAME                      SID
   KEY_VALUE                     1011.5651
   KEY_NAME                      PQ
   KEY_VALUE                     (16778036, 1443957734)
   KEY_NAME                      Client ProcId
   KEY_VALUE                     oracle@kdjf3 (TNS V1-V3).10094140_1
   KEY_NAME                      ProcId
   KEY_VALUE                     138.181
   OWNER_ID                      1
   INCIDENT_FILE                 /oracle/app/oracle/diag/rdbms/anbob/anbob1/trace/anbob1_ora_10094140.trc
   OWNER_ID                      1
   INCIDENT_FILE                 /oracle/app/oracle/diag/rdbms/anbob/anbob1/incident/incdir_73105/anbob1_ora_10094140_i73105.trc
 rows fetched

adrci> show trace /oracle/app/oracle/diag/rdbms/anbob/anbob1/trace/anbob1_ora_10094140.trc
DIA-48908: No trace files are found

adrci> show trace /oracle/app/oracle/diag/rdbms/anbob/anbob1/incident/incdir_73105/anbob1_ora_10094140_i73105.trc
Output the results to file: /tmp/utsout_8454268_1_4.ado
"/tmp/utsout_8454268_1_4.ado" 68487 lines, 4651856 characters 
/oracle/app/oracle/diag/rdbms/anbob/anbob1/incident/incdir_73105/anbob1_ora_10094140_i73105.trc
----------------------------------------------------------
LEVEL PAYLOAD
----- ------------------------------------------------------------------------------------------------------------------------------------------------
      Dump file /oracle/app/oracle/diag/rdbms/anbob/anbob1/incident/incdir_73105/anbob1_ora_10094140_i73105.trc
      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
      With the Partitioning, Real Application Clusters, OLAP, Data Mining
      and Real Application Testing options
      ORACLE_HOME = /oracle/app/oracle/product/11.2.0.3/dbhome_1
      System name:      AIX
      Node name:        kdjf3
      Release:  1
      Version:  6
      Machine:  00F65F614C00
      Instance name: anbob1
      Redo thread mounted by this instance: 1
      Oracle process number: 138
      Unix process pid: 10094140, image: oracle@kdjf3 (TNS V1-V3)


      *** 2015-10-04 19:22:15.020
      *** SESSION ID:(1011.5651) 2015-10-04 19:22:15.020
      *** CLIENT ID:() 2015-10-04 19:22:15.020
      *** SERVICE NAME:(SYS$USERS) 2015-10-04 19:22:15.020
      *** MODULE NAME:(imp@kdjf3 (TNS V1-V3)) 2015-10-04 19:22:15.020
      *** ACTION NAME:() 2015-10-04 19:22:15.020

      Dump continued from file: /oracle/app/oracle/diag/rdbms/anbob/anbob1/trace/anbob1_ora_10094140.trc
>     ***** Error Stack *****
       ORA-00600: internal error code, arguments: [ktspfmdb:objdchk_kcbnew_3], [11], [66982], [4], [], [], [], [], [], [], [], []
<     ***** Error Stack ***** 1>     ***** Dump for incident 73105 (ORA 600 [ktspfmdb:objdchk_kcbnew_3]) *****
>      ***** Beginning of Customized Incident Dump(s) *****
<      ***** End of Customized Incident Dump(s) *****        *** 2015-10-04 19:25:03.621        dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0) 2>      ***** Current SQL Statement for this session (sql_id=5ftsfy8yntvfc) *****
        INSERT /*+NESTED_TABLE_SET_REFS+*/ INTO "T_ERR" ("CDRTYPE", "ROAMTYPE", "CALLTYPE", "USERTYPE", "SEQUENCENO", "TELNUM", "THIRDTELNUM",
         "VREGION", "HREGION", "HMANAGE", "SPCODE", "OTHERMANAGE", "ISMGID", "FISMGID", "SMSID", "STARTTIME", "ENDTIME", "SERVICECODE", "FEE", "RENTFE
        E", "STATUS", "PRIORITY", "LENGTH", "BILLINGCYCLE", "SOURFILENAME", "SUBSCRIBERID", "ACCOUNTID", "DESTFILENAME", "ERRORCODE", "DEVICETYPE", "S
        PECIALTYPE", "PROCESSTIME", "ROLLBACK_FLAG", "IMSI", "IMEI", "SETTLEFLAG", "REMINDFLAG", "BILLINGFLAG", "PACKAGE_INFO", "INFO_TYPE", "TARIFFTR
        ACK", "BILL_WRITE_FLAG", "BDS_PROC_STATUS") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20,
         :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43)
<      ***** current_sql_statement *****


         ----- Abridged Call Stack Trace -----
       ksedsts()+360<-kjzdssdmp()+240<-kjzduptcctx()+228<-kjzdpcrshnfy()+68<-kstdmp()+308<-dbkedDefDump()+7932<-ksedmp()+72<-ksfdmp()+100<-dbgexPhaseI
       I()+1940<-dbgexExplicitEndInc()+476<-dbgeEndDDEInvocationImpl()+544<-dbgeEndDDEInvocation()+48<-kcbnew()+18660<-ktspfmdb()+496
       <-ktspfmtrng()+1224<-ktspfsall()+1448<-ktspfsrch()+396<-ktspscan_bmb()+444<-ktspgsp_main()+1792<-kdtgsp()+1900
       ----- End of Abridged Call Stack Trace -----

这是一套11.2.0.3.7 2nodes RAC ON HPUX 11.31的环境, 从MOS 中查找已知的BUG中Bug 14497307 ORA-600 [ktsbifmt:clschk_kcbnew_14] can occur, 并且call stack 中包含函数 kcbnew, 貌似 是一个cache buffer检验类的错误,建议可以通过尝试flush  buffer_cache再重新执行。 该bug在下面的版本中修复
Fixed:

The fix for 14497307 is first included in

12.1.0.1 (Base Release)
11.2.0.4 (Server Patch Set)
11.2.0.3.9 Database Patch Set Update

作者:ANBOB
A No Bad Oracle Blog
原文地址:Troubleshooting ORA 600 [ktspfmdb:objdchk_kcbnew_, 感谢原作者分享。

发表评论