ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-600(ktte_append_file_info-1)错误

ORA-600(ktte_append_file_info-1)错误

原创 Linux操作系统 作者:yangtingkun 时间:2009-09-27 18:42:57 0 删除 编辑

在一个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中描述的没有找到数据文件的问题在当前的环境中也出现了。

唯一不同的地方是Oracle10.2.0.2fixed了这个bug,而当前的版本是10.2.0.3,不过不排除在10.2.0.3中,这个bug再次被引入。

正如metalink文档中描述的那样,这个bug对系统也没有什么影响,只不过对理解真正的问题有些障碍而已。

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/4227/viewspace-615665/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-29

  • 博文量
    1955
  • 访问量
    10405625