How to obtain the Oracle 11g RAC asm spfile location

How to obtain the Oracle 11g RAC asm spfile location

How to obtain the Oracle 11g RAC asm spfile location

Method 1:
[Root @ vmrac1 ~] # Su-grid
[Grid @ vmrac1 ~] $ Sqlplus/as sysasm
 
SQL * Plus: Release 11.2.0.3.0 Production on Thu Jul 3 09:36:27 2014
 
Copyright (c) 1982,201 1, Oracle. All rights reserved.
 

Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production
With the Real Application Clusters and Automatic Storage Management options
 
SQL> select sys_context ('sys _ cluster_properties ', 'asm _ spfile', 4000) as val from dual;
 
VAL
--------------------------------------------------------------------------------
+ DUPCRS/vmrac-cluster/asmparameterfile/registry.253.850656291
 

Method 2:
SQL> show parameter pfile
 
NAME TYPE VALUE
-----------------------------------------------------------------------------
Spfile string + DUPCRS/vmrac-cluster/asmparam
Eterfile/registry.253.850656291
 

Method 3:
ASMCMD> spget
+ DUPCRS/vmrac-cluster/asmparameterfile/registry.253.850656291
 

Method 4:
[Root @ vmrac2 ~] # Gpnptool get 2>/dev/null | xmllint -- format-| egrep 'css-Profile | ASM-Profile | Network id'
<Gpnp: HostNetwork id = "gen" HostName = "*">
<Gpnp: Network id = "net1" IP = "10.80.18.0" Adapter = "eth0" Use = "public"/>
<Gpnp: Network id = "net2" IP = "10.0.0.0" Adapter = "eth1" Use = "cluster_interconnect"/>
<Orcl: CSS-Profile id = "css" DiscoveryString = "+ asm" LeaseDuration = "400"/>
<Orcl: ASM-Profile id = "asm" DiscoveryString = "" SPFile = "+ DUPCRS/vmrac-cluster/asmparameterfile/registry.253.850656291"/>

11g rac rebuilding the SPFILE of the ASM instance

Another SPFILE setting error causes the database to fail to start.