<<Back to Oracle DataGuard Main Page
Error: ORA-16883: unable to translate DGConnectIdentifier property
DGMGRL> show configuration;Configuration - dg_tst1t
Protection Mode: MaxPerformance
Members:
tst1tp - Primary database
Error: ORA-16778: redo transport error for one or more members
tst1ts - Physical standby database
Error: ORA-16883: unable to translate DGConnectIdentifier property
DGMGRL> show database tst1ts
Database - tst1ts
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: (unknown)
Apply Lag: (unknown)
Average Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
TST1T
Database Status:
DGM-17016: failed to retrieve status for database "tst1ts"
ORA-16883: unable to translate DGConnectIdentifier property
ORA-16625: cannot reach member "tst1ts"
DGMGRL> show database tst1ts DGConnectIdentifier
DGConnectIdentifier = 'tst1ts'
DGMGRL> show database tst1tp DGConnectIdentifier
DGConnectIdentifier = 'tst1tp'
Cause:
Dataguard Broker is not able to identify the DGConnectIdentifier.
Solution:
To resolve the issue check and fix following.
1> check that the tnsentries are present in both primary and standby database server and are correct
2> Perform tnsping from both primary and standby
$tnsping tst1ts
$tnsping tst1tp
3> Check if local_listener is configured and if yes its entry in tnsnames.ora exists and is configured correctly
4> Verify on both primary and standby that the listener is listening for the service configured in tnsnames.ora
5> If the above is correct just disable and enable the configuration.
Comments
Post a Comment