Oracle ASM 在节点2上ORA-15186 ORA-15063

如果自己搞不定可以找诗檀软件专业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]