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

来源：恒创科技编辑：恒创科技编辑部

2023-12-06 02:50:59

1.执行命令报错

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

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

本文地址：https://www.henghost.com/jishu/8868/