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:
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.

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s