SOLVED

ORA-16541: database is not enabled

Asked by OracleDba••14 views•oracle
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
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
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
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
OracleDba•

Post Your Solution