Move SPFILE to ASM RAC

— Move SPFILE to ASM RAC —

Already we have a PFILE called initmove.ora which was created previously from spfile

SQL> show parameter spfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /u02/app/oracle/product/11.2.0
/dbhome_1/dbs/spfiletest1.ora

As you can see the spfile is in Filesystem

SQL> create spfile='+DATAC1/test/spfiletest.ora' from pfile='/u03/rman/initmove.ora';

File created.

SQL> exit

Create a pfile called inittest.ora and add only below line only in it ( format is init<sid>.ora )

spfile='+DATAC1/test/spfiletest.ora'

SQL> shutdown immediate;

Now Startup database with this pfile and automatically it will point to the SPFILE which we created in the first step

SQL> startup nomount pfile='/u03/rman/inittest.ora';

SQL> show parameter spfile;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATAC1/eccdr/spfiletest.ora
SQL> exit

As you see now the SPFILE is in ASM disk group. Modify the database with SRVCTL incase you didnt add, add like below

srvctl modify database -d test-p +DATAC1/eccdr/spfiletest.ora