Home
  •  

Last successfull Database health check

ozsoft.sap.Monitor.Oracle.HealthCheck.LastCheck (UnitMonitor)

Days since Last successfull Database health check

Knowledge Base article:

Summary

Last successful database check

Configuration

N/A

Causes

The threshold for the number of days since the last successful database check, which includes BRCONNECT return codes of 0 (successful) or 1 (successful but with warnings), has been exceeded

Resolutions

Run brconnect -f check

Additional

N/A

External

M/A

Element properties:

Targetozsoft.sap.Oracle
Parent MonitorSystem.Health.PerformanceState
CategoryOperations
EnabledFalse
Alert GenerateTrue
Alert SeverityMatchMonitorHealth
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor Typeozsoft.sap.CCMSMetricMonitorType2
RemotableTrue
AccessibilityPublic
Alert Message
Last DB Health Check
The Last DB Health Check has taken place {2} days ago
RunAsDefault

Source Code:

<UnitMonitor ID="ozsoft.sap.Monitor.Oracle.HealthCheck.LastCheck" Accessibility="Public" Enabled="false" Target="ozsoft.sap.Oracle" ParentMonitorID="Health!System.Health.PerformanceState" Remotable="true" Priority="Normal" TypeID="ozsoft.sap.CCMSMetricMonitorType2" ConfirmDelivery="false">

  <Category>Operations</Category>

  <AlertSettings AlertMessage="ozsoft.sap.Monitor.Oracle.HealthCheck.LastCheck.AlertMessageResourceID">

    <AlertOnState>Warning</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>MatchMonitorHealth</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Data/Context/ObjectName$</AlertParameter1>

      <AlertParameter2>$Data/Context/CounterName$</AlertParameter2>

      <AlertParameter3>$Data/Context/Value$</AlertParameter3>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="Under" MonitorTypeStateID="SDKMetricUnderLowThreshold" HealthState="Success"/>

    <OperationalState ID="Between" MonitorTypeStateID="SDKMetricUnderHighOverLowThreshold" HealthState="Warning"/>

    <OperationalState ID="Over" MonitorTypeStateID="SDKMetricOverHighThreshold" HealthState="Error"/>

  </OperationalStates>

  <Configuration>

    <CounterName>Last succ. database check</CounterName>

    <ObjectName>Database health check</ObjectName>

    <Frequency>900</Frequency>

    <HighThreshold>14</HighThreshold>

    <LowThreshold>7</LowThreshold>

  </Configuration>

</UnitMonitor>