(一) 前言： 通过vmware workstation 走iscsi协议，安装rac 集群架构，dbca 时不能识别asm 共享存储（按理来说这一版都是权限的问题）。同时，本想通过rman 做单实例 --> 迁移 -->rac, 单在创建asm共享存储spfile参数文件时，一直报错，但是涉及的crs 服务，grid,oracle 权限都存在。
(二) 报错信息：sql> create spfile='+data/dominic/parameterfile/spfiledominic.ora' from pfile='/u01/soft/spfile_5_04';create spfile='+data/dominic/parameterfile/spfiledominic.ora' from pfile='/u01/soft/spfile_5_04'*error at line 1:ora-17502: ksfdcre:4 failed to create file+data/dominic/parameterfile/spfiledominic.oraora-01017: invalid username/password; logon denied
---这里，其实 只有真正的spfile参数放在asm存储里，其他节点rac1 ....racn 都只是一个地址的映射。
当权限组正常的话，以上命令是可以执行，同时各节点在$oracle_home/dbs/initoracle_sid.z喎?http://www.2cto.com/kf/ware/vc/ target=_blank class=keylink>vcmegcjxicj4kcibly2hviczxdw90o1nqrklmrt0=+data/anqing/parameterfile/spfildominic.ora' > /u01/app/oracle/product/11.2/db_1/dbs/initdominic1.ora
(三) 故障权限排查： oracle 家目录bin下权限，及所属组[oracle@dominic3 ~]$ cd /u01/app/oracle/product/11.2/dbhome_1/bin/[oracle@dominic3 bin]$ ll oracle-rwxrwxr-x 1 oracle asmadmin 239627031 may 17 17:32 oracle ---注意这里oracle 权限，组， 路径！
grid 家目录bin下权限，及所属组[oracle@dominic3 bin]$ cd /u01/app/11.2/grid/bin/[oracle@dominic3 bin]$ ll oracle-rwsrwsr-x 1 grid oinstall 209914869 may 17 15:58 oracle ---注意这里oracle 权限，组， 路径！
[root@dominic3 ~]# ls /dev/oracleasm/disks/* -lbrw-rw---- 1 grid asmadmin 8, 17 may 27 15:37 /dev/oracleasm/disks/data01brw-rw---- 1 grid asmadmin 8, 81 may 27 15:37 /dev/oracleasm/disks/data02brw-rw---- 1 grid asmadmin 8, 97 may 27 15:37 /dev/oracleasm/disks/log01brw-rw---- 1 grid asmadmin 8, 65 may 27 15:37 /dev/oracleasm/disks/log02brw-rw---- 1 grid asmadmin 8, 113 may 27 15:37 /dev/oracleasm/disks/ocr01brw-rw---- 1 grid asmadmin 8, 33 may 27 15:37 /dev/oracleasm/disks/ocr02brw-rw---- 1 grid asmadmin 8, 49 may 27 15:37 /dev/oracleasm/disks/ocr03
[root@dominic3 ~]# su - grid[grid@dominic3 ~]$ sqlplus / as sysasmsql> select group_number,disk_number,mount_status,header_status,mode_status,state,path from v$asm_disk;sql> / 2 0 cached member online normal orcl:data01 2 1 cached member online normal orcl:data02 3 0 cached member online normal orcl:log01 3 1 cached member online normal orcl:log02 1 0 cached member online normal orcl:ocr01 1 1 cached member online normal orcl:ocr02 1 2 cached member online normal orcl:ocr03
我把oracle 及时添加到asmadmin 组也是这样[grid@dominic3 ~]$ id oracleuid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1200(asmadmin),1201(asmdba),1300(dba),1301(oper)[grid@dominic3 ~]$ id griduid=1100(grid) gid=1000(oinstall) groups=1000(oinstall),1200(asmadmin),1201(asmdba),1202(asmoper)
-- grid 需要加入dba 权限组， asmdba grid,oracle asm的sysdba osdba for asm asmadmin grid sysasm osasmasmoper grid asm的sysoper osoper for asm
最后的结果是： asmdba, asmoper, asmadmin 在创建grid 用户时，权限组设置颠倒所致。