Repost from my Q&A post on the VS marketplace
Both of my work devices get stuck on "Activating Oracle SQL Developer Extension for VSCode" after installing the extension. My personal devices do not do this.
Investigation of the extension log file shows that dbtools.bat is blocked from running by group policy.
[dbtools.bat(29824)] [WARN ] #stderr This program is blocked by group policy. For more information, contact your system administrator.
This can be circumvented by running VSCode as admin with --no-sandbox (to prevent it crashing when run as admin) however this is not an ideal final solution as this process needs to run each time VS Code is opened which means it cannot be run once as admin and then as a standard user thereafter, some users do not have local admin access either. You also cannot install extension updates when running VS Code as admin.
This could be a significant issue for enterprise users (of which Oracle has a huge customer base) as almost any IT security department worth their salt is going to have .bat files disabled by group policy.