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

Mehmet Salih Deveci

5 years ago

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

Cause: An alter system command or an internal self tuning mechanism requested a write to the SPFILE but no SPFILE was used to startup the instance

Action: Create an SPFILE and re-start the instance using the SPFILE.

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/