• CAUSE: ORA-15018: diskgroup cannot be created


    等保要求,从linux 7.x升级到redhat8.8上安装19c,在节点一执行root.sh时报错如下

    第1次部署告警如下

    2023/10/23 15:13:08 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.
    [FATAL] [DBT-30006] Exception while Processing Request.
       CAUSE: ORA-15018: diskgroup cannot be created
    ORA-15080: synchronous I/O operation failed to write block 0 of disk 0 in disk group MGMT
    ORA-27061: waiting for async I/Os failed

    2023/10/23 15:14:19 CLSRSC-612: failed to create backup disk group 'MGMT'
    Died at /u01/app/19.0.0/grid_1/crs/install/crsinstall.pm line 1245.
     

    dd磁盘做读写都正常,清理环境后,怀疑可能是个bug,第2次执行时同时打补丁,第2次告警如下

    2023/10/25 21:30:21 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.

    [FATAL] [DBT-30006] Exception while Processing Request.
       CAUSE: ORA-15018: diskgroup cannot be created

    2023/10/25 21:30:32 CLSRSC-612: failed to create backup disk group 'MGMT'
    Died at /u01/app/19.0.0/grid_1/crs/install/crsinstall.pm line 1245.

    手动创建磁盘组测试

    SQL>  create diskgroup DATA  EXTERNAL redundancy
    disk '/dev/mapper/asm-data1' name DATA_000
    disk '/dev/mapper/asm-data2' name DATA_001
    ATTRIBUTE 'au_size'='4M',
    'compatible.asm'='19.0.0.0.0',
    'compatible.rdbms'='10.1';

      2    3    4    5    6   create diskgroup DATADG  EXTERNAL redundancy
    *
    ERROR at line 1:
    ORA-15018: diskgroup cannot be created
    Linux-x86_64 Error: 5: Input/output error
    Additional information: 4294967295
    Additional information: 65536
    ORA-27061: waiting for async I/Os failed
    Linux-x86_64 Error: 5: Input/output error
    Additional information: 4294967295
    Additional information: 65536
    ORA-27061: waiting for async I/Os failed
    Linux-x86_64 Error: 5: Input/output error
    Additional information: 4294967295
    Additional information: 65536
    ORA-27061: waiting for async I/Os failed
    Linux-x86_64 Error: 5: Input/output error
    Additional information: 4294967295
    Additional information: 65536
    ORA-27061: waiting for async I/Os failed
    Linux-x86_64 Error: 5: Input/output error
    Additional information: 4294967295
    Additional information: 65536
    ORA-27061: waiting for async I/Os failed
    Linux-x86_64 Error: 5: Input/output error
    Additional information: 4294967295
    Additional information: 65536
    ORA-27061: waiting for async I/Os failed
    Linux-x86_64 Error: 5: Input/output error
    Additional information: 4294967295
    Additional information: 65536
    ORA-27061: waiting for async I/Os failed
    Linux-x86_64 Error: 5: Input/output error
    Additional information: 4294967295
    Additional information: 65536
    ORA-27061: waiting for async I/Os failed
    Linux-x86_64 Error: 5: Input/output error
    Additional information: 4294967295
    Additional information: 65536
    ORA-27061: waiting for async I/Os failed
    Linux-x86_64 Error: 5: Input/output error
    Additional information: 4294967295
    Additional information: 65536
    ORA-15080: synchronous I/O operation failed to write block 48 of disk 1 in disk group DATA
    ORA-27061: waiting for async I/Os failed
    Linux-x86_64 Error: 5: Input/output error
    Additional information: 4294967295
    Additional information: 65536
    ORA-15080: synchronous I/O operation failed to write block 32 of disk 0 in disk group DATA
    ORA-27061: waiting for async I/Os failed
    Linux-x86_64 Error: 5: Input/output error
    Additional information: 4294967295
    Additional information: 65536
    ORA-15080: synchronous I/O operation failed to write block 0 of disk 1 in disk group

    换了补丁又测试了第3次,报错如下

    Located 5 voting disk(s).
    KFOD-00336: failed to enable Oracle Flex ASM
    ORA-15327: remote ASM is not enabled
    ORA-06512: at line 4
    ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 719
    ORA-06512: at line 2

    2023/10/26 11:34:16 CLSRSC-365: Failed to create credentials for ASM on the local node
    Died at /u01/app/19.0.0/grid_1/crs/install/crsinstall.pm line 2013.

    到这里冷静想想了,硬件和redhat8.8匹配的,感觉可能是存储端的问题,请第3方工程师新配置了200G磁盘,创建磁盘组成功,到这里基本判断是分配的mgmt磁盘和数据磁盘故障导致的。新提供了磁盘后部署正常,追问原因得到的回复有点搞笑:存储池空间用光之后,删除后再次新建没有初始化成功,重启后应该是能恢复的    

    第3方工程师年轻,新建再删除多次,导致存储池空间不足

  • 相关阅读:
    数据结构——线性表
    mysql5.7版本数据库主主同步
    阿里云2023年双十一优惠活动整理汇总
    HCIA网络课程第六周作业
    `pip` 下载速度慢
    qemu-system-arm搭建arm仿真环境
    对Flutter GetX的一些理解
    7-10 成绩排序
    【C语言】刷题训练营 —— 每日一练(十三)
    第8章_聚合函数
  • 原文地址:https://blog.csdn.net/kevinyu998/article/details/134091113