We help IT Professionals succeed at work.

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

nav2567
nav2567 asked
on
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
Comment
Watch Question

Andrew Hancock (VMware vExpert / EE Fellow)VMware and Virtualization Consultant
GOLD EXPERT
Fellow
Expert of the Year 2017

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

Author

Commented:
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?
VMware and Virtualization Consultant
GOLD EXPERT
Fellow
Expert of the Year 2017
Commented:
Are you sure you have stopped vCenter Server service ? (and all other vCenter Services)

Author

Commented:
Thanks.