Getting Frequent ORA-16665 Time Out Waiting For The Result From A Member in DG broker logs. (Doc ID 2807868.1)

To BottomTo Bottom

In this Document

  Symptoms
  Cause
  Solution

 

APPLIES TO: 

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.

SYMPTOMS

Getting below errors frequently in the DG broker logs:
 

Data Guard Broker Status Summary:
  Type Name Severity Status
  Configuration <dg_config-name> Warning ORA-16607: one or more members have failed
  Primary Database <pri_db_name> Error ORA-16665: time out waiting for the result from a member
  Physical Standby Database <sby_db_name> Success ORA-0: normal, successful completion

 
 

CAUSE

ORA-16665 indicates that broker is not able to fetch the result from it's member within the specified values which was set for "OperationTimeout". The default value is 30.
 

SOLUTION

To avoid this error, increase OperationTimeout to a higher value. Connect to primary and set the below:

DGMGRL> EDIT CONFIGURATION SET PROPERTY OperationTimeout=120;