DBSPI_ORA_GRAPH metrics collected by Oracle MP were displayed as a graph in the Performance Dashboard on the OBM UI. At some point, the metric data stopped being displayed in the graph.

Environment

Operations Bridge Manager (OBM) 24.2 for Linux

Operations Agent (OA) 12.26 for Linux

OBM Management Pack for Oracle Database (Oracle MP) 24.1

Oracle Database 19c Standard Edition

Situation

DBSPI_ORA_GRAPH metrics collected by Oracle MP were displayed as a graph in the Performance Dashboard on the OBM UI. At some point, the metric data stopped being displayed in the graph.

The metric data stopped appearing in the graphs about the time it applied the hotfix for Oracle MP.

Checking the oacore database, the metric data was empty.

# LANG=C ovcodautil -ds DBSPI_ORA_GRAPH -header -o DBSPI_ORA_GRAPH -m　E045_SHRDPOOLFREEPCT -p 20
===
Empty instance list for DBSPI_ORA_GRAPH:DBSPI_ORA_GRAPH.

For more information on cause and for resolution, please read the complete knowledge article