升级Oracle11.2.0.3后遭遇ORA-00600[kfioTranslateIO03][17090]
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了升级Oracle11.2.0.3后遭遇ORA-00600[kfioTranslateIO03][17090],小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2232字,纯文字阅读大概需要4分钟。
内容图文
![升级Oracle11.2.0.3后遭遇ORA-00600[kfioTranslateIO03][17090]](/upload/InfoBanner/zyjiaocheng/550/1858785c933e4e6eb8f4c9f35db24818.jpg)
环境介绍: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
内容总结
以上是互联网集市为您收集整理的升级Oracle11.2.0.3后遭遇ORA-00600[kfioTranslateIO03][17090]全部内容,希望文章能够帮你解决升级Oracle11.2.0.3后遭遇ORA-00600[kfioTranslateIO03][17090]所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。