Recently we found that, one of our asm instance was using a different spfile. So used below steps to change the spfile.
existing spfile – > /u01/app/grid/dbs/asmbackup.ora
new spfile – > +OCR_VOTING/CLUSTER/ASMPARAMETERFILE/spfileASM.ora
1. Find the current spfile of asm:
export ORACLE_SID=+ASM1
sqlplus / as sysdba
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /u01/app/grid/dbs/asmbackup.ora
In case the spfile value is null in above statement, then use spget command.
$ asmcmd
ASMCMD> spget
/u01/app/grid/dbs/asmbackup.ora
2. update the asm spfile location:
[oracle]$ srvctl modify asm -spfile +OCR_VOTING/CLUSTER/ASMPARAMETERFILE/spfileASM.ora
PRKO-2207 : Warning:--spfile option has been deprecated and will be ignored.
--- If you are getting above error, then use the spset command to set the spfile for asm:
ASMCMD> spset +OCR_VOTING/CLUSTER/ASMPARAMETERFILE/spfileASM.ora
ASMCMD> spget
+OCR_VOTING/CLUSTER/ASMPARAMETERFILE/spfileASM.ora
DBA CHEATSHEET:
- Useful Srvctl Commands
- Useful CRSCTL Commands
- Useful Gather Statistics Commands In Oracle
- Useful ADRCI Commands In Oracle
- Useful DGMGRL Commands In Oracle Dataguard
- Useful database monitoring queries
- Useful Flashback Related Commands
- Useful scheduler job Related Commands
- Useful Oracle Auditing Related Commands
- Useful RMAN Commands
- Useful TFACTL Commands
- Useful OPATCH Commands