ORA-32001: write to SPFILE requested but no SPFILE is in use
原创
©著作权归作者所有:来自51CTO博客作者wx62e28ac222a20的原创作品,请联系作者获取转载授权,否则将追究法律责任
1.执行命令报错
sys@testdb 08:44:25> alter system set "_exadata_feature_on"=true scope=spfile;
alter system set "_exadata_feature_on"=true scope=spfile
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE is in use
2.查看是否有spfile
sys@testdb 08:45:13> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
3.从pfile创建spfile
sys@testdb 08:46:57> create spfile from pfile;
File created.
Elapsed: 00:00:00.02
4.关闭数据库
sys@testdb 08:47:07> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
5.启动数据库
sys@testdb 08:50:52> startup
ORACLE instance started.
Total System Global Area 3288331512 bytes
Fixed Size 8901880 bytes
Variable Size 671088640 bytes
Database Buffers 2600468480 bytes
Redo Buffers 7872512 bytes
Database mounted.
Database opened.
6.查看是否有spile
sys@testdb 16-NOV-21> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /u01/app/oracle/product/19.3.0
/db/dbs/spfiletestdb.ora
版权声明:本文为博主原创文章,未经博主允许不得转载。
oracle,linux