最近安装了一套11.2.0.3的RAC。更新完最新Bundle&PSU后，其中一台节点的数据库无法自动带起。alter日志中报错如下：
- ORA-15025: could not open disk "/dev/st653_sdx"
-
ORA-27041: unable to open file
-
Linux-x86_64 Error: 13: Permission denied
-
Additional information: 9
-
ORA-15025: could not open disk "/dev/st653_sdy"
-
ORA-27041: unable to open file
-
Linux-x86_64 Error: 13: Permission denied
-
Additional information: 9
-
ORA-15025: could not open disk "/dev/st653_sdz"
-
ORA-27041: unable to open file
-
Linux-x86_64 Error: 13: Permission denied
-
Additional information: 9
-
SUCCESS: diskgroup DATADG was mounted
-
NOTE: dependency between database testdb and diskgroup resource ora.DATADG.dg is established
-
Errors in file /oracle/diag/rdbms/testdb/testdb2/trace/testdb2_ora_2143.trc (incident=120025):
-
ORA-00600: internal error code, arguments: [kfioTranslateIO03], [], [], [], [], [], [], [], [], [], [], []
-
Incident details in: /oracle/diag/rdbms/testdb/testdb2/incident/incdir_120025/testdb2_ora_2143_i120025.trc
-
Use ADRCI or Support Workbench to package the incident.
-
See Note 411.1 at My Oracle Support for error and packaging details.
-
Dumping diagnostic data in directory=[cdmp_20120307101109], requested by (instance=2, osid=2143), summary=[incident=120025].
-
Errors in file /oracle/diag/rdbms/testdb/testdb2/trace/testdb2_ora_2143.trc (incident=120026):
-
ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], [], [], [], [], [], []
-
Incident details in: /oracle/diag/rdbms/testdb/testdb2/incident/incdir_120026/testdb2_ora_2143_i120026.trc
-
Use ADRCI or Support Workbench to package the incident.
-
See Note 411.1 at My Oracle Support for error and packaging details.
-
Dumping diagnostic data in directory=[cdmp_20120307101110], requested by (instance=2, osid=2143), summary=[incident=120026].
-
ERROR: unrecoverable error ORA-600 raised in ASM I/O path; terminating process 2143
第一感觉是ASM磁盘的权限有问题，检查确认两个节点的ASM磁盘权限一致
通过grid用户使用as sysasm进入查询dg的状态都是mount，说明问题应该在database方面。
检查$ORACLE_HOME/bin/oracle执行文件的权限。发现两个节点不一致
- 错误节点如下：
-
-rwsr-s--x 1 oracle oinstall
-
正常节点如下：
-
-rwsr-s--x 1 oracle asmadmin
显然是由于$ORACLE_HOME/bin/oracle缺少asmadmin组权限导致。修改为正常后，重启crs后正常
阅读(841) | 评论(0) | 转发(0) |
