show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ---------
spfile string +DATA/AGAP/PARAMETERFILE/spfile.272.954841567
Moving spfile
pfile='$ORACLE_HOME/dbs/initagap.ora.migratation.bck' from spfile;
create spfile='+DATA_GRUP/AGAP/PARAMETERFILE/spfileagap.ora' from pfile='$ORACLE_HOME/dbs/initagap.ora.migratation.bck';
shutdown immediate;
you have to update location of spfile in init in any nodes that you have for crscd $ORACLE_HOME/dbs
more initagap.ora
SPFILE='+DATA/agap/spfileagap.ora'
vi initagap.ora
more initagap.ora
SPFILE='+DATA_GRUP/agap/spfileagap.ora'
sqlplus / as sysdba
startup
to check the new location
show parameter spfile
NAME TYPE VALUE
------------------------------- ----------- -------------------
spfile string +DATA_GRUP/AGAP/PARAMETERFILE/spfileagap.ora
to update within CRS
checking configuration of database
srvctl config database -d agap
modifying configuration of database
srvctl modify database -d agap -p '+DATA_GRUP/AGAP/PARAMETERFILE/spfileagap.ora'
