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

【免责声明】本站内容转载自互联网，其相关言论仅代表作者个人观点绝非权威，不代表本站立场。如您发现内容存在版权问题，请提交相关链接至邮箱：bqsm@foxmail.com，我们将及时予以处理。