1 Reply Latest reply on Jan 23, 2017 9:19 AM by kd.chetan

    ASM Template 'Unable to convert query result'

    kd.chetan

      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

      ELSE 6

      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  ;

       

      MountStatus MOUNT_S

      ----------- -------

                1
      CACHED

                1
      CACHED

                1
      CACHED

                1
      CACHED