Search This Blog

Total Pageviews

Wednesday, 23 January 2019

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

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


ORA-32017: failure in updating SPFILE
ORA-16179 While Changing The Archive Destination
ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE



ALTER SYSTEM SET log_archive_dest_1='/tmp'
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE

correct syntax
ALTER SYSTEM SET log_archive_dest_1='LOCATION=/tmp' scope=memory;   ----- use location

Oracle DBA

anuj blog Archive