SQL> alter system set log_archive_dest_1='/u02/archive_log/' scope=both;

alter system set log_archive_dest_1='/u02/archive_log/' scope=both

*

ERROR at line 1:

ORA-32017: failure in updating SPFILE

ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE

在设置log_archive_dest_1的值时，引号中有‘location=’关键字，如下

SQL> alter system set log_archive_dest_1='location=/u02/archive_log/' scope=both;

System altered

ITPub博客

ORA-16179