Data Guard Broker reported ORA-16664 (Doc ID 1390892.1)

Last updated on DECEMBER 27, 2016

Applies to:

Enterprise Manager for Oracle Database - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.
** checked for relevance '23-Nov-2015' **

Symptoms

To resolve ORA-16664 on Dataguard broker environment.

ORA-16664 (Description : unable to receive the result from a database) is a generic error. Check the primary/standby DRC log for subsequent error.

Example, 

 

DGMGRL prompt shows,

ORA-16664 and the corresponding logical standby DRC log shows ORA-01031.

For ORA-16664 , ORA-16792 Refer Doc ID 1228797.1 -ORA-16664 ORA-16792 Data guard Broker.

Sample Error message:

DGMGRL> show configuration;

Configuration - DG

Protection Mode: MaxPerformance
Databases:
BOSTON - Primary database
stdby - Physical standby database
logstdby - Logical standby database
Error: ORA-16664: unable to receive the result from a database

Fast-Start Failover: DISABLED

Configuration Status:
ERROR

-- ---Primary DRC log----

2012-01-02 13:46:06.850 req ID 1.1.973032160, opcode DEL_RES, phase NULL
2012-01-02 13:46:15.798 NSV2: Initialization of connection failed.
2012-01-02 13:46:15.801 NSV2: expected destination db_unique_name is chicago
2012-01-02 13:46:15.802 NSV2: database actually reached LOGSTDBY
2012-01-02 13:46:15.803 NSV2: Failed to send message to site chicago. Error code is ORA-16642.
2012-01-02 13:46:15.804 03000000 973032160 DMON: Database chicago returned ORA-16642
2012-01-02 13:46:15.805 03000000 973032160 for opcode = DEL_RES, phase = NULL, req_id = 1.1.973032160
2012-01-02 13:46:23.670 NSV2: Initialization of connection failed.
2012-01-02 13:46:23.673 NSV2: expected destination db_unique_name is chicago
2012-01-02 13:46:23.675 NSV2: database actually reached LOGSTDBY
2012-01-02 13:46:23.677 NSV2: Failed to send message to site chicago. Error code is ORA-16642.
2012-01-02 13:46:23.678 03000000 973032160 DMON: Database chicago returned ORA-16642

-------Standby DRC log ----------------

2012-01-03 13:51:24.902 Connection to database BOSTON returns ORA-01031.
2012-01-03 13:51:24.903 Please check database BOSTON is using a remote password file,
2012-01-03 13:51:24.904 its remote_login_passwordfile is set to SHARED or EXCLUSIVE,
2012-01-03 13:51:24.905 and the SYS password is the same as this database.
2012-01-03 13:51:24.905 NSV0: Failed to connect to remote database BOSTON. Error is ORA-01031
2012-01-03 13:51:24.906 NSV0: Failed to send message to site BOSTON. Error code is ORA-01031.

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