问题及描述 环境为RAC 11.2.0.4 执行命令报错:
SQL> ALTER DATABASE ADD STANDBY LOGFILE thread 1 group 9 '+ORADATA' SIZE 100M;
ALTER DATABASE ADD STANDBY LOGFILE thread 1 group 9 '+ORADATA' SIZE 100M
*
ERROR at line 1:
ORA-00204: error in reading (block 1, # blocks 1) of control file
ORA-00202: control file: '+ORADATA/racdg/controlfile/control01.ctl'
ORA-15081: failed to submit an I/O operation to a disk
在alert日志中有这样的报错:
ORA-15025: could not open disk “/dev/mapper/asm5”
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
经检查是 问题应该是权限问题,之前的所属的组是grid:asmadmin 改为grid:oinstall之后就好了
在每个节点上的ASM软件所有者具有适当的主要用户组,ASM OSASM,ASM OSDBA,ASM OSPER和数据库OSDBA组分配给他的。 ASM磁盘/设备设置了正确的权限和所有权。