Avatar of nav2567
nav2567
Flag for United States of America asked on

A lock has been detected on the database when upgrading vCenter software.

Hello,

I am upgrading my vcenter from 6 to 6.5.  The database is on an external SQL server.  

I am getting the attached error.  ODBC test between the vcenter server and database server is fine.  

I am check out this link http://iamoracleadmin.blogspot.com/2017/03/vc65-db-lock-has-been-detected-on.html but I am not sure now to identify the opened session and kill it.  

I am not sure if I should post this to the vmware team or SQL team so I am posting it on both.

Anyone who knows how to fix it please advise.  

Many thanks.
VC65-DB-Lock.png
Microsoft SQL ServerVMware

Avatar of undefined
Last Comment
nav2567

8/22/2022 - Mon
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

Why not migrate to VCSA 6.5 or even better VCSA 6.7 (don't worry about ESXi versions, 6.5 is supported).

vCenter Server for Windoze is End of Life.
nav2567

ASKER
Andrew, at this stage, we only want to upgrade from our vCenter running on a Windows VM.  Do you know how to identify the locked database session and kill it?
ASKER CERTIFIED SOLUTION
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
nav2567

ASKER
Thanks.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck