Hello,
running the upgrade from the v. 4.0 to 4.1 I'm getting the error
"Error occured while retrieving database version".
With the oldest version we used oracle 10 which is now upgraded to 11.1. ODBC connection exist and the older version is running.
What could be the reason?
Thanks.
Is your dsn using Oracle 11gR2 client driver?
There is a bug in Oracle 11g R2 client.
Please try below workaround if it works for you.
1. Install Oracle 11g R1 32bit and 64bit client on your system.
2. Configure both 32bit and 64bit dsn's point to your legacy VC db.
3. launch VC server installer, proceed with wizard and start upgrade process.
vCenter 4.1 requires 64bit ODBC.
---
MCSA, MCTS Hyper-V, VCP 3/4, VMware vExpert
I know, 64bit ODBC is already installed and configured.
I found out that during the installation when I have to select an ODBC data source I can select only 32bit ODBC. Connection is OK and it continues with the installation, starts the database upgrade and then comes the error.
How can I proceed with the upgrade?
I have the same problem 😕
Can you please share the VCDatabaseUpgrade.log files from %temp%?
010-08-18 16:29:25] Info: Beginning upgrade process....
Info: vcenter has been detected as an Oracle server.
Error in InitVersion(): Got exception: Arithmetic operation resulted in an overflow.
Error in GetDataseSpace(): Got exception: ERROR [ODBC][Ora]ORA-00942: tabela lub perspektywa nie istnieje
Info: Beginning upgrade process....
Info: vcenter has been detected as an Oracle server.
Error in InitVersion(): Got exception: Arithmetic operation resulted in an overflow.
Error in GetDataseSpace(): Got exception: ERROR [ODBC][Ora]ORA-00942: tabela lub perspektywa nie istnieje
Info: Beginning upgrade process....
Info: vcenter has been detected as an Oracle server.
Error in InitVersion(): Got exception: Arithmetic operation resulted in an overflow.
Error in GetDataseSpace(): Got exception: ERROR [ODBC][Ora]ORA-00942: tabela lub perspektywa nie istnieje
Is your dsn using Oracle 11gR2 client driver?
There is a bug in Oracle 11g R2 client.
Please try below workaround if it works for you.
1. Install Oracle 11g R1 32bit and 64bit client on your system.
2. Configure both 32bit and 64bit dsn's point to your legacy VC db.
3. launch VC server installer, proceed with wizard and start upgrade process.
OK it works, it is enough to install only
Oracle 11g R1 64bit
If you find this information useful, please award points for "correct" or "helpful".
That worked for me as well.
Thanks a lot.
Hi,
we want to upgrade from vSphere Server 4.0 to 4.1 with an Oracle 11G database and 11gR2 Client for Windows Server 2008r2. At the installation process we get an "error occurred while retrieving database version". The problem is now that we can´t go back to the 11gR1 oracle client because it doesn´t have support für Windows Server 2008 R2.
What can we do to get things working? Any Ideas? 😕
You can just tell it to ignore the OS failure. I just got past that step doing the same, now I'll change it to the 10.2.0.5 or 11r2 after the install is succesful.
alphamail wrote:
You can just tell it to ignore the OS failure. I just got past that step doing the same, now I'll change it to the 10.2.0.5 or 11r2 after the install is succesful.
I have the same problem while installing VCenter on a freshly installed server. I have the required Oracle 64bit client, but experience the same error as described
Now, I've tried what you suggested but the installer does not have speech recognition included so it still gives the error. Can you please tell us the actual procedure (commands, etc) you used to accomplish that?
Wow, you must be using dinosaur systems if they don't accept voice commands :smileyplain:
Anyway, if you type "runInstaller -help" you can see all of the options for the installer, the specific option you want is;
-ignoreSysPrereqs
For ignoring the results of the system pre-requisite checks.
I've tried that, but the installer does not recognize "ignoreSysPrereqs" as an option. I think this option is for Oracle installers because I could only find references to Oracle in a Google search.
Is there a similar command for the VMware vCenter Server installer? Its executable is VMware-vcserver.exe, which in turn calls VMware vCenter Server.msi in the same folder.
Oh I see your confusion, yes this whole discussion is about the Oracle ODBC driver not allowing the upgrade to occur. I can see how the title could be misleading but, I didn't create the thread just contributed. If you read through the thread it is all about getting around errors upgrading [while using an Oracle database].
I would say if you can't find a thread that addresses your issue, whatever that may be, then create a new thread and maybe somebody can help you.
Worked for me too, thanks!