oracle11.2.03,升级Oracle11.2.0.3后遭遇ORA-00600[kfioTranslateIO03][17090]

环境介绍：Linux5，OracleRAC 11.2.0.1 to 11.2.0.3AIX6.1，，OracleRAC 11.2.0.1 to 11.2.0.3升级DB HOME到11.2.0.3后，启动Ora

环境介绍：

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 专题页面 ?tid=12

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：php中文网