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

Last updated on JULY 30, 2023

Applies to:

Symptoms

spfile is present as seen from
$ 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.