Wednesday, November 5, 2008

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

SQL> alter system set log_archive_dest_2='/oradata1/terminus_archive' scope=both;
alter system set log_archive_dest_2='/oradata1/terminus_archive' scope=both
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_2" not allowed with SPFILE

Cause: Incremental changes to a log_archive_dest_n parameter cannot be made when using an SPFILE.
Action: Specify either LOCATION or SERVICE plus all other attributes to be set in one ALTER SYSTEM/SESSION SET command.

SQL> alter system set log_archive_dest_2='location=/oradata1/terminus_archive' scope=both;

System altered.

No comments:

search engine

Custom Search