<<Back to Oracle DataGuard Main Page
ORA-16541: database is not enabled
Cause
Dataguard Configuration is broken
Solution:
Re-create the broker configuration. If remove configuration is failing from primary try remove configuration from standby and vice verse.
Step1> Remove Configuration;
DGMGRL> remove configuration
Removed configuration
Step2> Create Configuration from current Primary Database
You will encounter ORA-16584 if creating from standby
At standby
DGMGRL> CREATE CONFIGURATION 'APX1P_CONF' AS PRIMARY DATABASE IS 'APX1PP' CONNECT IDENTIFIER IS 'APX1PP.oracle.com';
Error: ORA-16584: operation cannot be performed on a standby database
At Primary
DGMGRL> CREATE CONFIGURATION 'APX1P_CONF' AS PRIMARY DATABASE IS 'APX1PP' CONNECT IDENTIFIER IS 'APX1PP.oracle.com';
Configuration "APX1P_CONF" created with primary database "APX1PP"
Step3> Enable Configuration
DGMGRL> ENABLE CONFIGURATION;
Enabled.
Step4> Add Standby Database to the Configuration
DGMGRL> ADD DATABASE APX1PS AS CONNECT IDENTIFIER IS 'APX1PS.oracle.com' MAINTAINED AS PHYSICAL;
Database "APX1PS" added
Step5> Enable Standby Database
DGMGRL> ENABLE DATABASE APX1PS
Enabled.
Step6> Verify Configuration Status
DGMGRL> show configuration;
Configuration - APX1P_CONF
Protection Mode: MaxAvailability
Databases:
APX1PP - Primary database
APX1PS - Physical standby database (disabled)
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
Investigation:
Tried to see the configuration
DGMGRL> show configuration;
ORA-16541: database is not enabled
Configuration details cannot be determined by DGMGRL
Tried to re-enable Configuration
DGMGRL> disable configuration;
Disabled.
DGMGRL> enable configuration;
ORA-16541: database is not enabled
Configuration details cannot be determined by DGMGRL
Tried to Remove the Configuration from Primary
DGMGRL> remove configuration;
Error: ORA-16541: database is not enabled
Failed.
Note: If remove configuration is failing try to remove it from partner database.
Note:- If you are unable to remove configuration or get configuration status from any database its worth to restart the broker process once by just setting dg_broker_start=false and back to true again
SQL> alter system set dg_broker_start=false sid='*';
SQL> alter system set dg_broker_start=true sid='*';
Comments
Post a Comment