top of page
Move Spfile to ASM
Step-by-step guide to relocating the spfile to ASM storage.
With ASM configured for RAC or NON-RAC systems, it is a good idea to move the spfile to ASM. The PFILE under $ORACLE_HOME/dbs location actually points to the SPFILE on ASM disk.
Create PFILE from SPFILE
Check if your database is running with SPFILE, if yes then create pfile from spfile
show parameter spfile
NAME TYPE VALUE
-------- ----------- ------------------------------
spfile string /oracle/app/oracle/product/dbs/spfileORCL.ora
Create PFILE from the existing SPFILE
Create pfile from spfile;
File created.
Create Directory in ASM Diskgroup
Connect to ASMCMD (grid) and create directory to hold the SPFILE
asmcmd
ASMCMD> mkdir +DATA/ORCL/PARAM
Create SPFILE in ASM from PFILE
Now that we have the PFILE, we can create SPFILE from PFILE directly inside ASM
SQL> create spfile='+DATA/ORCL/PARAM/spfileORCL.ora' from pfile;
Rename the SPFILE under $ORACLE_HOME/dbs location
cd $ORACLE_HOME/dbs
mv spfileORCL.ora spfileORCL.ora_B4_ASM
Point PFILE to SPFILE on ASM
Edit the PFILE and just add one single line below to point SPFILE on ASM
vi initORCL.ora
spfile='+DATA/ORCL/PARAM/spfileORCL.ora'
Restart the database!
bottom of page