Failed to get alarms or QOS data for RAC custom checkpoint

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Oracle probe custom RAC checkpoint is not reporting QOS or alarms.

Example error from oracle_monitor.log:

May 17 13:11:39:529 [2876] oracle: Profile: <profilename>/<custom_checkpoint_name>, error - column INSTANCE_NAME not found

Environment

Version: Any
Component: oracle probe

Cause

The query that was created did not specify instance_name as a column.

Resolution

Query needs to be fashioned so that instance_name is defined as a returned column.

Examples:

select g.name as GROUP_NAME,(select instance_name from V$instance) AS INSTANCE_NAME,(select count(*) from v$asm_disk d where header_status = 'MEMBER' and g.group_number = d.group_number) as DCNT from v$asm_diskgroup g

 

SELECT i.instance_name, a.value as db_block_gets,

    b.value as consistent_gets,

    c.value as physical_reads,

    d.value as pr_direct,

    e.value as pr_direct_lob,

    f.value as pr_direct_temp_space

FROM gv$sysstat a, gv$sysstat b, gv$sysstat c, gv$sysstat d, gv$sysstat e, gv$sysstat f, gv$instance i

WHERE a.name = 'db block gets' AND b.name = 'consistent gets' AND c.name = 'physical reads' AND d.name = 'physical reads direct' 

AND e.name = 'physical reads direct (lob)' AND f.name = 'physical reads direct temporary tablespace' and i.inst_id=a.inst_id and f.inst_id=i.inst_id and b.inst_id=i.inst_id

and c.inst_id=i.inst_id and d.inst_id=i.inst_id and e.inst_id=i.inst_id

Additional Information

Queries used by the Oracle Probe