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"

1 Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s