oracle报错：

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

解决方法：

1.查看是否有spfile

sql> show parameter spfile;

NAME                                 TYPE                             VALUE                      

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

spfile                                   string

 

2.从pfile创建spfile

sql> create spfile from pfile;

File created.

3.关闭数据库

sql> shutdown immediate;

4.启动数据库

sql> startup

5.查看是否有spfile文件

sql> show parameter spfile;

NAME                                 TYPE                    VALUE

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

spfile                               string                 01/app/oracle/product/11.2.0/db_1/dbs/spfilePROD.ora

6.再执行该命令，问题解决

sql> ALTER SYSTEM SET processes = 300 scope = spfile