ASM Instance Not USING SPFILE EVEN SPFILE EXISTS IN DISKGROUP
(Doc ID 1638239.1)
Last updated on JULY 30, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |