VMware Communities > VMTN > VMware vCenter™ > VMware vCenter™ Server > Discussions
Up to Discussions in VMware vCenter™ Server

This Question is Answered

1 "correct" answer available (10 pts) 1 "helpful" answer available (6 pts)
3 Replies Last post: Dec 22, 2008 11:02 AM by Boneless
Reply

vCenter stops gathering stats after Database migration

Dec 19, 2008 2:01 AM

Click to view Boneless's profile Novice Boneless 8 posts since
Aug 13, 2008
Hello there:

Two days ago I migrated the vCenter (2.5U3) database from a local Oracle DB (10gR2 10.2.0.4) to our new Oracle RAC with better availability. Apparently al worked smoothly. Just exporting the vCenter Schema, then importing on the new DB and changing the OBDC DSN's did it, Even more, the performance data retrieval was considerably faster so I was quite happy. But today I noticed that the performance data is not being added to the DB since the graphs are cut just on the same moment we did the migration.

Any ideas of what could be happening?

Thanks in advance
Tags: database, troubleshooting, vc, virtual_center, virtualcenter, virtualcenter_database, 2.5, sql, migrate
Reply Re: vCenter stops gathering stats after Database migration Dec 19, 2008 2:17 AM
Click to view NTurnbull's profile Expert NTurnbull 214 posts since
Feb 11, 2008
Looks like you've got a problem with the Stats_Rollup. I know this is for MSSQL but take a look at this thread, it may help. There are some scripts mentioned in the last post that could sort it

Thanks,
Neil

Reply Re: vCenter stops gathering stats after Database migration Dec 19, 2008 3:05 AM
in response to: NTurnbull
Click to view Boneless's profile Novice Boneless 8 posts since
Aug 13, 2008
Thanks... I'm gonna talk with my DBA's and try to diagnose what's happening.
Reply Re: vCenter stops gathering stats after Database migration Dec 22, 2008 11:02 AM
in response to: NTurnbull
Click to view Boneless's profile Novice Boneless 8 posts since
Aug 13, 2008
Okay... The problem was with the dabatabase jobs running the stats rollup being broken... My DBA simply fixed it by copying the SQL script for these jobs from the old database.

Thanks
Actions
Up to Discussions in VMware vCenter™ Server