[INS-30502] No ASM disk group found.

最新推荐文章于 2024-05-26 16:33:56 发布

原创最新推荐文章于 2024-05-26 16:33:56 发布 · 2.0k 阅读

1 ·

CC 4.0 BY-SA版权

oracle 专栏收录该内容

103 篇文章

订阅专栏

在安装Oracle数据库过程中遇到无法检测到ASM磁盘组的问题，通过日志发现原因是DATA磁盘组未被ASM实例管理。文章详细记录了排查过程及解决方案，包括检查磁盘权限、ASM实例参数和启动资源状态等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在安装GI的时候检查不到节点，通过修改/u01/app/oraInventory.xml 的CRS=true参数得以解决，安装GI正常。但是在安装database的时候，检测不到asm磁盘组，

这里写图片描述

查看日志：
SEVERE: [FATAL] [INS-30502] No ASM disk group found.
CAUSE: There were no disk groups managed by the ASM instance +ASM1.
ACTION: Use Automatic Storage Management Configuration Assistant to add disk groups.

查看节点服务都正常

[grid@node1$]crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host        
----------------------------------------------------------------------
ora.ARCH.dg    ora....up.type 0/5    0/     ONLINE    ONLINE    node1       
ora.BACKUP.dg  ora....up.type 0/5    0/     ONLINE    ONLINE    node1       
ora.DATA.dg    ora....up.type 0/5    0/     ONLINE    ONLINE    node1       
ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    node2       
ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    node1       
ora.cvu        ora.cvu.type   0/5    0/0    ONLINE    ONLINE    node2       
ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE               
ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    node1       
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    node1       
ora.node1.gsd  application    0/5    0/0    OFFLINE   OFFLINE               
ora.node1.ons  application    0/3    0/0    ONLINE    ONLINE    node1       
ora.node1.vip  ora....t1.type 0/0    0/0    ONLINE    ONLINE    node1       
ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    node2       
ora.node2.gsd  application    0/5    0/0    OFFLINE   OFFLINE               
ora.node2.ons  application    0/3    0/0    ONLINE    ONLINE    node2       
ora.node2.vip  ora....t1.type 0/0    0/0    ONLINE    ONLINE    node2       
ora.oc4j       ora.oc4j.type  0/1    0/2    ONLINE    ONLINE    node2       
ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    node1       
ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    node2

查看磁盘权限

[root@node2 ~]# ls -l /dev/oracleasm/disks/
total 0
brw-rw---- 1 grid oinstall 8, 17 Oct 11 09:28 VOL1
brw-rw---- 1 grid oinstall 8, 33 Oct 11 09:25 VOL2
brw-rw---- 1 grid oinstall 8, 49 Oct 11 09:25 VOL3

查看asm实例磁盘组参数：

SQL> show parameter disk_

NAME                                 TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
asm_diskgroups                       string
ARCH, BACKUP
asm_diskstring                       string
/dev/oracleasm/disks/VOL*

可以看到asm-diskgroups没有DATA磁盘，CRS也存放在DATA磁盘组中的，所以需要把DATA添加到asm_diskgroups参数中。

查看初始化进程状态：

[grid@node2$] crsctl status res -t -init
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
      1        ONLINE  ONLINE       node2                    Started             
ora.cluster_interconnect.haip
      1        ONLINE  ONLINE       node2                                        
ora.crf
      1        ONLINE  ONLINE       node2                                        
ora.crsd
      1        ONLINE  ONLINE       node2                                        
ora.cssd
      1        ONLINE  ONLINE       node2                                        
ora.cssdmonitor
      1        ONLINE  ONLINE       node2                                        
ora.ctssd
      1        ONLINE  ONLINE       node2                    ACTIVE:0            
ora.diskmon
      1        OFFLINE OFFLINE                                                   
ora.evmd
      1        ONLINE  ONLINE       node2                                        
ora.gipcd
      1        ONLINE  ONLINE       node2                                        
ora.gpnpd
      1        ONLINE  ONLINE       node2                                        
ora.mdnsd
      1        ONLINE  ONLINE       node2

发现ora.diskmon资源没有启动，查看diskmon日志，发现diskmon日志没有生成，查看crs 日志

ASM Error Stack : ORA-15077: could not locate ASM instance serving a required diskgroup
[1136805664]proprasmo: kgfoCheckMount returned [7]
[1136805664]proprasmo: The ASM instance is down
proprioo: Failed to open [+DATA]. Returned proprasmo() with [26]. Marking location as UNAVAILABLE.
proprioo: No OCR/OLR devices are usable
[1136805664]proprasmcl: asmhandle is NULL
[1136805664]clsvactversion:4: Retrieving Active Version from local storage.
[1136805664]clssgsgrppubdata: group (ocr_node-cluster) not found
[1136805664]proprio_repairconf: Failed to retrieve the group public data. CSS ret code [20]
[1136805664]proprioo: Failed to auto repair the OCR configuration.
[1136805664]proprinit: Could not open raw device
[1136805664]proprasmcl: asmhandle is NULL
[1136805664]a_init:16!: Backend init unsuccessful : [26]
[1136805664] OCR context init failure.  Error: PROC-26: Error while accessing the physical storage
ORA-15077: could not locate ASM instance serving a required diskgroup
[1136805664] Created alert : (:CRSD00111:) :  Could not init OCR, error: PROC-26: Error while accessing the physical storage
ORA-15077: could not locate ASM instance serving a required diskgroup
[1136805664][PANIC] CRSD exiting: Could not init OCR, code: 26

可见，创建ASM磁盘出了问题。