首页 » ORACLE 9i-23ai » Troubleshooting ORA 600 [ktspfmdb:objdchk_kcbnew_3] 案例
Troubleshooting ORA 600 [ktspfmdb:objdchk_kcbnew_3] 案例
前段时间数据库出现了几次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
-------------------- ----------------------------------------------------------- ----------------------------------------
73017 ORA 600 [ktspfmdb:objdchk_kcbnew_3] 2015-10-04 19:12:15.790000 +08:00
72897 ORA 600 [ktspfmdb:objdchk_kcbnew_3] 2015-10-04 19:12:44.975000 +08:00
72945 ORA 600 [ktspfmdb:objdchk_kcbnew_3] 2015-10-04 19:14:37.997000 +08:00
73105 ORA 600 [ktspfmdb:objdchk_kcbnew_3] 2015-10-04 19:22:14.982000 +08:00
4 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
1 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
1> ***** Error Stack *****
ORA-00600: internal error code, arguments: [ktspfmdb:objdchk_kcbnew_3], [11], [66982], [4], [], [], [], [], [], [], [], []
1< ***** Error Stack ***** 1> ***** Dump for incident 73105 (ORA 600 [ktspfmdb:objdchk_kcbnew_3]) *****
2> ***** Beginning of Customized Incident Dump(s) *****
2< ***** 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)
2< ***** 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
微信扫一扫，打赏作者吧～
对不起，这篇文章暂时关闭评论。