DGMGRL> enable configuration; fails with Error: ORA-16721, ORA-16607 (Doc ID 1321405.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.5 [Release 10.1 to 10.2]
Information in this document applies to any platform.

Symptoms

Physical standby database 10g

Archive logs are transferred and applied successfully on standby.

Setting up dataguard with dgmgrl fails with:

DGMGRL> enable configuration;
Error: ORA-16721: unable to set LOG_ARCHIVE_DEST_n initialization parameters

Failed.
DGMGRL> show configuration;

Configuration
Name: dg_erights_t
Enabled: YES
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
erights - Primary database
xerights - Physical standby database

Current status for "dg_erights_t":
Warning: ORA-16607: one or more databases have failed


The drc*.logs shows fallowing errors:


DG 2011-04-15-14:45:08 0 2 0 Database Resource[IAM=PRIMARY]: SetState READ-WRITE-XPTON, phase BUILD-UP, External Cond ENABLE, Target Site Handle 0x7ff
fffff
DG 2011-04-15-14:45:08 0 2 0 Set log transport destination: SetState ONLINE, phase BUILD-UP, External Cond ENABLE
DG 2011-04-15-14:45:08 0 2 0 Executing SQL [alter system set log_archive_dest_2 = 'service="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS_LIST=(ADDRESS=(PROTOC
OL=TCP)(HOST=myhostname)(PORT=1534))(ADDRESS=(PROTOCOL=TCP)(HOST=myhostname)(PORT=1544))))(CONNECT_DATA=(SERVICE_NAME=xerights_XPT)(INSTANCE_NA
ME=xerights)(SERVER=dedicated)))"', ' LGWR ASYNC NOAFFIRM delay=0 OPTIONAL max_failure=0 max_connections=1 reopen=10 db_unique_name="xerights" register n
et_timeout=180 valid_for=(online_logfile,primary_role)']
DG 2011-04-15-14:45:08 0 2 0 SQL Execution error=604, sql=[alter system set log_archive_dest_2 = 'service="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS_LIST=(
ADDRESS=(PROTOCOL=TCP)(HOST=myhostname)(PORT=1534))(ADDRESS=(PROTOCOL=TCP)(HOST=myhostname)(PORT=1544))))(CONNECT_DATA=(SERVICE_NAME=xerights_X
PT)(INSTANCE_NAME=xerights)(SERVER=dedicated)))"', ' LGWR ASYNC NOAFFIRM delay=0 OPTIONAL max_failure=0 max_connections=1 reopen=10 db_unique_name="xerig
hts" register net_timeout=180 valid_for=(online_logfile,primary_role)']. See error stack below.
DG 2011-04-15-14:45:08 0 2 0 ORA-00604: error occurred at recursive SQL level 1
DG 2011-04-15-14:45:08 0 2 0 ORA-32021: parameter value longer than 255 characters
DG 2011-04-15-14:45:08 0 2 0 Database Resource SetState Error (16721)
DG 2011-04-15-14:45:08 0 2 742967555 DMON: Resource Guard returned error: Operation = SET_STATE status = ORA-16721
DG 2011-04-15-14:45:08 0 2 742967555 Resource: erights (0x01012000) State: READ-WRITE-XPTON
DG 2011-04-15-14:45:08 0 2 742967555 Phase: BUILDUP External Condition: ENABLE
DG 2011-04-15-14:45:08 0 2 742967555 Operation CTL_ENABLE cancelled during phase 4, error = ORA-16721
DG 2011-04-15-14:45:08 0 2 0 INSV: Reply received for message with
DG 2011-04-15-14:45:08 0 2 0 req ID 1.1.742967555, opcode CTL_ENABLE, phase BUILDUP



Changes

Dataguard-configuration with dgmgrl

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms