Data guard Switchover Via Broker Fails With ORA-12523/ORA-12518 (Doc ID 2150384.1)

Last updated on DECEMBER 08, 2016

Applies to:

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

Symptoms

 Setup is:
2 node RAC
Oracle Data guard replication using physical standby DB
Primary DBs: primary201 and primary202
Standby DBs: standby201 and standby202
Real-time apply, no ssh tunneling used.
Static Listeners are used for DB connections.

Switch over via Broker was called on standby201 and failed due to any one of the reason,

SYMPTOM -I

 

Changes

 UR=A is used for connection to a database which is not mounted.

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