测试环境: 数据库节点系统:rhel 6.8 x86_64 数据库版本:Oracle 11.2.0.4 RAC 背景: 对比分布式存储和IBM传统存储性能对比。 共三块磁盘,冗余模式采取normal。 在安装数据库集群时,节点一执行root.sh执行失败,提示ORA-27061: waiting for async I/Os failed with root.sh 初步怀疑由于磁盘属性或数组问题,对比两台数据库主机映射磁盘正常,权限正确。 使用grid用户读写共享盘,验证通过 dd if=/dev/urandom of=/dev/asm/asm-diskb bs=4096 count=1000 dd if= =/dev/asm/asm-diskb of=/dev/zero bs=4096 count=1000 多次搜索无果,打算采取外部冗余,测试每块磁盘,此时分布式管理人员该问题可能由于三块共享盘sector size不一致导致。 检查分布式磁盘,发现一块磁盘sector size 是4096,其他两台为512。 [root@htdb01 ~]# fdisk -l ...... Disk /dev/mapper/c1p1: 1600.3 GB, 1600321314816 bytes 255 heads, 63 sectors/track, 194561 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 4096 bytes / 524288 bytes Disk identifier: 0x00000000 Disk /dev/mapper/c2p1: 1600.3 GB, 1600321314816 bytes 255 heads, 63 sectors/track, 194561 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 4096 bytes / 524288 bytes Disk identifier: 0x00000000 Disk /dev/mapper/c3p1: 1600.3 GB, 1600321314816 bytes 255 heads, 63 sectors/track, 194561 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Sector size (logical/physical): 4096 bytes / 4096 bytes I/O size (minimum/optimal): 4096 bytes / 524288 bytes Disk identifier: 0x00000000 确认问题后,调整分布式系统上磁盘属性,涉及命令为hdm,软件为:hdm-core-3.3.0-25.ga-x86_64.rpm 安装后检查分布式磁盘信息: [root@yxcel03 soft]# hdm scan [1C58SDM00001F5A7HUSMR7632BHP3010023] Product Name = Ultrastar SN260 Device Type = NVMe Controller Device Path = /dev/nvme0 UID = 1C58SDM00001F5A7HUSMR7632BHP3010023 Alias = @nvme0 Vendor Name = HGST Model Name = HUSMR7632BHP301 Vendor ID = 1C58 Device ID = 0023 NVM Subsystem UID = 1C58SDM00001F5A7HUSMR7632BHP301 [000CCA0B018E1280] Device Type = NVMe Namespace Device Path = /dev/nvme0n1 UID = 000CCA0B018E1280 Alias = @nvmens0 Parent Product Name = Ultrastar SN260 Parent Device Type = NVMe Controller Parent Device Path = /dev/nvme0 Parent UID = 1C58SDM00001F5A7HUSMR7632BHP3010023 NVM Subsystem UID = 1C58SDM00001F5A7HUSMR7632BHP301 Namespace ID = 1 ...... 调整磁盘sector大小 [root@htcel02 soft]# hdm format --sector-size 512 -p /dev/nvme0 This operation will erase all user data on the specified devices. Before starting this operation, unmount any mounted file systems on the devices or take the devices offline. After this operation is complete, the specified devices will be reset, which may cause other operations to be interrupted. Press 'y' to continue: y [Notes] A system restart or shutdown is required to complete the operation. Device Reference = /dev/nvme0 Results for format: Operation succeeded. See Notes. [root@htcel02 soft]# reboot 重启系统后,数据库集群root.sh脚本执行完成。
Sector size导致ORA-27061: waiting for async I/Os failed with root.sh
来源:这里教程网
时间:2026-03-03 12:51:22
作者:
编辑推荐:
下一篇:
相关推荐
-
雷神推出 MIX PRO II 迷你主机:基于 Ultra 200H,玻璃上盖 + ARGB 灯效
2 月 9 日消息,雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C:支持手写笔、第三方安卓应用
2 月 10 日消息,制造商 Musnap 现已在海外推出一款 Oce
热文推荐
- 问鼎大师我的OCM之路——程向智
问鼎大师我的OCM之路——程向智
26-03-03 - oracle、mysql数据库窗口下执行操作系统命令
oracle、mysql数据库窗口下执行操作系统命令
26-03-03 - 由db_domain引起的数据库连接异常
由db_domain引起的数据库连接异常
26-03-03 - Oracle表空间切换路径,解决硬盘满导致的ORA-01653问题
Oracle表空间切换路径,解决硬盘满导致的ORA-01653问题
26-03-03 - Debian日志分析最佳实践(新手也能掌握的Linux系统日志管理与安全审计指南)
- ORA-15083: failed to communicate with ASMB background process
- 并行处理 Parallel Processing
并行处理 Parallel Processing
26-03-03 - oracle_Parallel相关参数设置不当引起的系统故障
oracle_Parallel相关参数设置不当引起的系统故障
26-03-03 - ASM维护工具 (KFOD KFED AMDU)
ASM维护工具 (KFOD KFED AMDU)
26-03-03 - Oracle集群技术 | 集群的自启动系列(一)
Oracle集群技术 | 集群的自启动系列(一)
26-03-03
