The following is the ORA-16023 error message, you can learn the cause and solution of the Oracle database error.


ORA-16023 system string destination cannot be the same as session string destination

Cause: An attempt to change the first specified LOG_ARCHIVE_DEST_n parameter (n = 1, 2, … 10) produced a destination that duplicates the session destination value of the second specified LOG_ARCHIVE_DEST_n parameter. This error can occur when setting a non-NULL value with the ALTER SYSTEM statement. Or, this error can occur when setting a NULL value with ALTER SESSION command, because then the associated system destination value may appear as a duplicate.

Solution: Specify a different destination value for the first specified LOG_ARCHIVE_DEST_n parameter.

Case:

Please wait for the update…