- 02 Nov, 2021
- 0 Comments
- 1 Min Read
ORA-16541: database is not enabled
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