Oracle Rac中某一节点因asm_diskstring配置问题导致asm磁盘组无法挂载的问题解决

前端之家收集整理的这篇文章主要介绍了Oracle Rac中某一节点因asm_diskstring配置问题导致asm磁盘组无法挂载的问题解决前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
环境:Oracle11.2.4.0RAC
问题描述:
CRS服务不正常,asmdiskgroup挂载不了,截图如下:




日志如下:
--------------------------------------------------------------------------------------------------
WedJun2710:28:102018
sql>alterdiskgroupcrsmount
NOTE:cacheregisteredgroupCRSnumber=1incarn=0xdbd84eae
NOTE:cachebeganmount(notfirst)ofgroupCRSnumber=1incarn=0xdbd84eae
WARNING:detectedduplicatepathstothesamedisk:
'/dev/mapper/CRSp1'and
'/dev/dm-23'
Moretraceinformationdumpedto'/u01/app/grid/diag/asm/+asm/+ASM2/trace/+ASM2_ora_42445.trc'
WedJun2710:28:112018
ERROR:noreadquorumingroup:required2,found0disks
NOTE:cachedismounting(clean)group1/0xDBD84EAE(CRS)
NOTE:messagingCKPTtoquiescepinsUnixprocesspid:42445,image:oracle@db-5(TNSV1-V3)
NOTE:dbwrnotbeingmsg'dtodismount
NOTE:lgwrnotbeingmsg'dtodismount
NOTE:cachedismountedgroup1/0xDBD84EAE(CRS)
NOTE:cacheendingmount(fail)ofgroupCRSnumber=1incarn=0xdbd84eae
NOTE:cachedeletingcontextforgroupCRS1/0xdbd84eae
GMONdismountinggroup1at10forpid24,osid42445
ERROR:diskgroupCRSwasnotmounted
WARNING:DiskGroupCRScontainingspfileforthisinstanceisnotmounted
WARNING:DiskGroupCRScontainingconfiguredOCRisnotmounted
WARNING:DiskGroupCRScontainingvotingfilesisnotmounted
ORA-15032:notallalterationsperformed
ORA-15017:diskgroup"CRS"cannotbemounted
ORA-15063:ASMdiscoveredaninsufficientnumberofdisksfordiskgroup"CRS"
ERROR:alterdiskgroupcrsmount
WedJun2710:28:132018
NOTE:Noasmlibrariesfoundinthesystem
ERROR:-5(DuplicatediskDATA:DATA_0008)
ERROR:-5(DuplicatediskDATA:DATA_0001)
ERROR:-5(DuplicatediskDATA:DATA_0000)
ERROR:-5(DuplicatediskDATA:DATA_0003)
ERROR:-5(DuplicatediskCRS:CRS_0000)
ERROR:-5(DuplicatediskDATA:DATA_0007)
ERROR:-5(DuplicatediskDATA:DATA_0005)
ERROR:-5(DuplicatediskDATA2:DATA2_0002)
ERROR:-5(DuplicatediskDATA2:DATA2_0003)
ERROR:-5(DuplicatediskDATA:DATA_0004)
ERROR:-5(DuplicatediskRECOVERY:RECOVERY_0000)
ERROR:-5(DuplicatediskDATA:DATA_0002)
ERROR:-5(DuplicatediskDATA:DATA_0006)
ASMHealthCheckerfound1newfailures
------------------------------------------------------------------------------------


另一个节点正常,截图如下:



分析:

两边asm_diskstring的参数不同,

不正常的节点中asm_diskstring里存在指向重复的路径:
/dev/*,/dev/mapper/*
从而造成日志中的提示
----------------------------
--------------------------------------------------
尝试在不正常的节点下修改asm_diskstring,无法修改

在正常的节点上执行:

altersystemsetasm_diskstring='/dev/dm-*'scope=spfile;

修改成功!

然后重启不正常的节点,重启后发现asm磁盘组挂载上了!

猜你在找的Oracle相关文章