- 01 Sep, 2023
- 0 Comments
- 40 Secs Read
How To Change Asm Spfile Location In Oracle RAC
How To Change Asm Spfile Location In Oracle RAC
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 spfile OR use spget command. $ asmcmd ASMCMD> spget
2. update the asm spfile location:
[oracle]$ srvctl modify asm -spfile +OCR_VOTING/CLUSTER/ASMPARAMETERFILE/spfileASM.ora ASMCMD> spset +OCR_VOTING/CLUSTER/ASMPARAMETERFILE/spfileASM.ora ASMCMD> spget +OCR_VOTING/CLUSTER/ASMPARAMETERFILE/spfileASM.ora