Method One:
[Email protected] ~]# Su-grid
[Email protected] ~]$ Sqlplus/as sysasm
Sql*plus:release 11.2.0.3.0 Production on Thu Jul 3 09:36:27 2014
Copyright (c) 1982, Oracle. All rights reserved.
Connected to:
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 Two:
Sql> Show Parameter Pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
SPFile string +dupcrs/vmrac-cluster/asmparam
eterfile/registry.253.850656291
Method Three:
Asmcmd> Spget
+dupcrs/vmrac-cluster/asmparameterfile/registry.253.850656291
Method Four:
[[email protected] ~]# 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= "+"/>
<orcl:asm-profile id= "ASM" discoverystring= "spfile=" +dupcrs/vmrac-cluster/asmparameterfile/ registry.253.850656291 "/>
Copyright notice: This article blog original article. Blogs, without consent, may not be reproduced.
How to obtain Oracle RAC 11g ASM spfile s file