Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

data guard broker gets ORA-16664

3231479Aug 16 2017 — edited Aug 17 2017

My password file and TNS is correctly set up as I can do these

sqlplus sys@primary as sysdba

sqlplus sys@standby as sysdba

On both primary and standby servers.

I am going from Exadata to a Linux cluster but this should not be relevant.

16:31:45 (GDXGK011)> 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.
Connected as SYSDG.
DGMGRL> show configuration

Configuration - DGConfig

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

Fast-Start Failover: DISABLED

Configuration Status:
ERROR   (status updated 1 second ago)

DGMGRL>

The dg log (drc<SID>.log)

Site GDXGKE01 returned ORA-16664.

Data Guard Broker Status Summary:

  Type                        Name                             Severity  Status

  Configuration               DGConfig                          Warning  ORA-16607

  Primary Database            GDXGK01                           Success  ORA-00000

  Physical Standby Database   GDXGKE01                            Error  ORA-16664

What should I be checking next? Or how does the broker logins to the standby if it is not using the TNS.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 14 2017
Added on Aug 16 2017
8 comments
4,327 views