Recently I had some fun and games with what should have been a pretty routine process of upgrading a customer’s vCenter 4.1 Server to vCenter 5.0 Update 1, as it turned out it was far from straightforward.
The main background to my issue was that when performing the upgrade of the database, the progress bar did not move after twenty minutes, which indicated that there was an issue somewhere. There are various VMware KB available in relation to the symptoms I observed but none that actually provided the solution. As a general rule before proceeding with an upgrade I would recommend the following:
-Check the Database Size and reduce where you can (The customer in question had a DB of 74GB and Transaction Log of 236GB)
- Run the upgrade logged in as the Service Account used to start the vCenter Services
- Elevate the Database account to ‘sysadmin’ for the purposes of the upgrade only
Some suggested VMware KB Articles include: Database Size 1007453, Upgrade Issues 2011533, 1003960, 1025139