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

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

（编辑：晋中站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!