If your Dataguard Performance tab is not showing the graphs in Oracle Enterprise Manager 13C, but your screen look like this:
Then this might be solved by running the ‘Verify Dataguard Configuration’ which will fix a mismatch between the OEM and the actual broker configuration. I have found a post on the site of ItConquer for Oracle Enterprise Manager 12C. The same steps can also be used to solve the issue in OEM 13C.
Open the Data Guard Performance tab if you are in the database pane:
Be sure to logon as user SYS (otherwise the changes needed in the OEM will not be recorded !):
Your performance tabs will not show any graphics and an alert message is shown that the charts can not be created.
Now it is time to start the ‘Verify Dataguard Configuration’, which can be found in the menu Availability:
The utility will start and will show you some checks that will be performed:
As soons as the checks are completed, and detaild results pane will some warning messages related to mismatches between OEM and Broker, these mismatches will be fixed within the OEM:
Detailed Results:
|
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 |
Initializing Connected to instance XXXXXX:XXXXXX Starting alert log monitor... Updating Data Guard link on database homepage... WARNING: Broker name (XXXXXX) and target name (YYYYYY) do not match. WARNING: The broker name will be renamed to match the target name. WARNING: Broker name (XXXXXX) and target name (YYYYYY) do not match. WARNING: The broker name will be renamed to match the target name. Verifying configuration of static services for fast-start failover...WARNING: Unable to verify fast-start failover static services. Refer to the management server log files for details.Unable to verify fast-start failover static services. Refer to the management server log files for details. OK Data Protection Settings: Protection mode : Maximum Availability Redo Transport Mode settings: XXXXXX: SYNC XXXXXX: SYNC Checking standby redo log files.....not checked due to broker name mismatch. Run verify again. Checking Data Guard status XXXXXX : Normal XXXXXX : Normal Checking inconsistent properties Checking agent status WARNING: Default preferred credentials are not set. WARNING: Switchover or failover may not succeed as a result. WARNING: Default preferred credentials are not set. WARNING: Switchover or failover may not succeed as a result. Processing completed. |
Afterwards the Data Guard Performance should show the graphs correctly now:
