ORA-600(ktte_append_file_info-1)錯誤
在一個RAC環境的ALERT檔案中發現這個錯誤，在資料庫開啟的過程中出現ORA-600(ktte_append_file_info-1)錯誤。
在alert檔案中，錯誤如下：
ALTER DATABASE MOUNT
Sat Sep 26 19:32:50 2009
Setting recovery target incarnation to 2
Sat Sep 26 19:32:50 2009
Successful mount of redo thread 1, with mount id 2135712636
Sat Sep 26 19:32:50 2009
Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)
Completed: ALTER DATABASE MOUNT
Sat Sep 26 19:32:50 2009
ALTER DATABASE OPEN
Picked broadcast on commit scheme to generate SCNs
Sat Sep 26 19:32:53 2009
Errors in file /oracle/product/admin/pmias/bdump/pmias1_dbw0_15650.trc:
ORA-01157: cannot identify/lock data file 18 - see DBWR trace file
ORA-01110: data file 18: '/dev/vgpms01/rlvol59'
ORA-15059: invalid device type for ASM disk
Additional information: 255
Sat Sep 26 19:33:02 2009
Errors in file /oracle/product/admin/pmias/bdump/pmias1_dbw0_15650.trc:
ORA-01186: file 18 failed verification tests
ORA-01157: cannot identify/lock data file 18 - see DBWR trace file
ORA-01110: data file 18: '/dev/vgpms01/rlvol59'
Sat Sep 26 19:33:02 2009
File 18 not verified due to error ORA-01157
Sat Sep 26 19:33:03 2009
Thread 1 opened at log sequence 505
Current log# 6 seq# 505 mem# 0: /dev/vgpms01/rlvol15
Successful open of redo thread 1
Sat Sep 26 19:33:03 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Sep 26 19:33:03 2009
SMON: enabling cache recovery
Sat Sep 26 19:33:05 2009
Successfully onlined Undo Tablespace 1.
Sat Sep 26 19:33:05 2009
SMON: enabling tx recovery
Sat Sep 26 19:33:05 2009
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=40, OS id=18234
Sat Sep 26 19:33:13 2009
Completed: ALTER DATABASE OPEN
Sat Sep 26 19:37:26 2009
Thread 1 advanced to log sequence 506
Current log# 1 seq# 506 mem# 0: /dev/vgpms01/rlvol10
Sat Sep 26 19:42:35 2009
Errors in file /oracle/product/admin/pmias/bdump/pmias1_mmon_15712.trc:
ORA-00600: internal error code, arguments: [ktte_append_file_info-1], [6], [17], [6], [11], [], [], []
Sat Sep 26 19:42:36 2009
Trace dumping is performing id=[cdmp_20090926194236]
Sat Sep 26 19:43:34 2009
Restarting dead background process MMON
MMON started with pid=28, OS id=9146
Sat Sep 26 19:43:37 2009
Errors in file /oracle/product/admin/pmias/bdump/pmias1_mmon_9146.trc:
ORA-00600: internal error code, arguments: [ktte_append_file_info-1], [6], [11], [6], [11], [], [], []
Sat Sep 26 19:43:39 2009
Trace dumping is performing id=[cdmp_20090926194338]
Sat Sep 26 19:46:44 2009
Starting background process EMN0
EMN0 started with pid=38, OS id=15381
對應的詳細TRACE檔案資訊為：
/oracle/product/admin/pmias/bdump/pmias1_mmon_15712.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORACLE_HOME = /oracle/product/db1
System name: HP-UX
Node name: pmsdb1
Release: B.11.31
Version: U
Machine: ia64
Instance name: pmias1
Redo thread mounted by this instance: 1
Oracle process number: 28
Unix process pid: 15712, image: oracle@pmsdb1 (MMON)
*** 2009-09-26 19:33:08.582
*** SERVICE NAME:(SYS$BACKGROUND) 2009-09-26 19:33:08.581
*** SESSION ID:(512.1) 2009-09-26 19:33:08.581
MMON encountered error 1157, clearing the error
*** 2009-09-26 19:42:35.108
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [ktte_append_file_info-1], [6], [17], [6], [11], [], [], []
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+64 call 9fffffffffffa25e 000000000 ? 000000001 ?
ksedmp()+2160 call 9fffffffffffa25e 000000000 ?
C000000000000C9F ?
4000000005274B00 ?
000000000 ? 000000000 ?
000000000 ?
ksfdmp()+48 call 9fffffffffffa25e 000000003 ?
kgerinv()+304 call 9fffffffffffa25e C000000000000612 ?
000000003 ?
40000000097F6FD0 ?
00000F513 ? 000000000 ?
000000000 ?
kgeasnmierr()+144 call 9fffffffffffa25e 6000000000034410 ?
4000000001A371A0 ?
60000000000354C8 ?
4000000001A371A0 ?
9FFFFFFFFFFFADE0 ?
$cold_ktte_append_f call 9fffffffffffa25e 6000000000034410 ?
ile_info()+176 9FFFFFFFFD3B0040 ?
9FFFFFFFFD3B0050 ?
6000000000035840 ?
000000000 ? 000000006 ?
000000000 ? 000000011 ?
ktte_insert_ts()+11 call 9fffffffffffa25e 9FFFFFFFFFFFAE70 ?
52 C000000000000A1C ?
400000000275FFB0 ?
00000F597 ?
4000000000F0E100 ?
60000000000BFC10 ?
60000000000BFB44 ?
C000001151A41590 ?
ktte_prime_finfo()+ call 9fffffffffffa25e 000000001 ? 000000000 ?
832 000000000 ?
60000000000B31D8 ?
9FFFFFFFFFFFAE94 ?
C000000000000797 ?
40000000026841A0 ?
00000F5DF ?
ktte_monitor_tsth() call 9fffffffffffa25e C0000010AA2CEC10 ?
+3200 C000000000001028 ?
4000000003B34A00 ?
00000F5DD ?
C000001151A415E4 ?
C000001151A415F8 ?
9FFFFFFFFD39B8A8 ?
00000057B ?
ktte_monitor_ts()+6 call 9ffffffffd39b8a8 9FFFFFFFFFFFAF10 ?
24 60000000000B31D8 ?
9FFFFFFFFFFFC030 ?
4000000003C2CBD0 ?
00000F51D ?
C000000000000A1A ?
ksbcti()+1760 call 9ffffffffd39b8a8 9FFFFFFFFFFFC5C0 ?
C000000000000CA1 ?
9FFFFFFFFFFFC040 ?
60000000000B31D8 ?
4000000002D5CAC0 ?
00000F5DD ?
60000000000BFAC0 ?
60000000000354E8 ?
ksbabs()+704 call 9ffffffffd39b8a8 C000000000000B1E ?
4000000001A34C00 ?
000000001 ?
60000000000B31D8 ?
4000000002C9DBF0 ?
000000001 ?
9FFFFFFFFFFFC840 ?
60000000000BFE48 ?
kebm_mmon_main()+11 call 9ffffffffd39b8a8 60000000000BFE30 ?
36 60000000000B31D8 ?
C000000000000D20 ?
4000000002670040 ?
00000F11B ?
60000000000BFCD0 ?
ksbrdp()+3552 call 9ffffffffd39b8a8 C0000010C0028D40 ?
9FFFFFFFFFFFC8F0 ?
60000000000B31D8 ?
9FFFFFFFFFFFD400 ?
C000000000000F24 ?
4000000003B172E0 ?
opirip()+1216 call 9ffffffffd39b8a8 9FFFFFFFFFFFD410 ?
60000000000B31D8 ?
9FFFFFFFFFFFDF50 ?
C000000000000CA0 ?
4000000003AC6EC0 ?
0000050DB ?
60000000000BFAC0 ?
opidrv()+1568 call 9ffffffffd39b8a8 9FFFFFFFFFFFED30 ?
000000004 ?
9FFFFFFFFFFFF350 ?
9FFFFFFFFFFFDF60 ?
60000000000B31D8 ?
C000000000000F24 ?
sou2o()+240 call 9ffffffffd39b8a8 000000032 ?
60000000000BFAC0 ?
9FFFFFFFFFFFF350 ?
opimai_real()+512 call 9ffffffffd39b8a8 9FFFFFFFFFFFF370 ?
000000032 ? 000000004 ?
9FFFFFFFFFFFF350 ?
main()+368 call 9ffffffffd39b8a8 000000003 ? 000000000 ?
main_opd_entry()+80 call 9ffffffffd39b8a8 000000003 ?
9FFFFFFFFFFFF820 ?
60000000000B31D8 ?
C000000000000004 ?
查詢了METALINK，發現有一個已知的bug和當前的情況很接近：Doc ID: 382871.1。問題也是發生在啟動的時候，由MMON程式發出的。而且bug中描述的沒有找到資料檔案的問題在當前的環境中也出現了。
唯一不同的地方是Oracle在10.2.0.2中fixed了這個bug，而當前的版本是10.2.0.3，不過不排除在10.2.0.3中，這個bug再次被引入。
正如metalink文件中描述的那樣，這個bug對系統也沒有什麼影響，只不過對理解真正的問題有些障礙而已。
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/4227/viewspace-615665/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- ORA-600(kffmXpGet)錯誤
- ORA-600(kcbgcur_1)錯誤GC
- ORA-600 [ttcgcshnd-1 ]錯誤GC
- ORA-600(kclgclk_7)錯誤GC
- ORA-600(kcbnew_3)錯誤
- ORA-600(qersqCloseRem-2)錯誤REM
- ORA-600(qctopn1)錯誤
- ORA-600(kcblasm_1)錯誤ASM
- ORA-600(qkaffsindex5)錯誤Index
- ORA-600(kghuclientasp_03)錯誤client
- ORA-600(ttcgcshnd-2)錯誤GC
- ORA-600(kolaslGetLength-1)錯誤
- ORA-600(kghfremptyds)和ORA-600(kghasp1)錯誤REM
- ORA-600(kssadd: null parent)錯誤Null
- ORA-600(504)(row cache objects)錯誤Object
- ORA-600(ktrgcm_3)錯誤GC
- ORA-600(krvxdds: duplicated session not）錯誤Session
- ORA-600(kjxgrdecidemem1)錯誤IDE
- ORA-600(kfioUnidentify01)錯誤IDE
- ORA-600(qsmqSetupTableMetadata-2)錯誤MQ
- ORA-600(kcratr_scan_lastbwr)錯誤AST
- ORA-600(ksnpost:ksnigb)錯誤
- ORA-600(evapth : unexpected evaluation)錯誤APT
- ORA-600(qkacon:FJswrwo)錯誤JS
- ORA-600(KSFD_DECAIOPC)和ORA-600(kfioReapIO00)錯誤AIAPI
- ORA-600(kocgor077)錯誤Go
- ora-600內部錯誤的型別型別
- ORA-600(kkoipt:invalid join method)錯誤
- ORA-600[6122]錯誤處理
- ORA-600(krboReadBitmap_badbitmap)錯誤
- ORA-600(kcbchg1_12)和ORA-600(kdifind:kcbget_24)錯誤
- ORA-600(ktfbbsearch-8)和ORA-600(kewrose_1)錯誤ROS
- ORA-600(kjbrchkpkeywait:timeout)和ORA-600(kclcls_8)錯誤AI
- ORA-600(kauxs_do_jou:3)錯誤UX
- oracle 10.2.0.5 平臺上ORA-600錯誤Oracle
- ORA-600(kcbz_check_objd_typ_3)錯誤OBJ
- ORA-600(kgscLogOff-notempty)錯誤Go
- ORA-600(kssadd_stage: null parent)錯誤Null