重庆思庄Oracle、Redhat认证学习论坛

标题: GI安装完成后mount磁盘组一个节点报错ora-15032 ora-15017 ora-15040 [打印本页]

作者: 刘泽宇 时间: 2022-3-7 17:11
标题: GI安装完成后mount磁盘组一个节点报错ora-15032 ora-15017 ora-15040
在GI安装完成后查看集群状态时发现，磁盘组状态不对
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
   1       ONLINE  ONLINE    rac1                   STABLE
   2       ONLINE  ONLINE    rac2                   STABLE
   3       OFFLINE OFFLINE                            STABLE
ora.DATADG.dg(ora.asmgroup)
   1       ONLINE  ONLINE    rac1                   STABLE
   2       ONLINE  OFFLINE                            STABLE
   3       ONLINE  OFFLINE                            STABLE
ora.LISTENER_SCAN1.lsnr
   1       ONLINE  ONLINE    rac1                   STABLE
ora.VOTDG.dg(ora.asmgroup)
   1       ONLINE  ONLINE    rac1                   STABLE
   2       ONLINE OFFLINE                            STABLE
   3       OFFLINE OFFLINE                            STABLE

通过asmca界面来mount磁盘组也报错：
ORA-15032: not all alterations performed
ORA-15017: diskgroup "DATADG" cannot be mounted
ORA-15040: diskgroup is incomplete

根据网上的资料参考，查看一下两个节点的asm_diskstring参数：
节点1：
SQL> show parameter asm

NAME                               TYPE       VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups                      string    DATADG
asm_diskstring                      string    /dev/oracleasm/disks

节点2：
SQL> show parameter asm

NAME                               TYPE       VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups                      string    DATADG
asm_diskstring                      string

发现节点2的参数为空
手动设置一下：
SQL> alter system set asm_diskstring='/dev/oracleasm/disks';

System altered.

SQL> alter diskgroup DATADG mount;

Diskgroup altered.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)