在执行该命令时出现下列错误
SYS@PROD>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
SYS@PROD>show parameter spfile;
NAME TYPE VALUE
------------------------------------ ---------------------
spfile string
2.从pfile创建spfile
SYS@PROD>create spfile from pfile;
File created.
3.关闭数据库
SYS@PROD>shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance