Oracle Probe 5.45 error: "ORA-00923: FROM keyword not found where expected"

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)
• Unified Infrastructure Management for Mainframe
• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

On a validated host system, you installed Oracle Probe 5.45. Without changing anything, there are ORA Errors in the probe log files:

oracle: Profile: C_demo_01_ora###1/buf_cachehit_ratio, RunQuery - query 1 starting
oracle: doQuery4 qeury text SELECT a.value as db_block_gets_from_cache,b.value as consistent_gets_from_cache,c.value as physical_reads_from_cacheFROM v$sysstat a, v$sysstat 
b, v$sysstat cWHERE a.name = 'db block gets from cache'AND b.name = 'consistent gets from cache' AND c.name = 'physical reads cache'
oracle: Profile: C_demo_01_oralcdb1, Oracle error! Status: -1, - ORA-00923: FROM keyword not found where expected

This is a probe built-in check named "buf_cachehit_ratio". Is there any hotfix for this?

Environment

• Release: DX UIM 23.4
• Component: UIM - ORACLE
• oracle probe v5.45

Cause

• buf_cachehit_ratio checkpoint syntax

Resolution

oracle-5.45-T3.zip contains the fix for this sql statement syntax issue and it is attached to this KB Article.