ORA-32000: write to SPFILE requested but SPFILE is not modifiable

You can see the spfile location are showing in your $ORACLE_HOME/dbs location but spfile are exist in ASM. Database by default use this location. Move the spfile from $ORACLE_HOME/dbs  to another destination.


SQL>  alter system set db_recovery_file_dest='+FRA' scope=spfile sid='*';
 alter system set db_recovery_file_dest='+FRA' scope=spfile sid='*'
*
ERROR at line 1:
ORA-32000: write to SPFILE requested but SPFILE is not modifiable
SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u01/app/oracle/product/11.2.4
                                                 /db_1/dbs/spfileracdb2.ora
SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[oracle@racn2 ~]$ mv /u01/app/oracle/product/11.2.4/db_1/dbs/spfileracdb2.ora /u01/app/oracle/product/11.2.4/db_1/dbs/bkpspfileracdb2.ora
[oracle@racn2 ~]$
[oracle@racn2 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Sat Apr 2 09:20:08 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 1653518336 bytes
Fixed Size                  2253784 bytes
Variable Size            1073744936 bytes
Database Buffers          570425344 bytes
Redo Buffers                7094272 bytes
Database mounted.
Database opened.
SQL> alter system set db_recovery_file_dest='+FRA' scope=spfile sid='*';

System altered.

SQL>