升级Oracle 11.2.0.3后遭遇ORA-00600 [kfioTranslateIO03] [17090]

环境介绍：
Linux5，OracleRAC 11.2.0.1 to 11.2.0.3
AIX6.1，，OracleRAC 11.2.0.1 to 11.2.0.3
升级DB HOME到11.2.0.3后，启动Oracle遇到ORA-00600报错：
ORA-00600: internal error code, arguments: [kfioTranslateIO03]
ORA-00600: internal error code, arguments: [17090]
原因是由权限引起，解决方法 [ID 1336846.1]，如下：Applies to:
Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later [Release: 11.2 and later ]
Information in this document applies to any platform.
Symptoms
In 11.2.0.2 where role separation between GRID and RDBMS is implemented, the following ORA-600 error prevents database from starting up.

ORA-00600: internal error code, arguments: [kfioTranslateIO03]
ORA-00600: internal error code, arguments: [17090]
Cause
group permission of "oracle" executable from RDBMS home should have the same group information for ASM devices according to note 1084186.1.
$ ls -l $GRID_HOME/bin/oracle
-rwsr-s--x 1 grid oinstall 228954465 Jul 1 13:37 /oh1/grid/product/11.2.0/bin/oracle
$ ls -l $RDBMS_HOME/bin/oracle
-rwsr-s--x 1 oracle asmadmin 228954465 Jul 1 13:37 /oh1/oracle/product/11.2.0/bin/oracle
$ ls -l $ASM_DEVICE/*
brw-rw---- 1 grid asmadmin 8, 33 Feb 15 08:11 /dev/oracleasm/disks/ASMD1
brw-rw---- 1 grid asmadmin 8, 49 Feb 15 08:11 /dev/oracleasm/disks/ASMD2
brw-rw---- 1 grid asmadmin 8, 17 May 4 22:30 /dev/oracleasm/disks/CRSD1
But in this case, "oracle" executable from RDBMS shows different group information which is different from group information for ASM devices.
ORA-600[kfioTranslateIO03] and [17090] occurrs due to the permission issue.
$ ls -l $RDBMS_HOME/bin/oracle
-rwsr-s--x 1 oracle oinstall 228954465 Jul 1 13:37 /oh1/oracle/product/11.2.0/bin/oracle
^^^^^^^ it should be "asmadmin" or at least should be the same group of all ASM devices.
Solution
group information for $RDBMS_HOME/bin/oracle should be changed to the group that can read/write to ASM devices.
Please execute the following action plan from note 1084186.1.$ su - grid
$ cd /bin
$ ./setasmgidwrap o=/bin/oracle更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12Oracle错误日志：11gR2 RAC升级后启动报ORA-01565,ORA-17503,ORA-12547Oracle升级：11.2.0.3安装patch13831007遇到no filemap entries available.相关资讯 Oracle升级

Oracle升级中的参数补充（05月31日）
升级Oracle 11.2.0.1.0到11.2.0.3. （01月12日）
Oracle 10g升级后启动失败（Oracle （05/24/2015 11:40:44）

Oracle 10g（10.2.0.4）升级到10.2.0 （04月10日）
Oracle 11.2.0.1升级到11.2.0.3 （11/27/2015 09:21:45）
Oracle升级到11.2.0.4之后在alert （02/18/2015 09:30:44）

本文评论查看全部评论（0）