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

==========================

Error Details

==========================

ALTER SYSTEM SET MEMORY_MAX_TARGET=24576M scope=spfile;

ERROR at line 1:

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

==========================

Solution

==========================

SQL> show parameter pfile

NAME            VALUE

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

spfile          

Notice! - the value for spfile is not defined.

SQL> CREATE SPFILE FROM MEMORY;

spfile<inst>.ora is created under default location:

${ORACLE_HOME}/dbs/

/software/oracle/1910/dbs/spfileigt.ora

SQL> CREATE PFILE='/software/oracle/1910/dbs/pfileigt.ora' FROM SPFILE='/software/oracle/1910/dbs/spfileigt.ora'

PFILE is created:

/software/oracle/1910/dbs/pfileigt.ora

SQL> ALTER SYSTEM SET MEMORY_MAX_TARGET=24576M scope=spfile;

ALTER SYSTEM SET MEMORY_MAX_TARGET=24576M scope=spfile

*

ERROR at line 1:

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

SQL> show parameter spfile

NAME              VALUE

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

spfile

spfile is still not defined.

Need to restart oracle.

SQL> SHUTDOWN IMMEDIATE;

SQL> STARTUP;

SQL> show parameter spfile

NAME              VALUE

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

spfile            /software/oracle/1910/dbs/spfileigt.ora

SQL> ALTER SYSTEM SET MEMORY_MAX_TARGET=24576M scope=spfile;

System altered.

SQL> ALTER SYSTEM SET MEMORY_TARGET=24576M scope=spfile;

System altered.

NAME                  VALUE

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

memory_max_target     24G

memory_target         24G