如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 ： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com

   

适用于：

Oracle Database - Enterprise Edition – 版本 11.1.0.7 到11.2.0.3 [Release 11.1 to 11.2] 本文信息适用于任何平台。

症状

 在一个2节点RAC集群中创建asmlib 磁盘后

- 在第一个节点上磁盘组被成功创建，

- 在第二个节点上尝试mount磁盘组，得到：：ORA-15063: ASM discovered an insufficient number of disks for diskgroup

- 查询v$asm_disk – 显示 header_status: unknown

同样在节点2看到以下错误

SQL> ALTER DISKGROUP ALL MOUNT NOTE: cache registered group DATA0 number=1 incarn=0x6805c243 NOTE: cache began mount (not first) of group DATA0 number=1 incarn=0x6805c243 NOTE: cache registered group FRA number=2 incarn=0x6805c244 NOTE: cache began mount (not first) of group FRA number=2 incarn=0x6805c244 NOTE:Loaded lib: /opt/oracle/extapi/64/asm/orcl/1/libasm.so ERROR: kfkOsmIdent:asm_open(): asm_erc:1 msg:Operation not permitted pid:15563 ORA-15186: ASMLIB error function = [kfkOsmIdent:asm_open], Â error = [1], Â mesg = [Operation not permitted] ERROR: kfkOsmIdent:asm_open(): asm_erc:1 msg:Operation not permitted pid:15563 ORA-15186: ASMLIB error function = [kfkOsmIdent:asm_open], Â error = [1], Â mesg = [Operation not permitted] ERROR: kfkOsmIdent:asm_open(): asm_erc:1 msg:Operation not permitted pid:15563 ORA-15186: ASMLIB error function = [kfkOsmIdent:asm_open], Â error = [1], Â mesg = [Operation not permitted] ERROR: kfkOsmIdent:asm_open(): asm_erc:1 msg:Operation not permitted pid:15563 ORA-15186: ASMLIB error function = [kfkOsmIdent:asm_open], Â error = [1], Â mesg = [Operation not permitted] ERROR: kfkOsmIdent:asm_open(): asm_erc:1 msg:Operation not permitted pid:15563 ORA-15186: ASMLIB error function = [kfkOsmIdent:asm_open], Â error = [1], Â mesg = [Operation not permitted]

原因

在节点1

$ ls -l /dev/oracleasm/disks total 0 brw-rw---- 1 oracle dba 253, 34 Sep 18 07:34 ASMDB1 brw-rw---- 1 oracle dba 253, 29 Sep 18 07:36 ASMF1 brw-rw---- 1 oracle dba 253, 28 Sep 18 07:37 ASMRD1 brw-rw---- 1 oracle dba 253, 25 Sep 18 07:38 ASMRD2 brw-rw---- 1 oracle dba 253, 33 Sep 18 07:39 ASMT1 在节点2 ---->oracle@xxxxxx:/oracle/diag/asm/+asm/+ASM2/trace $ ls -l /dev/oracleasm/disks total 0 brw-rw---- 1 oracle dba 65, 161 Sep 18 07:40 ASMDB1 brw-rw---- 1 oracle dba 65, 177 Sep 18 07:40 ASMF1 brw-rw---- 1 oracle dba 65, 193 Sep 18 07:40 ASMRD1 brw-rw---- 1 oracle dba 65, 209 Sep 18 07:40 ASMRD2 brw-rw---- 1 oracle dba 65, 225 Sep 18 07:40 ASMT1 节点2 不在使用多路径设备。

解决方案

确认以下：

1.   两个节点都有相同 /etc/sysconfig/oracleasm  文件且都有以下行 # ORACLEASM_SCANORDER: Matching patterns to order disk scanning ORACLEASM_SCANORDER="dm" # ORACLEASM_SCANEXCLUDE: Matching patterns to exclude disks from scan ORACLEASM_SCANEXCLUDE="sd" 2.  两个节点显示相同symlink ，当发出以下： # ls -l  /etc/sysconfig/oracleasm lrwxrwxrwx 1 root root 24 Sep 18 22:10 /etc/sysconfig/oracleasm -> oracleasm-_dev_oracleas 一旦完成，请重新扫描#oracleasm scandisks 并再次验证两个节点上的# ls -l /dev/oracleasm/disks 。

它们应当使用dm 设备而不是单路径。 

参考

NOTE:398622.1 - ORA-15186: ASMLIB error function = [asm_open], error = [1], mesg = [Operation not permitted]