ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added

Error:   While registering Primary and Standby with Data Guard Broker:

DGMGRL> CREATE CONFIGURATION ‘my_dg_conf’ AS PRIMARY DATABASE IS ‘SOAPROD’ CONNECT IDENTIFIER IS ‘SOAPROD’;

Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added

Failed.

Solution:  Update LOG_ARCHIVE_DEST_2 with no value and try creating data guard configuration.

SQL> show parameter LOG_ARCHIVE_DEST_2

NAME                                 TYPE        VALUE

———————————— ———– ——————————

log_archive_dest_2                   string      SERVICE=SOAPROD SYNC NOAFF

                                                 IRM VALID_FOR=(ONLINE_LOGFILES

                                                 ,PRIMARY_ROLE) DB_UNIQUE_NAME=

                                                 SOAPROD

SQL> alter system set LOG_ARCHIVE_DEST_2=” scope=both;

System altered.

DGMGRL> connect sys

Password:

Connected as SYSDG.

DGMGRL> CREATE CONFIGURATION ‘my_dg_conf’ AS PRIMARY DATABASE IS ‘SOAPROD’ CONNECT IDENTIFIER IS ‘SOAPROD’;

Configuration ‘my_dg_conf’ created with primary database “SOAPROD”

Note:  Please do the same changes on Standby side as well.

Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."

Latest posts by Nagulu Polagani (see all)