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?????????????????????? ? 2.从pfile创建spfile sql> create?spfile?from?pfile; File?created. 3.关闭数据库 sql> shutdown immediate; sql> startup 5.查看是否有spfile文件 sql> show?parameter?spfile; NAME?????????????????????????????????TYPE????????????????????VALUE sql> ALTER SYSTEM SET processes?= 300 scope = spfile (编辑:ASP站长网) |