To workaround this issue, update the vCenter Server database to reflect the correct host status.
To update the vCenter Server database to reflect the correct host status:
Note: Take a backup your vCenter Server database before implementing this workaround.
- Stop the VMware VirtualCenter Server service.
- Run this command from vCenter Server SSH session to login to vPostgres database.
/opt/vmware/vpostgres/current/bin/psql -U postgres -d VCDB
- Run this SQL statement to find the ID of the host:
select id from vpx_entity where name like '%name of host%'
- Run this SQL statement to check the power state of the host:
select power_state from vpx_host where id = <output 2 from step> </output>
If the power state is 2, vCenter Server believes that the host is in Standby mode.
- To put the host in a powered on state, run this update statement:
update vpx_host set power_state = 0 where id = <output 2 from step> </output>
- Start the VMware VirtualCenter Server service.
- Ensure the ESX/ESXi host is powered on.
- Disconnect and reconnect the ESX/ESXi host in vCenter Server if the host is not responding or disconnected.