“SQLDeveloper.app” fails to open after upgrading to Big Sur

I recently upgraded macOS to Big Sur and now I can't open SQLDeveloper.app. I am getting this message:

SQLDeveloper.app can’t be opened because the identity of the developer cannot be confirmed

With macOS Catalina it was working perfectly.

A similar question was discussed here “SQLDeveloper.app” can’t be opened because the identity of the developer cannot be confirmed. I already followed the approach mentioned there, but that did not solve my problem.

Any pointer towards the solution would be highly appreciated.

I confirm, there is a problem with this app on Big Sur. I'm guessing it's because of some changes around java_home app in MacOS 11.

I have a workaround to start SQL Developer from a command line:

jhartman@MBP ~ % /Users/jhartman/Downloads/SQLDeveloper.app/Contents/Resources/sqldeveloper/sqldeveloper/bin/sqldeveloper

 Oracle SQL Developer
 Copyright (c) 2005, 2018, Oracle and/or its affiliates. All rights reserved.

/Users/jhartman/Downloads/SQLDeveloper.app/Contents/Resources/sqldeveloper/sqldeveloper/bin/../../ide/bin/launcher.sh: line 885: /usr/lib/exec/java_home: No such file or directory

(despite the error, SQL Devel starts)

Tested on sqldeveloper-19.2.1.247.2212-macosx.app.zip, update the command above with location of your SQLDeveloper.

If you have time, worth to raise an SR on http://support.oracle.com/

• Launch terminal app

• Run the following command to list your Java Versions:

  /usr/libexec/java_home -V
  

• From the output, the one that is causing the issue is:

"Oracle Corporation" - "Java" /Library/Internet Plug-Ins/JavaAppletPlugin.plugin/Contents/Home"

You'll need to remove this by typing in the following command:

 sudo rm -rf "/Library/Internet Plug-Ins/JavaAppletPlugin.plugin/"

• Verify the currently set java_home path and update it as per sqldeveloper version you have installed

  sudo vi $HOME/.sqldeveloper/20.4.0/product.conf
  

• Add following entry if its not already added (you may need to change as per version)

  SetJavaHome /Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home

Working fine for me with sql developer 20.4 on Mac OS Big Sur