Database Software

Hi Everyone,
I am working on a plug-in for Oracle Enterprise Manager 10gR2 on AIX 5.3 which provides monitoring of storage arrays and supports ASM databases in addition to the 'emrep' database. One of the metric of that plug-in is populated by the result from a korn shell script. The script directly runs on the AIX host (connected to the storage array by FC cables via HBA ports) and retrieves the mapping for -- Physical disk - Logical Disk - LUN - ASM Disk.

Now, I was able to get the mapping for Physical Disk – Logical Disk – LUN, but could not map ASM Disk. I googled a lot for any clue but did not find the answer to this specific problem.

Now, I have the list of physical disks used for ASM by the command—

lspv

hdisk0 0001c22ac8d664ca rootvg active
hdisk1 0001c22aa51f496a Oracle active
hdisk2 0001c22ac478263a scratch active
hdisk3 0001c22ac472549a Oracle active
hdisk4 0001c22ac4725d6a Oracle active
hdisk5 none None
hdisk6 none None
hdisk7 none None
hdisk8 none None
hdisk9 none None
hdisk10 none None
hdisk11 none None
hdisk12 none None
hdisk13 none None
hdisk14 none None
hdisk15 none None
hdisk16 none None

The disks hdisk5-16 are ASM disks and there are no PVID’s present.

I also have the list of ASM disks by the command—

ls –l /dev | grep oracle

crw-rw---- 1 oracle dba 22, 6 May 12 00:02 asm_rd10_1a
crw-rw---- 1 oracle dba 22, 10 Apr 21 07:27 asm_rd10_1b
crw-rw---- 1 oracle dba 22, 7 May 09 13:53 asm_rd10_1c
crw-rw---- 1 oracle dba 22, 8 May 09 13:53 asm_rd5_1a
crw-rw---- 1 oracle dba 22, 4 May 12 00:02 asm_rd5_1b
crw-rw---- 1 oracle dba 22, 9 Apr 21 07:28 asm_rd5_1c
crw-rw---- 1 oracle dba 22, 12 May 12 00:02 asm_xbb2_rd10_1a
crw-rw---- 1 oracle dba 22, 11 Apr 24 07:34 asm_xbb2_rd10_1b
crw-rw---- 1 oracle dba 22, 13 May 09 13:53 asm_xbb2_rd10_1c
crw-rw---- 1 oracle dba 22, 16 May 12 00:02 asm_xbb2_rd5_1a
crw-rw---- 1 oracle dba 22, 14 Apr 24 07:34 asm_xbb2_rd5_1b
crw-rw---- 1 oracle dba 22, 15 May 09 13:54 asm_xbb2_rd5_1c

Now I am looking for a way to map these two lists with each other, and had no luck so far.
Does oracle provide this information somewhere in the OEM installation structure or is there a command in AIX which could give some way to map the ASM disks to the physical disks?

Any help on this is greatly appreciated. Thanks in advance…


FYI: ASMLib driver is not present on the system.