Há algum tempo surgiu a necessidade de levantar as configurações de memória, disco e processador de todas as máquinas virtuais que hospedam bancos de dados no exadata virtualizado X8M. Abaixo, apresento um script simples que criei para coletar informações:
Versão do exadata: X8M-2 Elastic Rack HC 14TB
[root@adm01vm01 ~]# cat /opt/oracle.SupportTools/onecommand/databasemachine.xml | grep -i MACHINETYPE
<MACHINETYPES>X8M-2 Elastic Rack HC 14TB</MACHINETYPES>Utilize o Oracle Exadata Deployment Assistant (OEDA) para identificar os IPS dos Database Server.
Conecte no Database Server via ssh:
Listar as máquinas virtuais:
[root@dbadm01 ~]# virsh list --all
Id Name State
------------------------------------------
1 vm02vm01.teste.com running
2 vm02vm02.teste.com running
3 vm02vm03.teste.com runningScript para a coleta de informações de cpu, memoria e discos das VMs:
#!/bin/bash
for i in $(virsh list --name)
do
echo "$i"
echo "============================================================="
virsh dominfo "$i" | grep "CPU.s"
virsh dominfo "$i" | grep "memory"
virsh domblkinfo "$i" block-device --all --human
virsh domblklist "$i" --details
doneOutput da execução do script de coleta:
vm02vm01.teste.com
=============================================================
CPU(s): 10
Max memory: 154140672 KiB
Used memory: 154140672 KiB
Target Capacity Allocation Physical
-------------------------------------------------
sda 101.300 GiB 98.293 GiB 69.136 GiB
sdb 52.000 GiB 50.001 GiB 50.000 GiB
sdc 52.000 GiB 41.775 GiB 20.173 GiB
sdd 52.000 GiB 39.482 GiB 13.256 GiB
sde 52.000 GiB 37.929 GiB 10.555 GiB
sdf 22.000 GiB 21.997 GiB 21.999 GiB
sdg 102.000 GiB 98.669 GiB 81.003 GiB
Type Device Target Source
------------------------------------------------------------------------------------------------------
file disk sda /EXAVMIMAGES/GuestImages/vm02vm01.teste.com/System.img
file disk sdb /EXAVMIMAGES/GuestImages/vm02vm01.teste.com/grid19.13.0.0.211019.img
file disk sdc /EXAVMIMAGES/GuestImages/vm02vm01.teste.com/db19.13.0.0.211019_3.img
file disk sdd /EXAVMIMAGES/GuestImages/vm02vm01.teste.com/db12.2.0.1.211019_4.img
file disk sde /EXAVMIMAGES/GuestImages/vm02vm01.teste.com/db11.2.0.4.210119_5.img
file disk sdf /EXAVMIMAGES/GuestImages/vm02vm01.teste.com/u01.img
file disk sdg /EXAVMIMAGES/GuestImages/vm02vm01.teste.com/u011.img
vm02vm02.teste.com
=============================================================
CPU(s): 30
Max memory: 104857600 KiB
Used memory: 104857600 KiB
Target Capacity Allocation Physical
-------------------------------------------------
sda 101.300 GiB 98.261 GiB 65.183 GiB
sdb 52.000 GiB 43.027 GiB 21.996 GiB
sdc 52.000 GiB 41.333 GiB 20.836 GiB
sdd 22.000 GiB 21.980 GiB 21.509 GiB
sde 102.000 GiB 98.695 GiB 49.121 GiB
Type Device Target Source
------------------------------------------------------------------------------------------------------
file disk sda /EXAVMIMAGES/GuestImages/vm02vm02.teste.com/System.img
file disk sdb /EXAVMIMAGES/GuestImages/vm02vm02.teste.com/grid19.13.0.0.211019.img
file disk sdc /EXAVMIMAGES/GuestImages/vm02vm02.teste.com/db19.13.0.0.211019_3.img
file disk sdd /EXAVMIMAGES/GuestImages/vm02vm02.teste.com/u01.img
file disk sde /EXAVMIMAGES/GuestImages/vm02vm02.teste.com/u011.img
vm02vm03.teste.com
=============================================================
CPU(s): 26
Max memory: 1154482176 KiB
Used memory: 1154482176 KiB
Target Capacity Allocation Physical
---------------------------------------------------
sda 101.300 GiB 98.301 GiB 81.352 GiB
sdb 52.000 GiB 41.875 GiB 22.680 GiB
sdc 52.000 GiB 41.333 GiB 19.920 GiB
sdd 52.000 GiB 39.269 GiB 14.197 GiB
sde 52.000 GiB 50.001 GiB 50.000 GiB
sdf 22.000 GiB 21.997 GiB 21.999 GiB
sdg 102.000 GiB 101.278 GiB 102.000 GiB
Type Device Target Source
------------------------------------------------------------------------------------------------------
file disk sda /EXAVMIMAGES/GuestImages/vm02vm03.teste.com/System.img
file disk sdb /EXAVMIMAGES/GuestImages/vm02vm03.teste.com/grid19.13.0.0.211019.img
file disk sdc /EXAVMIMAGES/GuestImages/vm02vm03.teste.com/db19.13.0.0.211019_3.img
file disk sdd /EXAVMIMAGES/GuestImages/vm02vm03.teste.com/db12.2.0.1.211019_4.img
file disk sde /EXAVMIMAGES/GuestImages/vm02vm03.teste.com/db11.2.0.4.210119_5.img
file disk sdf /EXAVMIMAGES/GuestImages/vm02vm03.teste.com/u01.img
file disk sdg /EXAVMIMAGES/GuestImages/vm02vm03.teste.com/u011.img
Espero que esta dica possa te ajuda.