转载

ORA-00600[kfioTranslateIO03] 和ORA-00600[17090]的解决

联系：QQ(5163721)

标题： ORA-00600[kfioTranslateIO03] 和ORA-00600[17090]的解决

今天玩VM，发现数据库不能启动了：

[oracle@lunar1 test]$ ss  SQL*Plus: Release 11.2.0.3.0 Production on Mon Jun 24 05:32:01 2013  Copyright (c) 1982, 2011, Oracle.  All rights reserved.  Connected to an idle instance.  SQL> startup  ORACLE instance started.  Total System Global Area  626327552 bytes Fixed Size                  2230952 bytes Variable Size             184550744 bytes Database Buffers          432013312 bytes Redo Buffers                7532544 bytes ORA-03113: end-of-file on communication channel Process ID: 12878 Session ID: 125 Serial number: 3   SQL>

检查alert日志，报错如下：

Mon Jun 24 05:32:16 2013 ORACLE_BASE from environment = /u01/app/oracle Mon Jun 24 05:32:16 2013 ALTER DATABASE   MOUNT NOTE: Loaded library: System  ORA-15025: could not open disk "/dev/asm-diske" ORA-27041: unable to open file Linux-x86_64 Error: 13: Permission denied Additional information: 9 ORA-15025: could not open disk "/dev/asm-diskf" ORA-27041: unable to open file Linux-x86_64 Error: 13: Permission denied Additional information: 9 SUCCESS: diskgroup ASMDATA was mounted ERROR: failed to establish dependency between database lunar and diskgroup resource ora.ASMDATA.dg Errors in file /u01/app/oracle/diag/rdbms/lunar/lunar1/trace/lunar1_ckpt_12857.trc  (incident=4945): ORA-00600: internal error code, arguments: [kfioTranslateIO03], [], [], [], [], [], [], [], [], [], [], [] Incident details in: /u01/app/oracle/diag/rdbms/lunar/lunar1/incident/incdir_4945/lunar1_ckpt_12857_i4945.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Mon Jun 24 05:32:19 2013 Sweep [inc][3746]: completed Sweep [inc][3745]: completed Sweep [inc2][3746]: completed Sweep [inc2][3745]: completed Dumping diagnostic data in directory=[cdmp_20130624053221], requested by (instance=1, osid=12857 (CKPT)), summary=[incident=4945]. Errors in file /u01/app/oracle/diag/rdbms/lunar/lunar1/trace/lunar1_ckpt_12857.trc  (incident=4946): ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], [], [], [], [], [], [] Incident details in: /u01/app/oracle/diag/rdbms/lunar/lunar1/incident/incdir_4946/lunar1_ckpt_12857_i4946.trc 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 12857  Dumping diagnostic data in directory=[cdmp_20130624053223], requested by (instance=1, osid=12857 (CKPT)), summary=[incident=4946]. Mon Jun 24 05:32:24 2013 PMON (ospid: 12823): terminating the instance due to error 469 System state dump requested by (instance=1, osid=12823 (PMON)), summary=[abnormal instance termination]. System State dumped to trace file /u01/app/oracle/diag/rdbms/lunar/lunar1/trace/lunar1_diag_12833.trc Mon Jun 24 05:32:25 2013 Dumping diagnostic data in directory=[cdmp_20130624053224], requested by (instance=1, osid=12823 (PMON)), summary=[abnormal instance termination]. Instance terminated by PMON, pid = 12823

很久没玩这个VM，隐约记得上次好像测试修改权限了

然后，根据报错查询官网：

ORA-00600: internal error code, arguments: [kfioTranslateIO03], [], [], [], [], [], [], [], [], [], [], []

果然是权限问题，因此检查相关权限并修改。

[oracle@lunar1 ~]$ cd $ORACLE_HOME/bin/ [oracle@lunar1 bin]$ ll oracle -rwsr-x--x 1 oracle asmadmin 222M May  3 15:11 oracle [oracle@lunar1 bin]$ chmod 6751 oracle [oracle@lunar1 bin]$ ll oracle -rwsr-x--x 1 oracle asmadmin 222M May  3 15:11 oracle [oracle@lunar1 bin]$

使用root：

[root@lunar1 bin]# chmod 6751 oracle [root@lunar1 bin]# ll oracle -rwsr-s--x 1 oracle asmadmin 232399431 May  3 15:11 oracle [root@lunar1 bin]#

现在启动数据库就不报错了：

[oracle@lunar1 test]$ ss  SQL*Plus: Release 11.2.0.3.0 Production on Mon Jun 24 05:48:33 2013  Copyright (c) 1982, 2011, Oracle.  All rights reserved.  Connected to an idle instance.  SQL> startup ORACLE instance started.  Total System Global Area  626327552 bytes Fixed Size                  2230952 bytes Variable Size             184550744 bytes Database Buffers          432013312 bytes Redo Buffers                7532544 bytes Database mounted. Database opened. SQL>

正文到此结束