Migrating virtual center database [oracle]

by Grzegorz Kulikowski

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:
C:\app\Administrator\product\’version’\client_1\network\admin\tnsnames.ora
and have new information like:
NAME_HERE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = NEW_HOST )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = XXXX )
)
)

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:
usevcdb=true
url=jdbc:oracle:thin:@//OLDHOSTNAME:1521/old_name
dbtype=oracle
driver=oracle.jdbc.OracleDriver

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

You may also like

1 comment

Maciej Lelusz July 23, 2012 - 6:15 pm

Clear and simple. I just finish migration using this guide. THX! L:)

Reply

Leave a Reply

Chinese (Simplified)EnglishFrenchGermanHindiPolishSpanish