Status of Guest VM is stuck in Proecssing / Shutting Down in Oracle VM Manager

The issue happened when some of our Oracle VM Servers were migrated to different sub-net. Some of the guest VM were not properly shutdown and some of them abruptly powered off. 
Since there is no dependency on the IP, the only change we did was change the IP as OS level and fired it back on. Console came up nicely but status of the guests was screwed up!!


After a bit of research found out that the status is stored in back-end DB in the OVS schema and that status was causing all the issue. Following is the way to fool VM Manager by changing the status in DB.
[root@platformprofile ~]#sqlplus ovs/ovs@XE
SQL> select t.status from ovs.ovs_vm_img t where t.img_name like 'YOUR_VM_NAME';

You'll may notice the status will be like "Processing/Shutting Down/Initializing" or something similar but not changing even after you try to perform any other operation. 


SQL>select img_name, location, status,IMG_TYPE  from ovs.ovs_vm_img;
-- I am resetting the status of my two nodes as follows 
SQL> update ovs.ovs_vm_img t set t.status='Powered Off' where t.img_name like 'appsdbnode';
SQL> update ovs.ovs_vm_img t set t.status='Powered Off' where t.img_name like 'appsnode';
commit;
Sometimes it's advisable to restart the VM Manager as follows. As in my case the issue still persists
-- if you other vm's running, the following command will give you an option to shut it down
[root@platformprofile ~]# etc/init.d/ovs-agent restart
-- now when you try to you will see only your one domain running
[root@platformprofile ~]# xm list
Name                                        ID   Mem VCPUs      State   Time(s)
 Domain-0                            2  2048     2     -b----    470.8


Now when I checked the console the issue seems to have fixed. So now you can start your VM from Manager console or from command line as described in following post...
< http://handsonoracle.blogspot.in/2012/07/starting-oracle-vm-image-from-command.html >