How to create a custom checkpoint for Oracle probe

Document ID : KB000014959
Last Modified Date : 14/05/2018
Show Technical Document Details
Introduction:

This document would explain on how to create and configure custom (new) checkpoints using the oracle probe.

Custom checkpoints allow you to use our own preferred queries for database monitoring when the checkpoints provided do not satisfy your specific database monitoring requirements. This guide walks you through configuring and testing a custom checkpoint, configuring data collection (QoS), configuring alarms and alarm thresholds.

Question:

How to create a custom (new) checkpoint for Oracle probe for monitoring customer specific requirements using preferred queries ?

Environment:
UIM: 8.4 or later
Answer:

1. Open oracle probe GUI in Infrastructure Manager or Admin Console.

 

 

2. Go to “Templates” tab and right click on Open space and then click on “Create new” option.

                               1.jpg

3. Add the required name for checkpoint to monitor

                              2.jpg

4. Query template editor will open as below.

                             3.jpg

5. Select “Active” and “Send Quality of Service” options. You can give the Check interval and other required fields as per the requirement.

6. Go to “Query” tab.

  • Select the connection.
  • Add the query.
  • Add the “Checked value” and “Condition”
  • Give any query file name.

                            4.jpg

7. You can add the thresholds as per the requirement and values in the “Thesholds/Schedules” section.

                            5.jpg

                            6.jpg

8. Checkpoints gets added to the oracle probe.

 

9. Click on Apply and OK and then restart the probe.

 

 

Additional Information:

Reference: 

https://docops.ca.com/ca-unified-infrastructure-management-probes/ga/en/alphabetical-probe-articles/oracle-oracle-database-monitoring/oracle-im-configuration#oracleIMConfiguration-(Optional)CreateCustomCheckpoints

How to change the threshold for specific checkpoint in a oracle probe 

http://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.tec1941587.html