启动数据库 ORA-03113 serial number1--abnormal instance termination

xychong123

SO: 0x11f0dbb88, type: 1, owner: (nil), flag: INIT/-/-/0x00 if: 0x3 c: 0x3
proc=(nil), name=cleanup state object, file=kss.h LINE:2149, pg=0
(cleanup state object) description: ASM file cleanup
latch: 0x6004ae98

-- XS Principal State --
1 : Role Graph Hash Table
2 : User Hash Table with Direct Roles Grated
3 : Principal Row Cache State
-- XS Principal State End --
END OF SYSTEM STATE
Performing trace dump for this instance

*** 2011-11-07 14:39:01.418
REQUEST:trace dump in directory=[cdmp_20111107143901], requested by (instance=1, osid=6149 (PMON)), summary=[abnormal instance termination].

*** 2011-11-07 14:39:01.418
Trace dumping is performing id=[cdmp_20111107143901]....
===================================
alert_TT.log

NOTE: MARK has subscribed
Mon Nov 07 15:12:21 2011
ALTER DATABASE   MOUNT
Mon Nov 07 15:12:21 2011
Sweep [inc][4898]: completed
Sweep [inc][4897]: completed
Sweep [inc2][4898]: completed
Sweep [inc2][4897]: completed
NOTE: Loaded library: System
ORA-15025: could not open disk "/dev/raw/raw4"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
ORA-15025: could not open disk "/dev/raw/raw5"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
ORA-15025: could not open disk "/dev/raw/raw6"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
SUCCESS: diskgroup DATA was mounted
ERROR: failed to establish dependency between database oracledb and diskgroup resource ora.DATA.dg
Errors in file /u01/app/oracle/diag/rdbms/oracledb/TT/trace/TT_ckpt_5236.trc  (incident=6097):
ORA-00600: internal error code, arguments: [kfioTranslateIO03], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/oracledb/TT/incident/incdir_6097/TT_ckpt_5236_i6097.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/oracle/diag/rdbms/oracledb/TT/trace/TT_ckpt_5236.trc  (incident=6098):
ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/oracledb/TT/incident/incdir_6098/TT_ckpt_5236_i6098.trc
Dumping diagnostic data in directory=[cdmp_20111107151226], requested by (instance=1, osid=5236 (CKPT)), summary=[incident=6097].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
ERROR: unrecoverable error ORA-600 raised in ASM I/O path; terminating process 5236
Dumping diagnostic data in directory=[cdmp_20111107151227], requested by (instance=1, osid=5236 (CKPT)), summary=[incident=6098].
PMON (ospid: 5214): terminating the instance due to error 469
System state dump requested by (instance=1, osid=5214 (PMON)), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/oracledb/TT/trace/TT_diag_5224.trc
Dumping diagnostic data in directory=[cdmp_20111107151228], requested by (instance=1, osid=5214 (PMON)), summary=[abnormal instance termination].

=================

解决方案：
修改raw文件属性，数据库可以正常启动。

这个问题由于asm文件属性问题引发，修改raw属性问题消除。

Maclean Liu(刘相兵

启动在nomount 到mount 阶段报错：

        elapsed time of 0.000029 sec since current wait
     0: waited for 'ASM file metadata operation'
        msgop=0x11, locn=0x0, =0x0
        wait_id=11 seq_num=12 snap_id=1
        wait times: snap=0.001380 sec, exc=0.001380 sec, total=0.001380 sec
        wait times: max=infinite
        wait counts: calls=0 os=0
        occurred after 0.000026 sec of elapsed time


控制文件是存放在ASM上？ 似乎控制文件有问题，或者ASM就有问题。结合db和asm的日志一起诊断下。

xifenfei

alert日志发出来看看