个人笔记ORA-32017 ORA-16179

 SQL> alter system set log_archive_dest_1='LOCATION= /archivelog';

alter system set log_archive_dest_1='LOCATION= /archivelog'

*

ERROR at line 1:

ORA-32017: failure in updating SPFILE

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

 

 

SQL> select count(*) from v$session;

 

  COUNT(*)

----------

        16

 

SQL> alter system set log_archive_dest_1='LOCATION=/archivelog';

 

System altered.

 

SQL>