Error: ORA-16541: database is not enabled

ORA-16541: database is not enabled


DGMGRL> disable configuration;
Disabled.
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

The configuration was already broken and therefore you need to recreate the configuration

Solution:-
Remove the configuration from partner database eg if remove configuration is failing from primary try remove configuration from standby

DGMGRL> remove configuration
Removed configuration

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 'ANDY_conf' AS PRIMARY DATABASE IS 'ANDYS1' CONNECT IDENTIFIER IS 'ANDYS1.oracle.com';
Error: ORA-16584: operation cannot be performed on a standby database

DGMGRL>  CREATE CONFIGURATION 'ANDY_conf' AS PRIMARY DATABASE IS 'ANDYS1' CONNECT IDENTIFIER IS 'ANDYS1.oracle.com';
Configuration "ANDY_conf" created with primary database "ANDYS1"
DGMGRL>
DGMGRL> ENABLE CONFIGURATION;
Enabled.

DGMGRL>  ADD DATABASE ANDYP AS CONNECT IDENTIFIER IS 'ANDYP.oracle.com' MAINTAINED AS PHYSICAL;
Database "ANDYP" added
DGMGRL> show configuration;

Configuration - ANDY_conf

  Protection Mode: MaxAvailability
  Databases:
    ANDYS1 - Primary database
    ANDYP  - Physical standby database (disabled)

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

DGMGRL>  ENABLE DATABASE ANDYP
Enabled.
DGMGRL>  show configuration;

Configuration - ANDY_conf

  Protection Mode: MaxAvailability
  Databases:
    ANDYS1 - Primary database
    ANDYP  - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

No comments:

Post a Comment