Oracle Mount ASM 磁盘组失败 : ORA-15186, ORA-15025, ORA-15063 ORA-15186: ASMLIB 错误, 函数 = [], 错误 = [], 消息 = [] ORA-15025: 无法打开磁盘 "" ORA-15063: ASM 发现磁盘组 "" 的磁盘数目不足

Posted by PDSERVICE on May 27, 2016 In

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

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

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

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

ORA-15025: 无法打开磁盘 ""

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

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.

oerr ora 15025

15025, 00000, "could not open disk \"%s\""

// *Cause: The specified disk could not be opened. If the database instance

// is running as an Operating System (OS) user different from that

// of the ASM instance, then the permissions on the database oracle

// binary may be incorrect.

// *Action: Check the additional error messages, if any. If the database

// instance is running as an OS user different from that of the

// ASM instance, use the "srvctl" command to stop and restart

// the database to fix the permissions.

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 – 版本10.2.0.1 及以上
本文信息适用于任何平台。
10-May-2013检查相关性

症状

注意关于平台：虽然’/etc/sysconfig/oracleasm’只适用于Linux环境，类似的错误可能会出现并影响使用多路径设备的非Linux环境。
Mount ASM 磁盘组失败，出现：ORA-15186, ORA-15025, ORA-15063

alert_+ASM.log:
~~~~~~~~~~~~~~~~~~
…
注：Loaded library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so
ORA-15186: ASMLIB error function = [asm_open(global)], error = [1], mesg = [Operation not permitted]
ORA-15025: could not open disk “ORCL:DISCO01BKP”
ORA-15186: ASMLIB error function = [asm_open(global)], error = [1], mesg = [Operation not permitted]
ORA-15025: could not open disk “ORCL:DISCO02BKP”
ORA-15186: ASMLIB error function = [asm_open(global)], error = [1], mesg = [Operation not permitted]
ORA-15025: could not open disk “ORCL:DISCO03BKP”
ORA-15186: ASMLIB error function = [asm_open(global)], error = [1], mesg = [Operation not permitted]
ORA-15025: could not open disk “ORCL:DISCO04BKP”
ORA-15186: ASMLIB error function = [asm_open(global)], error = [1], mesg = [Operation not permitted]
ORA-15025: could not open disk “ORCL:DISCO05BKP”
ERROR: no PST quorum in group: required 2, found 0
…
ERROR: diskgroup DATA2 was not mounted
ORA-15032: not all alterations performed
ORA-15017: diskgroup “DATA2” cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup “DATA2”

原因

所有asmlib 磁盘显示在ASM的v$asm_disk视图中，但它们的 HEADER_STATUS=UNKNOWN

但ASMLIB 查看磁盘：

$ /etc/init.d/oracleasm listdisks
DISCO01BKP
DISCO02BKP
DISCO03BKP
DISCO04BKP
DISCO05BKP
asmlib磁盘的列表，显示他们的主次编号（从左边开始第一组编号）：

$ ls -l /dev/oracleasm/disks
brw-rw—- 1 oracle oinstall 8, 1 Dec 8 10:31 DISCO01BKP
brw-rw—- 1 oracle oinstall 8, 17 Dec 8 10:31 DISCO02BKP
brw-rw—- 1 oracle oinstall 8, 33 Dec 8 10:31 DISCO03BKP
brw-rw—- 1 oracle oinstall 8, 49 Dec 8 10:31 DISCO04BKP
brw-rw—- 1 oracle oinstall 8, 65 Dec 8 10:31 DISCO05BKP
‘cat /proc/partitions’显示asmlib设备被链接到‘sd’设备，而不是‘多路径(dm)’设备。这些asmlib设备在该问题之前是被链接到多路径设备的：

major minor #blocks name
8 1 209712478 sda1
8 17 209712478 sdb1
8 33 209712478 sdc1
8 49 209712478 sdd1
8 65 209712478 sde1
…
253 0 209715200 dm-0
253 1 209715200 dm-1
253 2 209715200 dm-2
253 3 209715200 dm-3
253 4 209715200 dm-4

解决方案

与将asmlib设备映射到多路径设备相关的asmlib 文件 (/etc/sysconfig/oracleasm) ，似乎未对多路径配置：

ORACLEASM_ENABLED=true
ORACLEASM_UID=oracle
ORACLEASM_GID=oinstall
ORACLEASM_SCANBOOT=true
ORACLEASM_SCANORDER=””
ORACLEASM_SCANEXCLUDE=””
在ORACLEASM_SCANORDER 和 ORACLEASM_EXCLUDE 在/etc/sysconfig/oracleasm中被更新后，ASM就能以v$asm_disk.header_status=MEMBER显示asmlib磁盘。因此，ASM 能够mount 磁盘组。

ORACLEASM_SCANORDER=”mpath dm”
ORACLEASM_SCANEXCLUDE=”sd”

You are here

Oracle Mount ASM 磁盘组失败 : ORA-15186, ORA-15025, ORA-15063 ORA-15186: ASMLIB 错误, 函数 = [], 错误 = [], 消息 = [] ORA-15025: 无法打开磁盘 "" ORA-15063: ASM 发现磁盘组 "" 的磁盘数目不足