Oracle DBA, How To, Error, Cause and Action

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

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 (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.



Action:


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

No comments:

Post a Comment

Thanks for your comment.