Return
-
Title
Oracle DBO Instance availability report not accurate -
Description
Instance availability report generated from Foglight is not accurate. For example one of the Oracle instance was down for 4 hours, but the weekly/monthly report is showing 100% availability, which is not accurate. -
Cause
The report is working as intended.
-
Resolution
The report is showing current (the last data sample within the selected time range) data including connection time and response time.The column "Availability (%)" in the report is displaying, how many of an instance/RAC components are available in percentage. For example:RAC with 2 nodes:- Node1 up
- Node2 down
The report would show the following data in the availability column:- RAC 50%
- Node1 100%
- Node2 0%
If the report is for a stand-alone Oracle instance (not a RAC) and since only the current value is considered for the report display, “Availability %” column in the Instance Availability Report would always show 100%, when the DB is up when the report is generatedWORKAROUND:As a an alternative please use the "Oracle Executive Workload Summary Report"In this report you will get the period average of the DB availability under the "Operation Statistics -> DB Availability" section.