My Oracle Support Banner

ORA-16664 and ORA-12154 In Data Guard Broker Configuration (Doc ID 2350765.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 12.2.0.1 [Release 10.2 to 12.2]
Information in this document applies to any platform.

Symptoms

3 node Primary RAC Database with single instance standby. Standby is in sync with primary & all archive logs are shipping & applying fine but DG broker configuration is showing ORA-16664 in show configuration.

Testing tnsnames.ora connect identifiers works fine. 

On Primary :

DGMGRL> show configuration

Configuration - DRFororcl02

 Protection Mode: MaxPerformance
 Members:
 orcl02 - Primary database
  orcl02_1 - Physical standby database
  Error: ORA-16664: unable to receive the result from a database

Fast-Start Failover: DISABLED

Configuration Status:
ERROR (status updated 48 seconds ago)

On Standby:

DGMGRL> show configuration

Configuration - DRFororcl02

 Protection Mode: MaxPerformance
 Members:
 orcl02 - Primary database
  Error: ORA-12154: TNS:could not resolve the connect identifier specified

  orcl02_1 - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
ERROR (status updated 0 seconds ago)

Changes

 None

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.