Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added
Cause:
While configure of broker, get an error after creating configuration file for broker due to settings of log_archive_dest_n parameter on both primary and standby database. This is due to service name specified in the log_archive_dest_n parameter
DGMGRL> create configuration dgb AS primary database IS dbx00 CONNECT IDENTIFIER IS dbx00;
Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added
Workaround:
Take a backup of exisiting configuration for LOG_ARCHIVE_DEST_2 parameter in a spool file
kish@PRIM>show parameter LOG_ARCHIVE_DEST_2
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string service=dbx01 async valid_for=
(online_logfiles,primary_role)
db_unique_name=dbx01
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string
log_archive_dest_27 string
log_archive_dest_28 string
log_archive_dest_29 string
kish@PRIM>spool off
kish@PRIM>!vi log_archive_dest
kish@PRIM>!cat log_archive_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string service=dbx01 async valid_for=
(online_logfiles,primary_role)
db_unique_name=dbx01
kish@PRIM>
kish@PRIM>alter system set log_archive_dest_2='';
System altered.
Create the configuration file
kish@PRIM>!dgmgrl
DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production
Copyright (c) 2000, 2013, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/password
Connected as SYSDG.
DGMGRL> create configuration dgb AS primary database IS dbx00 CONNECT IDENTIFIER IS dbx00;
Configuration "dgb" created with primary database "dbx00"