ORA-32001: write to SPFILE requested but no SPFILE is in use

While we make some changes to SPFILE in Oracle Instance using ALTER SYSTEM command,  it will throw error as following,

ORA-32001: write to SPFILE requested but no SPFILE is in use.

Resolution:

SQL> show parameter spfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
SQL> show parameter pfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string

 

Create SPFILE from PFILE, the filename for PFILE will be INIT<SID>.ORA

SQL> create spfile from pfile;

File created.

SQL> show parameter spfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string

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

Total System Global Area 4192272384 bytes
Fixed Size                  2182384 bytes
Variable Size            3338666768 bytes
Database Buffers          838860800 bytes
Redo Buffers               12562432 bytes
Database mounted.
Database opened.
SQL> show parameter spfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      C:\<SPFILE_LOCATION\SPFILE

                                                     <SID>.ORA

SQL> ALTER SYSTEM SET MEMORY_TARGET = 1024M SCOPE = SPFILE;

System altered.

Now, you are able to edit the SPFILE configuration using Alter Command.