MOVING SPFILE FOR RAC DB IN ASM

MOVING SPFILE FOR RAC DB IN ASM

$ sqlplus / as sysdba

SQL> create pfile='/home/oracle/pfile_Bhuvan1.ora' from spfile;

File created.

SQL> create spfile='+BHUVAN1' from pfile='/home/oracle/pfile_zp1.ora';

File created.

you have to find the file name details in the asmcmd
After finding the name, you have to change to the database

$ srvctl modify database -d BHU -p +BHUVAN/BHU/PARAMETERFILE/spfile.272.762954069

STOP AND START THE RAC DATASBASE

CHECK THE SPFILE LOCATION IN ALL NODES

SQL> show parameter spfile

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

spfile                               string      +BHUVAN/BHU/parameterfile

                                                 /spfile.272.762954069

Note: Remove your old spfile using rm command or ALTER DISKGROUP DISK_GROUP_NAME DROP FILE ‘OLD_LOCATION’;