Oracle ora32001,ORA-32001:write to SPFILE requested but no SPFILE is in use问题的解决

在执行该命令时出现下列错误

[email protected]>alter system set UTL_FILE_DIR=‘/home/oracle‘,‘/home/oracle/temp‘,‘/home/oracle/scripts‘ scope=spfile;

alter system set UTL_FILE_DIR=‘/home/oracle‘,‘/home/oracle/temp‘,‘/home/oracle/scripts‘ scope=spfile

*

ERROR at line 1:

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

解决：

1.查看是否有spfile

NAME                                 TYPE                             VALUE

------------------------------------ ---------------------

spfile                                   string

2.从pfile创建spfile

File created.

3.关闭数据库

[email protected]>shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

4.启动数据库

Total System Global Area  835104768 bytes

Fixed Size                  2257840 bytes