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

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 Note 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

 

CAUSE

Passwordfile issue.

SOLUTION

1. Check the service_name defined for Logical Standby Database connect string on the Primary tnsnames.ora is same.If not modify the connect string.

 

2. Copy the passwordfile from primary and rename according to standby SID.

 

3. Now check Show configuration.

4.如果还是不行，则重新启动备库到mount。