SET LINESIZE 150 COL name FORMAT a15 COL compatibility FORMAT a12 COL database_compatibility FORMAT a12 SELECT group_number, name, state, type, total_mb, free_mb FROM v$asm_diskgroup; Use code with caution.
Are you seeing any for your users?
: CRS (Cluster Ready Services) resources moving to an INTERMEDIATE or OFFLINE state due to storage latency or connectivity issues. Immediate Diagnostic Actions asm health checker found 1 new failures
Verify if any groups show a state of DISMOUNTED . Next, query individual disk headers: SET LINESIZE 150 COL name FORMAT a15 COL
The Health Checker warning is an aggregate flag. To find the specific culprit, inspect the ASM alert log located under your Oracle Diagnostic Destination: Immediate Diagnostic Actions Verify if any groups show
If you want to isolate the exact cause of your alert, please tell me:
If your monitoring dashboard flags this error, follow these structured steps to isolate and fix the root problem: