<<Back to Oracle DataGuard Main Page
ORA-16541: database is not enabled
DGMGRL> enable configuration;ORA-16541: database is not enabled
Configuration details cannot be determined by DGMGRL
DGMGRL> remove configuration;
Error: ORA-16541: database is not enabled
Failed.
DGMGRL> show configuration;
ORA-16541: database is not enabled
Configuration details cannot be determined by DGMGRL
Unable to perform any operation through broker interface
Cause
The configuration is broken and therefore you need to recreate the configuration
Solution:- Recreate the Configuration
Remove Broker Configuration
Remove the configuration from partner database eg if remove configuration is failing from primary try remove configuration from standby
DGMGRL> remove configuration
Removed configuration
Create Broker Configuration from Primary database
If you try to create the configuration from standby you will encounter below error therefore please always create the configuration from current primary
DGMGRL> CREATE CONFIGURATION 'TST1T_conf' AS PRIMARY DATABASE IS 'TST1TS' CONNECT IDENTIFIER IS 'TST1TS.oracle.com';
Error: ORA-16584: operation cannot be performed on a standby database
DGMGRL> CREATE CONFIGURATION 'TST1T_conf' AS PRIMARY DATABASE IS 'TST1TS' CONNECT IDENTIFIER IS 'TST1TS.oracle.com';
Configuration "TST1T_conf" created with primary database "TST1TS"
DGMGRL> ENABLE CONFIGURATION;
Enabled
DGMGRL> ADD DATABASE TST1TP AS CONNECT IDENTIFIER IS 'TST1TP.oracle.com' MAINTAINED AS PHYSICAL;
Database "TST1TP" added
DGMGRL> show configuration;
Configuration - TST1T_conf
Protection Mode: MaxAvailability
Databases:
TST1TS - Primary database
TST1TP - Physical standby database (disabled)
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> ENABLE DATABASE TST1TP
Enabled.
DGMGRL> show configuration;
Configuration - TST1T_conf
Protection Mode: MaxAvailability
Databases:
TST1TS - Primary database
TST1TP - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
Comments
Post a Comment