How to reset Inventory Service database for vCenter Server Appliance 6.0

Products

• VMware vCenter Server

Issue/Introduction

This article provides steps to reset the Inventory Service database in vCenter Server Appliance 6.0.

Environment

VMware vCenter Server Appliance 6.0.x

Resolution

Caution:

• Resetting the Inventory Service database is destructive. Ensure you reset the database only after resetting the Individual Data Providers in the Inventory Service.
• If you reset the Inventory Service database:
  • vCloud Director goes out of sync with vCenter Server and does not have accurate information about managed virtual machines.
  • Any Storage Profiles that you are using through the vSphere Profile-Driven Storage service are lost.
  • All object tags are deleted during a reset.
  • If the vCenter Server environment has Site Recovery Manager and you reset the Inventory Service database, you need to run a Change/Modify and Repair on Site Recovery Manager from the Windows Programs and Features to re-register Site Recovery Manager with the vCenter Server and Inventory Service.
     

To reset the Inventory Service database in vCenter Server Appliance 6.0:

 

1. Create a snapshot or backup of the vCenter Server Appliance virtual machine.
2. Open a console to the vCenter Sever Appliance and log in using root credentials.
3. Verify that the vCenter Server Appliance Inventory Service is stopped by running this command:
   
   service-control --status
   
   Note: All other services should be listed as running.
    
4. Download the 2119422_VCSA_reset-isdb6.0-bundle.zip file attached to this Knowledge Base article.
   
   Note: From 6.0 U2 onwards, the script is already located at /usr/lib/vmware-invsvc/scripts/create-db.sh.
    
5. Copy the files to the vCenter Server Appliance using SCP.
6. Extract the zip file by running this command:
   
   unzip 2119422_VCSA_reset-isdb6.0-bundle.zip
    
7. Change the permissions on the script with this command:
   
   chmod 700 invreset_kb2119422.sh
    
8. Run the script:
   
   ./invreset_kb2119422.sh
    
9. Confirm all services are running by using this command:
   
   service-control --status

Additional Information

End of General Support for vSphere 6.0

Error when uploading files to vCenter Server Appliance using WinSCP
Inventory Service fails to start in vCenter Server 6.x
如何为 vCenter Server Appliance 6.0 重置 Inventory Service 数据库