Errors in file : ORA-27091: unable to queue I/O

最新推荐文章于 2021-09-08 16:58:08 发布

pengpengfly_jhp

最新推荐文章于 2021-09-08 16:58:08 发布

阅读量4.5k

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库问题解决

本文链接：https://blog.youkuaiyun.com/pengpengfly_jhp/article/details/21696219

数据库问题解决专栏收录该内容

17 篇文章

订阅专栏

本文记录了一次Oracle RAC集群安装过程中遇到的问题及解决方案，特别是在oracleasm配置时将UID错误设置为oracle而非grid导致的错误。通过删除并重新配置磁盘组，最终解决了安装过程中的I/O操作失败问题。

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

安装RAC时，跑root.sh脚本报错:

已成功创建磁盘组DATA。

Errors in file :

ORA-27091: unable to queue I/O

ORA-15081: failed to submit an I/O operation to a disk

ORA-06512: at line 4

Errors in file :

ORA-27091: unable to queue I/O

ORA-15081: failed to submit an I/O operation to a disk

ORA-06512: at line 4

Errors in file :

ORA-27091: unable to queue I/O

ORA-15081: failed to submit an I/O operation to a disk

ORA-06512: at line 4

Errors in file :

ORA-27091: unable to queue I/O

ORA-15081: failed to submit an I/O operation to a disk

ORA-06512: at line 4

Errors in file :

Failed to create Oracle Cluster Registry configuration, rc 255

Oracle Grid Infrastructure Repository configuration failed at /u01/gridsoft/11.2.0/crs/install/crsconfig_lib.pm line 6769.

/u01/gridsoft/11.2.0/perl/bin/perl -I/u01/gridsoft/11.2.0/perl/lib -I/u01/gridsoft/11.2.0/crs/install /u01/gridsoft/11.2.0/crs/install/rootcrs.pl execution failed

发现由于安装RAC时参考了两个文档,在配置oracleasm的时候，把UID配成了oracle，而不是grid

解决办法：
[root@rac1 ~]# /u01/app/grid/crs/install/rootcrs.pl -deconfig -force
[root@rac1 ~]# /usr/sbin/oracleasm deletedisk DISK1
Clearing disk header: done
Dropping disk: done
[root@rac1 ~]# /usr/sbin/oracleasm deletedisk DISK2
Clearing disk header: done
Dropping disk: done
[root@rac1 ~]# /usr/sbin/oracleasm deletedisk DISK3
Clearing disk header: done
Dropping disk: done
[root@rac1 ~]# /usr/sbin/oracleasm deletedisk DISK4
Clearing disk header: done
Dropping disk: done
[root@rac1 ~]# /usr/sbin/oracleasm deletedisk DISK5
Clearing disk header: done
Dropping disk: done
在每一个节点上执行：
[root@rac1 ~]# /usr/sbin/oracleasm configure -u grid
Writing Oracle ASM library driver configuration: done
[root@rac1 ~]# /usr/sbin/oracleasm configure
ORACLEASM_ENABLED=true
ORACLEASM_UID=grid
ORACLEASM_GID=dba
ORACLEASM_SCANBOOT=true
ORACLEASM_SCANORDER=""
ORACLEASM_SCANEXCLUDE=""
在每一个节点上执行：
[root@rac1 ~]# /usr/sbin/oracleasm exit
Unmounting ASMlib driver filesystem: /dev/oracleasm
Unloading module "oracleasm": oracleasm
[root@rac1 ~]# /usr/sbin/oracleasm init
Loading module "oracleasm": oracleasm
Mounting ASMlib driver filesystem: /dev/oracleasm
[root@rac1 ~]# /usr/sbin/oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
在第一个节点上重新创建磁盘组：
[root@rac1 ~]# /usr/sbin/oracleasm createdisk DISK1 /dev/sdb1
Writing disk header: done
Instantiating disk: done
[root@rac1 ~]# /usr/sbin/oracleasm createdisk DISK2 /dev/sdc1
Writing disk header: done
Instantiating disk: done
[root@rac1 ~]# /usr/sbin/oracleasm createdisk DISK3 /dev/sdd1
Writing disk header: done
Instantiating disk: done
[root@rac1 ~]# /usr/sbin/oracleasm createdisk DISK4 /dev/sde1
Writing disk header: done
Instantiating disk: done
[root@rac1 ~]# /usr/sbin/oracleasm createdisk DISK5 /dev/sdf1
Writing disk header: done
Instantiating disk: done
[root@rac1 ~]# /usr/sbin/oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
[root@rac1 ~]# /usr/sbin/oracleasm listdisks
DISK1
DISK2
DISK3
DISK4
DISK5
在第二个节点上执行：
[root@rac2 ~]# /usr/sbin/oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
Instantiating disk "DISK1"
Instantiating disk "DISK2"
Instantiating disk "DISK3"
Instantiating disk "DISK4"
Instantiating disk "DISK5"
[root@rac2 ~]# /usr/sbin/oracleasm listdisks
DISK1
DISK2
DISK3
DISK4
DISK5
再次运行root.sh脚本
[root@rac1 ~]# /u01/app/grid/root.sh
Running Oracle 11g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/grid