DATA GUARD BROKER SWITCHOVER FAILS WITH ORA-16665 (Doc ID 965142.1)

Last updated on FEBRUARY 14, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 16-JUL-2014*** \
** checked for relevance '23-Nov-2015' **

Symptoms

When attempting to switchover to the Standby Database the following Error occurs:

DGMGRL>
DGMGRL> switchover to 'Q2QPTL';
Performing switchover NOW, please wait...
Error: ORA-16665: timeout waiting for the result from a database

Failed.
Unable to switchover, primary database is still "Q1QPTL"


You can find the following in the Data Guard Broker Logfile (drc<SID>.log):


DG 2009-11-09-09:53:24 2001000 3 10254 DMON: ORA-16662 network timeout in contacting database Q1QPTL. Killing NSV0
...................................................
DG 2009-11-09-09:54:03 0 2 0 NSV0: 0 x 10 seconds network retry READY
DG 2009-11-09-09:54:03 0 2 0 NSV0: Connect descriptor used is: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=squ4qp21)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=squ4qp22)(PORT=1521))(LOAD_BALANCE=yes)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=Q1QPTL_DGB)(INSTANCE_NAME=Q1QPTL1)(UR=A)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180)(DELAY=5))))
.....................................................................................
DG 2009-11-09-09:55:02 0 2 0 RSM0: HEALTH CHECK ERROR: ORA-16816: incorrect database role

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