Oracle ASM 在节点2上ORA-15186 ORA-15063 ORA-15063: ASM 发现磁盘组 "" 的磁盘数目不足 ORA-15186: ASMLIB 错误, 函数 = [], 错误 = [], 消息 = []

Posted by PDSERVICE on May 28, 2016 In

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

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

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

ORA-15186: ASMLIB 错误, 函数 = [], 错误 = [], 消息 = []

oerr ora 15186

15186, 00000, "ASMLIB error function = [%s], error = [%s], mesg = [%s]"

// *Cause: An error occured during a call to function listed in the error.

// *Action: The detailed message associated with the error is listed along with

// the error. Correct the error and try again or contact ASMLIB

// library vendor for support.

ORA-15063: ASM 发现磁盘组 "" 的磁盘数目不足

oerr ora 15063

15063, 00000, "ASM discovered an insufficient number of disks for diskgroup \"%s\""

// *Cause: ASM was unable to find a sufficient number of disks belonging to the

// diskgroup to continue the operation.

// *Action: Check that the disks in the diskgroup are present and functioning,

// that the owner of the ORACLE binary has read/write permission to

// the disks, and that the ASM_DISKSTRING initialization parameter

// has been set correctly. Verify that ASM discovers the appropriate

// disks by querying V$ASM_DISK from the ASM instance.

适用于：

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]

You are here

Oracle ASM 在节点2上ORA-15186 ORA-15063 ORA-15063: ASM 发现磁盘组 "" 的磁盘数目不足 ORA-15186: ASMLIB 错误, 函数 = [], 错误 = [], 消息 = []