ORA-20011: Approximate NDV failed: ORA-16532: Data Guard broker configuration does not exist

ORA-20011: Approximate NDV failed: ORA-16532: Data Guard broker configuration does not exist 

Oracle DB : Release 11.2

% dgmgrl

DGMGRL> connect /

DGMGRL> show configuration

ORA-16532: Data Guard broker configuration does not exist

Solution :

Disable the DataGuard broker:

SQL> alter system set dg_broker_start=false scope=both;
SQL> > exec dbms_stats.gather_fixed_objects_stats;

PL/SQL procedure successfully completed.