Developers Guide

Flex ASM client query
17 Dell EMC SC Series Storage with Oracle ASM | CML1111
The following is sample output of the prior query:
Alloc ASM
Grp Inst DB Clu Unit Redun- Total Offline Voting
Num Nm Name Nm Status Sz State dancy MB Disks Files
--- -------- -------- ------------ --------- ---------- ------- ------ -------- ------- -------
1 +ASM1 +ASM rac-cluster CONNECTED 1,048,576 MOUNTED EXTERN 15,358 0 Y
1 -MGMTDB _mgmtdb rac-cluster CONNECTED 1,048,576 MOUNTED EXTERN 15,358 0 Y
2 +ASM1 +ASM rac-cluster CONNECTED 1,048,576 MOUNTED EXTERN 511,993 0 N
2 prd1 prd rac-cluster CONNECTED 1,048,576 MOUNTED EXTERN 511,993 0 N
2 prd2 prd rac-cluster CONNECTED 1,048,576 MOUNTED EXTERN 511,993 0 N
3 prd1 prd rac-cluster CONNECTED 1,048,576 MOUNTED EXTERN 511,993 0 N
3 prd2 prd rac-cluster CONNECTED 1,048,576 MOUNTED EXTERN 511,993 0 N
7 rows selected.
The output shows that instance +ASM1 is servicing three database instances:
• -MGMTDB
• prd1
• prd2
However, a quick check for pmon processes on the server shows that database instances +ASM1 and prd1
are the only instances running on the server.
ps -ef | grep pmon | grep –v grep
grid 102713 1 0 10:36 ? 00:00:00 asm_pmon_+ASM1
oracle 103746 1 0 10:37 ? 00:00:00 ora_pmon_prd1
Instances prd2 and –MGMTDB are running on a different server.