We are configuring Oracle Automatic Storage Management against on Oracle Database running with ASM.
ASM template comes with built in query, And as per Solarwind document we have to update the query with then name of Diskgroup we are having.
We were updated the query with our diskgroup name and when we run the query on our db server it was giving output properly.
whereas, when we test it on SAM, it is given 'Unable to convert query result'
We don't know what option to choose on 'convert option' given in template. we need your assistance what convert option has to be choosen to make this work.
Script we modified: from default template
SELECT CASE WHEN MOUNT_STATUS LIKE 'OPENED' THEN 0
WHEN MOUNT_STATUS LIKE 'CACHED' THEN 1
WHEN MOUNT_STATUS LIKE 'CLOSING' THEN 2
WHEN MOUNT_STATUS LIKE 'CLOSED' THEN 3
WHEN MOUNT_STATUS LIKE 'IGNORED' THEN 4
WHEN MOUNT_STATUS LIKE 'MISSING' THEN 5
END AS "MountStatus", MOUNT_STATUS
FROM V$ASM_DISKGROUP A
JOIN V$ASM_DISK B USING (GROUP_NUMBER)
WHERE A.NAME='DATA01' 2
3 4 5 6
7 8 9 10 11 ;
Hi Can anyone have the solution for this ??