How to fix the Oracle error ORA-16023: system string destination cannot be the same as session string destination?

In this post, you’ll learn more about the Oracle ErrorORA-16023: system string destination cannot be the same as session string destination with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error ORA-16023: system string destination cannot be the same as session string destination

An attempt to change the first specified LOG_ARCHIVE_DEST_n (n = 1…31) parameter 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 command. 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.

How to fix the Error ORA-16023: system string destination cannot be the same as session string destination ?

You can fix this error in Oracle by following the below steps

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