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

    你在这里

    • You are here:
    • 首页 > 博客 > PDSERVICE的博客 > Oracle Mount ASM 磁盘组失败 : ORA-15186, ORA-15025, ORA-15063 ORA-15186: ASMLIB 错误, 函数 = [], 错误 = [], 消息 = [] ORA-15025: 无法打开磁盘 "" ORA-15063: ASM 发现磁盘组 "" 的磁盘数目不足

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

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

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