DGMGRL takes default port if configuration is not set properly

(Doc ID 735758.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.
***Checked for relevance on 02-June-2014***


Symptoms

The broker log will show the destination for remote standby is using default port.

broker.log

DG 2007-02-19-08:02:40 0 2 0 Executing SQL [alter system set log_archive_dest_2 = 'service="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=myhostname)
(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=drcl_XPT)(INSTANCE_NAME=drcl)(SERVER=
dedicated)))"', ' ARCH SYNC NOAFFIRM delay=0 OPTIONAL max_failure=0 max_connections=1 reopen=300 db_unique_name="drcl" register net_timeout=180 valid_for=(online_logfile,primary_role)']

DG 2007-02-19-08:02:40 0 2 0 SQL [alter system set log_archive_dest_2 = 'service="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=myhostname)
(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=drcl_XPT)(INSTANCE_NAME=drcl)
(SERVER=dedicated)))"', ' ARCH SYNC NOAFFIRM delay=0 OPTIONAL max_failure=0 max_connections=1 reopen=300 db_unique_name="drcl" register net_timeout=180 valid_for=(online_logfile,primary_role)'] Executed successfully

DG 2007-02-19-08:10:47 0 2 614937773 DMON: Database drcl returned ORA-12154
DG 2007-02-19-08:10:47 0 2 614937773 for opcode = CTL_GET_STATUS, phase = BEGIN, req_id = 1.1.614937773
DG 2007-02-19-08:10:47 0 2 0 RSM detected log transport problem: log transport for database 'drcl' has the following error.
DG 2007-02-19-08:10:47 0 2 0 ORA-12154: TNS:could not resolve the connect identifier specified
DG 2007-02-19-08:10:47 0 2 0 RSM0: HEALTH CHECK ERROR: ORA-16737: the redo transport service for standby database "drcl" has an error
DG 2007-02-19-08:10:48 0 2 614937773 Operation CTL_GET_STATUS cancelled during phase 2, error = ORA-16778
DG 2007-02-19-08:10:48 0 2 614937773 Operation CTL_GET_STATUS cancelled during phase 2, error = ORA-16778
DG 2007-02-19-08:11:47 0 2 0 NSV1: Failed to connect to remote database drcl. Error is ORA-12154
DG 2007-02-19-08:11:47 0 2 0 NSV1: Message is dropped.

 

DGMGRL> show configuration;

Configuration
Name: DRSoln
Enabled: YES
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
orcl - Primary database
drcl - Physical standby database

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

 

Changes



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