icon AWS Batch Starting Soon! – Register For Free Demo Session ENROLL NOW

How To Change Asm Spfile Location In Oracle RAC

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • 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

Let's Talk

Find your desired career path with us!

Let's Talk

Find your desired career path with us!