Using SiteScope for +ASM diskgroup monitoring

  • KM03294936
  • 29-Nov-2018
  • 23-Sep-2019

Summary

Using SiteScope for +ASM diskgroup monitoring

Question

How can the freespace percentage of ASM diskgroup be monitored using SiteScope?

Answer

Recommendation is to create and use a Custom Database monitor since the metrics that you need to monitor are not currently supported:
 
On the below link you’ll find the counters available for the Oracle Database Monitor and the permissions required:
Oracle Database Monitor
  https://docs.microfocus.com/itom/SiteScope:2018.05/Use/MR_Oracle_DB_Mon
 
You’ll find additional counters on the previous link.
 
Custom Database monitor information:
https://docs.microfocus.com/itom/SiteScope:2018.05/Use/MR_Custom_Database_Mon#.24filename.7C
 
Additional, seems like you’ll need permission to the below table if you’ll monitor ASM diskgroup.
V$ASM_DISK
  DB reference: https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1019.htm#REFRN30170
 
External links with additional information that you can use to determine the best implementation to monitor the ASM diskgroup:
Useful ASM scripts and queries: https://ronnyegner.wordpress.com/2009/10/07/useful-asm-scripts-and-queries/
Scripts to monitoring the Oracle ASM disks, files and volumes: https://labite.wordpress.com/2012/10/24/scripts-to-monitore-oracle-asm-disks/
How to monitor space usage on ASM diskgroups: https://dba.stackexchange.com/questions/36160/how-to-monitor-space-usage-on-asm-diskgroups