My Oracle Support Banner

How To Resolve ORA-16816 at Data Guard Broker Configuration (Doc ID 2855164.1)

Last updated on APRIL 17, 2023

Applies to:

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


At an environment where the Data Guard Broker is configured, if you change the database role from SQL*Plus instead of DGMGRL or Cloud Control, the database role recognized by Data Guard Broker will be different from the actual database role.
And, show database will return ORA-16816.

This document explains how to resolve ORA-16816.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.