Category Archives: Oracle

In this we are handling Oracle Database Administration and development task. If provide solution of ORA Errors and configuration Steps for setup in Oracle.

ORA-16532: Oracle Data Guard broker configuration does not exist

Leave a reply

Introduction

While configuring Oracle Data Guard Broker, one common error is:

ORA-16532: Oracle Data Guard broker configuration does not exist

Cause

This happens when you try to run:

ADD DATABASE STANDBY ...

👉 Without creating Broker configuration first

Solution

Step 1: Create Configuration

CREATE CONFIGURATION dg_config
AS PRIMARY DATABASE IS PRIMARY
CONNECT IDENTIFIER IS primary;

Step 2: Add Standby

ADD DATABASE STANDBY
AS CONNECT IDENTIFIER IS standby;

Step 3: Enable

ENABLE CONFIGURATION;