This is going to be the shortest article ever but needs to be written. If you are running the Oracle 11gR2 client on your vCenter 4.1 Server with Windows 2008 R2, you may need a patch in order to upgrade the vCenter database during a 4.1 to 5.0 upgrade. The Oracle download site only lists 11gR2 (18.104.22.168) for the latest client. However there is a REQUIRED patch that you need for the installer to upgrade the database for vCenter Server 5.0. There is also a requirement for the database version as well listed in This VMware Knowledge base. I suggest you read it VERY closely as the Oracle versions are very specific as I learned this week they are listed in the bottom of the article.
You will know if you need this patch especially if you get errors like this in the In the VCDatabaseUpgrade.log:
Info: Beginning upgrade process.... Info: vCenter_DB has been detected as an Oracle server. Error in InitVersion(): Got exception: Arithmetic operation resulted in an overflow. Error in GetDataseSpace(): Got exception: Arithmetic operation resulted in an overflow. Initialize failed, exiting...
Simply put, the patch version required on the Client is Oracle 11g R2 22.214.171.124 64-bit with patch 5 (9966926). Again this will NOT show up on the public download site. A user with Oracle support is the only one that can obtain this. There is also an Oracle 11g R2 126.96.36.199 32-bit with patch 5 (9966925) for you’re vCenter Update Manager connection. These patches are applied manually to the Windows 2008 R2 machines running the client (188.8.131.52) for vCenter and/or Update Manager to connect to the Database by using the following instructions. These are what I captured to the best of my knowledge from the team onsite driving while I was watching the WebEx.
Steps to patch Oracle 11gR2 Client
- Download the Patch from Oracle Support
- The best option is to apply the patch in safe mode. (during windows boot press F8 and select boot with command prompt.)
- Set the ORACLE_HOME environment variable (>set ORACLE_HOME=<Oracle Home Path>
- Change directory where you downloaded the patch (cd 9966926)
- While in the patch directory run the command “c:<Oracle Client Install Directory>OPatch.bat apply”
- Make sure you see successful message in the command prompt
- Reboot the machine ( To make sure all the service restarts)
Once the Oracle Client is patched (Assuming a DBA has patched the server), you should be able to complete the installation. I hope this helps others running vCenter with Oracle from getting a headache. Other detailed instructions for patching the clients are located in the patch itself, but this was the key to a couple long days. Also be sure to following the installation/upgrade guides and check the Oracle GRANT permissions before starting that they have everything needed or you will run into issues mid database upgrade.