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

1.执行命令报错

https://www.cndba.cn/hbhe0316/article/22184

https://www.cndba.cn/hbhe0316/article/22184

https://www.cndba.cn/hbhe0316/article/22184

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

https://www.cndba.cn/hbhe0316/article/22184

https://www.cndba.cn/hbhe0316/article/22184

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.启动数据库https://www.cndba.cn/hbhe0316/article/22184https://www.cndba.cn/hbhe0316/article/22184https://www.cndba.cn/hbhe0316/article/22184https://www.cndba.cn/hbhe0316/article/22184

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.查看是否有spilehttps://www.cndba.cn/hbhe0316/article/22184

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