ORA-32001: write to SPFILE requested but no SPFILE specified at startup

Hi,

Sometimes You can get “ORA-29760: instance_number parameter not specified ” error.

Details of error are as follows.

ORA-32001: write to SPFILE requested but no SPFILE specified at startup

ALTER SYSTEM SET processes = 1000 SCOPE=SPFILE;

ALTER SYSTEM SET processes = 1000 SCOPE=SPFILE
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE is in use

Firstly create a spfile from pfile or memory as follows.

SQL> create spfile from pfile;

SQL> create spfile from memory;

Then Restart database, normally database will startup via spfile if it exists.

SQL> shutdown immediate;
SQL> startup

Now try again.

SQL> ALTER SYSTEM SET processes = 1000 SCOPE=SPFILE;
System altered.

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/