在执行该命令时出现下列错误
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 shut down.
4.启动数据库
SYS@PROD>startupORACLE instance started.
Total System Global Area 835104768 bytesFixed Size 2257840 bytesVariable Size 541068368 bytesDatabase Buffers 289406976 bytesRedo Buffers 2371584 bytesDatabase mounted.Database opened.
5.查看是否有spfile文件
SYS@PROD>show parameter spfile;
NAME TYPE VALUE------------------------------------ ----------------------spfile string 01/app/oracle/product/11.2.0/db_1/dbs/spfilePROD.ora6.再次执行该命令,问题解决
SYS@PROD>alter system set UTL_FILE_DIR='/home/oracle','/home/oracle/temp','/home/oracle/scripts' scope=spfile;
System altered.