咨询微信: dbservice1234 7 x 24 在线支持!

    你在这里

    • You are here:
    • 首页 > 博客 > PDSERVICE的博客 > Oracle ASM 在节点2上ORA-15186 ORA-15063 ORA-15063: ASM 发现磁盘组 "" 的磁盘数目不足 ORA-15186: ASMLIB 错误, 函数 = [], 错误 = [], 消息 = []

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

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

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

节点不在使用多路径设备。

解决方案

确认以下:

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]