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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/4227/viewspace-615665/