Re: ASM DISKGROUP INFORMATION
Date: Thu, 12 Dec 2013 23:43:56 +0800
Message-ID: <e9092caf-f011-4a64-a420-61a856fd92af_at_getmailbird.com>
I suggust you using python and cx_Oracle module, it's an example here:
[oracle_at_rac1 ~]$ cat asm.py
#!/usr/bin/python
import cx_Oracle
list = ['172.16.15.223','172.16.15.224','172.16.15.225','172.16.15.226'] # All one cluster
for host in list:
dsn = '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=' + \
host + \
')(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=+ASM)(UR=A)))'
conn = cx_Oracle.connect('sys','userpasswd',dsn,mode=cx_Oracle.SYSDBA,threaded=True)
cursor = conn.cursor()
query = "select name,state,free_mb,total_mb from v$asm_diskgroup"
cursor.execute(query)
rows = cursor.fetchall()
print "View ASM Diskgroup Usage in [%s]:" % host
for row in rows:
print row[0],row[1],row[2],row[3]
[oracle_at_rac1 ~]$ ./asm.py
View ASM Diskgroup Usage in [172.16.15.223]:
DATADG MOUNTED 28477 30718
ARCHDG MOUNTED 30272 30718
View ASM Diskgroup Usage in [172.16.15.224]:
DATADG MOUNTED 28477 30718
ARCHDG MOUNTED 30272 30718
View ASM Diskgroup Usage in [172.16.15.225]:
DATADG MOUNTED 28477 30718
ARCHDG MOUNTED 30272 30718
View ASM Diskgroup Usage in [172.16.15.226]:
DATADG MOUNTED 28477 30718
ARCHDG MOUNTED 30272 30718
[oracle_at_rac1 ~]$
All the best,
LuoLee
Mobile: +86 15651803071
See me: http://luolee.me [http://luolee.me]
On 2013/12/11 17:27:53, Nagaraj S <nagaraj.chk_at_gmail.com> wrote:
Dear Gurus,
I need to get ASM disk group space usage information across 200+ servers. We need this report for capacity planning analysis. Instead of logging to each individual server is there any way to get disk group information of all servers using any method? Please advise me if we can get this information from OEM 12c? Or using emcli command is it possible?
-Naga
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 12 2013 - 16:43:56 CET