VMware Cloud Community
Prokurator
Enthusiast
Enthusiast
Jump to solution

Can't upgrade vCenter Server

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.

Reply
0 Kudos
1 Solution

Accepted Solutions
RAMESA
VMware Employee
VMware Employee
Jump to solution

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.

Regards, Ramesh

View solution in original post

Reply
0 Kudos
16 Replies
AntonVZhbankov
Immortal
Immortal
Jump to solution

vCenter 4.1 requires 64bit ODBC.


---

MCSA, MCTS Hyper-V, VCP 3/4, VMware vExpert

http://blog.vadmin.ru

EMCCAe, HPE ASE, MCITP: SA+VA, VCP 3/4/5, VMware vExpert XO (14 stars)
VMUG Russia Leader
http://t.me/beerpanda
Reply
0 Kudos
Prokurator
Enthusiast
Enthusiast
Jump to solution

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?

Reply
0 Kudos
zadziorrr1
Contributor
Contributor
Jump to solution

I have the same problem 😕

Reply
0 Kudos
RAMESA
VMware Employee
VMware Employee
Jump to solution

Can you please share the VCDatabaseUpgrade.log files from %temp%?

Regards, Ramesh
Reply
0 Kudos
zadziorrr1
Contributor
Contributor
Jump to solution

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

Initialize failed, exiting...

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

Initialize failed, exiting...

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

Initialize failed, exiting...

Reply
0 Kudos
RAMESA
VMware Employee
VMware Employee
Jump to solution

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.

Regards, Ramesh
Reply
0 Kudos
zadziorrr1
Contributor
Contributor
Jump to solution

OK it works, it is enough to install only

Oracle 11g R1 64bit

Reply
0 Kudos
RAMESA
VMware Employee
VMware Employee
Jump to solution

If you find this information useful, please award points for "correct" or "helpful".

Regards, Ramesh
Reply
0 Kudos
Prokurator
Enthusiast
Enthusiast
Jump to solution

That worked for me as well.

Thanks a lot.

Reply
0 Kudos
flohaake
Contributor
Contributor
Jump to solution

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? 😕

Reply
0 Kudos
MK22
Contributor
Contributor
Jump to solution

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.

VCP
Reply
0 Kudos
hrtn
Enthusiast
Enthusiast
Jump to solution

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?

Reply
0 Kudos
MK22
Contributor
Contributor
Jump to solution

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.

VCP
Reply
0 Kudos
hrtn
Enthusiast
Enthusiast
Jump to solution

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.

Reply
0 Kudos
MK22
Contributor
Contributor
Jump to solution

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.

VCP
Reply
0 Kudos
sugadada
Contributor
Contributor
Jump to solution

Worked for me too, thanks!

mikeh@phdvirtual.com
Reply
0 Kudos