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

C:\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"

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.