When connecting to dataguard broker and disabling database with ORACLE_SID set before connecting to broker, broker becomes inaccessible, which is shown below:
Login to broker via database ila:
oracle [ILA@p03] /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs : dgmgrl /
DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL> show configuration;
Configuration - ila
Protection Mode: MaxAvailability
Databases:
ILAP - Primary database
ila - Physical standby database
ilal - Logical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
Disable database ila in broker:
DGMGRL> disable database ila;
Disabled.
Now neither enabling nor showing configuration is possible any more:
DGMGRL> enable database ila;
ORA-16541: database is not enabled
Configuration details cannot be determined by DGMGRL
DGMGRL> show configuration;
ORA-16541: database is not enabled
Configuration details cannot be determined by DGMGRL
DGMGRL> exit
Solution: You have to connect to broker via a database which is enabled.