- 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
1 2 3 4 5 6 | /data/app/Oracle\dbhomeXE\bin>oerr ora 1654116541, 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 |
1 2 | DGMGRL> SHOW CONFIGURATIONORA-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
1 2 | DGMGRL> REMOVE CONFIGURATION;Error: ORA-16541: database is not enabled |
–Standby
1 2 | DGMGRL> REMOVE CONFIGURATIONRemoved configuration |
2. Create configuration again from Primary side:
1 2 | 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.
1 2 | DGMGRL> ENABLE CONFIGURATION;Enabled.. |
4. Add standby database service in DG BRoker configuration.
1 2 | DGMGRL> ADD DATABASE ORCL_STBY AS CONNECT IDENTIFIER IS ‘ORCL2.oracle.com’ MAINTAINED AS PHYSICAL;Database “ORCL_STBY” added. |
5. Enable standby service
1 2 | DGMGRL> ENABLE DATABASE ORCL_STBYEnabled. |
6. Verified configuraitons:
1 2 3 4 5 6 7 8 9 10 11 12 13 | DGMGRL> show configuration;Configuration – ORCL_DGCONFProtection Mode: MaxAvailabilityDatabases:ORCL – Primary databaseORCL_STBY – Physical standby databaseFast-Start Failover: DISABLEDConfiguration Status:SUCCESS |