Infrastructure Software

Hi Experts,

Need to find actual block device (which are mapped to ASM Disk)

SQL> select dsk.group_number

  2        ,dsk.disk_number

  3        ,dsk.name         as disk_name

  4        ,dsk.path

  5        ,dskg.name        as disk_group_name

  6    from v$asm_disk         dsk

  7   inner join

  8         v$asm_diskgroup    dskg

  9      on dsk.group_number = dskg.group_number

10   where 1 = 1

11     and dskg.name = 'DATAOEM'

12   order by dsk.disk_number  asc

13           ,dsk.group_number asc;

GROUP_NUMBER DISK_NUMBER DISK_NAME                      PATH

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

DISK_GROUP_NAME

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

           9           0 DATAOEM_0000                   /dev/oracleasm/disks/DATAOEM1

DATAOEM

           9           1 DATAOEM_0001                   /dev/oracleasm/disks/DATAOEM2

DATAOEM

How do I get physical path location of this path ?

ls -l /dev/oracleasm/disks/DATAOEM2

brw-rw---- 1 grid asmadmin 253, 34 Oct 11 01:17 /dev/oracleasm/disks/DATAOEM2

$ ls -l /dev/oracleasm/disks/FRAOEM

brw-rw---- 1 grid asmadmin 253, 37 Oct 11 01:21 /dev/oracleasm/disks/FRAOEM

Version :  12.2 on RHEL 7.5

$ cat /etc/redhat-release

Red Hat Enterprise Linux Server release 7.5 (Maipo)

Thanks in advance