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

Version

11.2

Cause

An ALTER SYSTEM command or an internal self-tuning mechanism requested a write to the SPFILE but the SPFILE was not modifiable.

Action

Perform an in-memory parameter update only.

scavenger
2012-01-03 10:18:57
FALSE

you got to create a pfile from the spfile, then edit the pfile, then restart the database with startup pfile='...' then create spfile from pfile, then restart again normally

More Information

The Google Search results shown above are obtained by searching for this error using a custom google search engine which is restricted to a specific list of oracle reference sites. If you know a good oracle reference/help site and think that site should be included in this search, you can contribute to this search engine here.