Asmdiskgroup cannot be discovered

一、现象

二、解决方法

一、检查磁盘权限
[root@racnode01 ~]# ll /dev/asm*
brw-rw---- 1 grid asmadmin 8,  16 Jan  5 16:43 /dev/asm-diskb
brw-rw---- 1 grid asmadmin 8,  32 Jan  5 16:43 /dev/asm-diskc
brw-rw---- 1 grid asmadmin 8,  48 Jan  5 16:43 /dev/asm-diskd
brw-rw---- 1 grid asmadmin 8,  64 Jan  5 15:22 /dev/asm-diske
brw-rw---- 1 grid asmadmin 8,  80 Jan  5 15:23 /dev/asm-diskf
brw-rw---- 1 grid asmadmin 8,  96 Jan  5 16:43 /dev/asm-diskg
brw-rw---- 1 grid asmadmin 8, 112 Jan  5 15:55 /dev/asm-diskh

二、检查磁盘组状态
SQL> set linesize 200 pagesize 200
SQL> col path for a40
SQL> select group_number,path,mount_status,state from v$asm_disk;

GROUP_NUMBER PATH                                     MOUNT_S STATE
------------ ---------------------------------------- ------- --------
           1 /dev/asm-diskh                           CACHED  NORMAL
           2 /dev/asm-diske                           CACHED  NORMAL
           1 /dev/asm-diskg                           CACHED  NORMAL
           2 /dev/asm-diskf                           CACHED  NORMAL
           3 /dev/asm-diskd                           CACHED  NORMAL
           3 /dev/asm-diskc                           CACHED  NORMAL
           3 /dev/asm-diskb                           CACHED  NORMAL

7 rows selected.

SQL> select group_number,offline_disks,state from v$asm_diskgroup;

GROUP_NUMBER OFFLINE_DISKS STATE
------------ ------------- -----------
           1             0 MOUNTED
           2             0 MOUNTED
           3             0 MOUNTED
三、检查用户属组
[root@racnode01 ~]# id oracle
uid=2101(oracle) gid=2000(oinstall) groups=2000(oinstall),2021(asmdba),2031(dba),2032(oper)
[root@racnode01 ~]# id grid
uid=2100(grid) gid=2000(oinstall) groups=2000(oinstall),2020(asmadmin),2021(asmdba),2022(asmoper),2031(dba)

四、检查oracle用户和grid用户$ORACLE_HOME/bin/oracle权限
[root@racnode01 ~]# su - oracle
Last login: Wed Jan  5 15:56:41 CST 2022 on pts/1

[oracle@racnode01 ~]$ ll $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle oinstall 239501488 Jan  5 15:40 /u01/app/oracle/product/11.2.0/db_1/bin/oracle

[root@racnode01 ~]# su - grid
Last login: Wed Jan  5 16:20:07 CST 2022 on pts/2
[grid@racnode01 ~]$ cd $ORACLE_HOME/bin

[grid@racnode01 bin]$ ls -l oracle
-rwxrwxr-x 1 grid oinstall 209840344 Jan  5 12:05 oracle

[grid@racnode01 bin]$ chmod +s oracle
[grid@racnode01 bin]$ ls -l oracle
-rwsrwsr-x 1 grid oinstall 209840344 Jan  5 12:05 oracle

检查发现grid用户$ORACLE_HOME/bin/oracle权限没有s权限，赋予s权限后，磁盘可以正常发现。

三、总结

DBCA建库找不到ASM磁盘一般与以下问题有关:

1. Incorrect permission setting for oracle user.
2. ASM instance was not started or diskgroups are not mounted.
3. The diskgroup resources are not online.
4. The permission setting for the asm devices are incorrect.
5. The oracle executable under /bin has incorrect permission settings.
6. the file system for grid home was mounted with option ’nosuid’.