Blog

ORA-16541: DATABASE IS NOT ENABLED

ORA-16541: database is not enabled Getting error in DG broker service. Its seems like their is miskate in configuration of DB Broker Service and we need to reconfigure it.

Oracle Error Details


/data/app/Oracle\dbhomeXE\bin>oerr ora 16541
16541, 00000, “member is not enabled”
// *Cause: The member specified in the command was not enabled.
// *Action: Select an enabled member and reissue the command.

Error


DGMGRL> SHOW CONFIGURATION
ORA-16541: database is not enabled

Solution

Check from the other server if its not working from one primary server then check it from Standby Server or Vice Versa.

1. Try remove configuration from primary if its not work do it from standby:

— Primary

DGMGRL> REMOVE CONFIGURATION;
Error: ORA-16541: database is not enabled

–Standby

DGMGRL> REMOVE CONFIGURATION
Removed configuration

2. Create configuration again from Primary side:

DGMGRL> CREATE CONFIGURATION ‘ORCL_DGCONF’ AS PRIMARY DATABASE IS ‘ORCL’ CONNECT IDENTIFIER IS ‘ORCL1.oracle.com’;
Configuration “ORCL_DGCONF” created with primary database “ORCL”

Advertisements

3. Check and verify configuration by enabling it.

DGMGRL> ENABLE CONFIGURATION;
Enabled..

4. Add standby database service in DG BRoker configuration.

DGMGRL> ADD DATABASE ORCL_STBY AS CONNECT IDENTIFIER IS ‘ORCL2.oracle.com’ MAINTAINED AS PHYSICAL;
Database “ORCL_STBY” added.

5. Enable standby service

DGMGRL> ENABLE DATABASE ORCL_STBY
Enabled.

6. Verified configuraitons:

DGMGRL> show configuration;

Configuration – ORCL_DGCONF

Protection Mode: MaxAvailability
Databases:
ORCL – Primary database
ORCL_STBY – Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

Follow me

Contact us for Training/ Job Support

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.