Link to home
Create AccountLog in
Avatar of nav2567
nav2567Flag 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
Avatar of Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
Flag of United Kingdom of Great Britain and Northern Ireland image

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.
Avatar of 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
Avatar of Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of nav2567

ASKER

Thanks.