• 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方工程师年轻,新建再删除多次,导致存储池空间不足

  • 相关阅读:
    【原创】在Linux上安装Zabbix客户端
    听说转行软件测试只能自学,培训机构是个坑?
    ModelBox姿态匹配:抖抖手动动脚勤做深呼吸
    @RepositoryRestResource 和 @RepositoryRestController 浅析
    算法与数据结构 - 散列表
    Dijkstra算法
    如何在idea中创建一个SpringBoot项目(超详细教学)
    10.3 调试事件转存进程内存
    Docker从入门到进阶之进阶操作(3) —— 使用 supermin5来构建镜像
    golang的channel探索
  • 原文地址:https://blog.csdn.net/kevinyu998/article/details/134091113