1. By using SqlPlus

$ sqlplus / as sysasm
SQL> show parameter spfile
NAME    TYPE      VALUE
------     ------     -------------------------------------------------
spfile     string     +DATA/ASM/ASMPARAMETERFILE/registry.253.822856169
SQL>

2. By using ASMCMD find command

$ asmcmd find --type ASMPARAMETERFILE +DATA "*"
+DATA/ASM/ASMPARAMETERFILE/REGISTRY.253.822856169

3. By using spget command

ASMCMD> spget
+DATA/ASM/ASMPARAMETERFILE/REGISTRY.253.822856169

4. By using crsctl command

$ crsctl stat res ora.asm -p | egrep "ASM_DISKSTRING|SPFILE"
ASM_DISKSTRING=
SPFILE=+DATA/ASM/ASMPARAMETERFILE/registry.253.822856169

5. By using gpnp tool

Note: mostly used when ASM is not up.

[grid@racp1vm1 ~]$ gpnptool get -o- | xmllint --format - | grep SPFile
Success.
<orcl:ASM-Profile id="asm" DiscoveryString="" SPFile="+DATA/ASM/ASMPARAMETERFILE/registry.253.822856169" Mode="remote"/>

6. From alert.log

[grid@racp1vm1 ~]$ cat alert+ASM1.log | grep "parameter setting"
Using parameter settings in server-side spfile +DATA/ASM/ASMPARAMETERFILE/registry.253.822856169

Comments

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.