asm_diskstring=配置了重复路径，读磁盘，asmspfile不启作用？

参考资料：

https://mp.weixin.qq.com/s?__biz=MjM5NzA1NTMwOA==&mid=2702718023&idx=1&sn=4f8679f7504b47a2164bfb8131b4b467&chksm=82334a64b544c372a1b26d36e743c10a061a28c679d28764e7aea12f379b85967b9200f2d70a&mpshare=1&scene=1&srcid=0705TJzyNdrudflKvaGjfjp3&pass_ticket=DfRDnGO%2BD9U45sgPw1ky%2FxY3KciAXK%2Bxue9OI9%2FOgisOiiIYcrlu%2FRiPXv1ZSBxl#rd

ASM Instance Not USING SPFILE EVEN SPFILE EXISTS IN DISKGROUP (文档 ID 1638239.1)

解决方法：asm_diskstring=配置成唯一识别磁盘的路径

In this Document

spfile is present as seen from

---

 

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

SYMPTOMS

$ asmcmd spget
+OCR/ASMPARAMETERFILE/spfileASM.ora
$
$ asmcmd ls +OCR/ASMPARAMETERFILE/spfileASM.ora
spfileASM.ora


$ gpnptool get
Warning: some command line parameters were defaulted. Resulting command line:
       /u02/oracle/ASM/grid/11203/bin/gpnptool.bin get -o-

<?xml version="1.0" encoding="UTF-8"?><gpnp:GPnP-Profile Version="1.0" xmlns="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:gpnp="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:orcl="http://www.oracle.com/gpnp/2005/11/gpnp-profile" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.grid-pnp.org/2005/11/gpnp-profile gpnp-profile.xsd" ProfileSequence="22" ClusterUId="64e4f9244c5bdfa0bf92d3d0f2f2ed8b" ClusterName="svd0oracp00" PALocation=""><gpnp:Network-Profile><gpnp:HostNetwork id="gen" HostName="*"><gpnp:Network id="net1" IP="x.x.x.x" Adapter="eth0" Use="public"/><gpnp:Network id="net2" IP="x.x.x.x" Adapter="eth1" Use="cluster_interconnect"/></gpnp:HostNetwork></gpnp:Network-Profile><orcl:CSS-Profile id="css" DiscoveryString="+asm" LeaseDuration="400"/><orcl:ASM-Profile id="asm" DiscoveryString="/dev/mapper*,ORCL:*" SPFile="+OCR/ASMPARAMETERFILE/spfileASM.ora"/><ds:Signature xmlns:ds="http://www.w3.org/2000/09/xmldsig#"><ds:SignedInfo><ds:CanonicalizationMethod Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"/><ds:SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/><ds:Reference URI=""><ds:Transforms><ds:Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/><ds:Transform Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"> <InclusiveNamespaces xmlns="http://www.w3.org/2001/10/xml-exc-c14n#" PrefixList="gpnp orcl xsi"/></ds:Transform></ds:Transforms><ds:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/><ds:DigestValue>muuY4twI87QlJTO/nFYX9O85K08=</ds:DigestValue></ds:Reference></ds:SignedInfo><ds:SignatureValue>GC+601hriggfLNSfxZYv5/lW5G1oEh46ySfRewj4U/F1jt0oyCSYUmvU5a6aBT0hg5MhHgmi3I2+Zonit7DmCq+5pujc1lb6Gf/DJMVp3siSZGaKwu+UrB8+NVOoSvmzkHmexwc6Slz1Bq3vqIAB7iWuXPoZOfDWtHKmc3zFlCs=</ds:SignatureValue></ds:Signature></gpnp:GPnP-Profile>
Success.
$

- But still ASM instance is not picking up the spfile.
Ct is able to create a pfile from the spfile.
Also tried moving the spfile to a different DG.

However still , when opening up the instance via sql*plus, it is failing with that spfile

SQL> startup
 ORA-01078: failure in processing system parameters
 ORA-01565: error in identifying file '+OCR/svd0oracp00/ASMPARAMETERFILE/spfileASM.ora'
 ORA-17503: ksfdopn:2 Failed to open file +OCR/svd0oracp00/ASMPARAMETERFILE/spfileASM.ora

 

Entries in ASM alertlog like below:

 

Sun Nov 03 17:25:29 2013
ERROR: -5(Duplicate disk FRA:FRA_0000)
ERROR: -5(Duplicate disk FRA:FRA_0001)
ERROR: -5(Duplicate disk FRA:FRA_0002)
ERROR: -5(Duplicate disk FRA:FRA_0003)
ERROR: -5(Duplicate disk DATA:DATAPRODDG01VOL1ALUN1)

...................

ERROR: -5(Duplicate disk VOTING1:VOTING1_0002)
* instance_number obtained from CSS = 2, checking for the existence of node 0... 
* node 0 does not exist. instance_number = 2 
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Using LOG_ARCHIVE_DEST_1 parameter default value as /u02/oracle/ASM/grid/11203/dbs/arch
Autotune of undo retention is turned on. 
LICENSE_MAX_USERS = 0
SYS auditing is disabled
NOTE: Volume support  enabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options.
ORACLE_HOME = /u02/oracle/ASM/grid/11203
System name: Linux
Release: 2.6.18-348.12.1.0.1.el5
Version: #1 SMP Wed Jul 10 09:11:00 PDT 2013
Machine: x86_64
Using parameter settings in server-side pfile /u02/oracle/ASM/grid/11203/dbs/init+ASM2.ora
System parameters with non-default values:

CHANGES

 Changes in asm_diskstring parameter

CAUSE

 
Sun Nov 03 15:43:11 2013
NOTE: updated gpnp profile ASM diskstring: /dev/mapper*,ORCL:*
NOTE: updated gpnp profile ASM diskstring: /dev/mapper*,ORCL:*
NOTE: Attempting voting file relocation on diskgroup VOTE
NOTE: updated gpnp profile ASM SPFILE to +OCR/asmparameterfile/registry.253.830533391

 

Below from gpnptool get:

DiscoveryString="/dev/mapper*,ORCL:*" SPFile="+OCR/ASMPARAMETERFILE/spfileASM.ora"
 

As per major / minor number,same disks are opened through two paths which ASM can access .This resulted as duplicate disk .

Causing this issue .

SOLUTION

Refer the below note to fixing the issue.

How to fix the "DiscoveryString in profile.xml" or "asm_diskstring in ASM" if set wrongly (Doc ID 1077094.1)

Depending on environment architechture ,

need to modify as below (any one of the below).

 

If want to use ASMLib ,

asm_diskstring='ORCL:*'

or

If do not want to use ASMLib,

asm_diskstring='/dev/mapper*'
 

REFERENCES

NOTE:1376225.1 - How to Modify an Existing ASM Spfile in a RAC Environment