While working on database activities, we come across different
error, below one of the errors reported while updating parameter
LOG_ARCHIVE_DEST_1 in oracle database.
SQL>
alter system set log_archive_dest_1='C:\Downloads\arch' scope=both;
alter
system set log_archive_dest_1='C:\Downloads\arch' scope=both
*
ERROR
at line 1:
ORA-02097:
parameter cannot be modified because specified value is invalid
ORA-16024:
parameter LOG_ARCHIVE_DEST_1 cannot be parsed
This is
purely due to syntax error, as LOCATION keyword is required before path, so
correct syntax will be as below
alter
system set log_archive_dest_1='location=C:\Downloads\arch\';
so I was
able to update parameter without any issue
SQL> alter system set
log_archive_dest_1='location=C:\Downloads\arch\';
System altered.
Also read: Statspack installation check
Also read : switching between archive log and noarchivelog
0 comments:
Post a Comment