Migrating virtual center database [oracle]

I was doing some checks today and was surprised that i have few services within vCenter Service Status that have Alert status. I forgot to take screenshot from it:/
They were in the “License Services” section.

When you are migrating database like i did, from 1 host to another and you have edited the:
and have new information like:

Then after checking the right TNS Service Name in Data Sources (ODBC) and starting your VC, i assumed everything is fine.
I missed one thing as it seems. The Services with alerts in vCenter Service Status, were red because i did not change 1 config file which is:
“C:\ProgramData\VMware\VMware VirtualCenter\vcdb.properties”
You will see that old db hostname is still there:

You need to replace the old hostname with the new one there. After this , restart your vpxd and check again vCenter Service Status.

One thought on “Migrating virtual center database [oracle]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s