SQL Developer for macOS does not seem to be properly signed

JiF Brodeur · Dec 22, 2019 12:06PM

Hi, upon downloading the SQL Developer 19.4 for macOS, when I tried to run it I received an error message saying that Apple could not verify the developer and that it would not execute. A work around is to go to setting -> Security & Privacy -> General and choose to run anyway, but a properly signed application would be appreciated.

Thanks

Jean-François

thatJeffSmith-Oracle · Dec 23, 2019 9:13AM

It's signed, and working just fine for me on Mojave

Executable=../Downloads/SQLDeveloper.app/Contents/MacOS/sqldeveloper.sh

Identifier=com.oracle.SQLDeveloper

Format=app bundle with generic

CodeDirectory v=20200 size=215 flags=0x0(none) hashes=1+3 location=embedded

Hash type=sha256 size=32

CandidateCDHash sha1=52a3a6c43e61f269cfc3d61b6d3f1e6fdc55e80a

CandidateCDHash sha256=130a819ae012595a8a749c766a7233e6faa4cad5

Hash choices=sha1,sha256

Page size=none

CDHash=130a819ae012595a8a749c766a7233e6faa4cad5

Signature size=9059

Authority=Developer ID Application: Oracle America, Inc. (VB5E2TV963)

Authority=Developer ID Certification Authority

Authority=Apple Root CA

thatJeffSmith-Oracle · Dec 23, 2019 9:13AM

It's signed, and working just fine for me on Mojave

Executable=../Downloads/SQLDeveloper.app/Contents/MacOS/sqldeveloper.sh

Identifier=com.oracle.SQLDeveloper

Format=app bundle with generic

CodeDirectory v=20200 size=215 flags=0x0(none) hashes=1+3 location=embedded

Hash type=sha256 size=32

CandidateCDHash sha1=52a3a6c43e61f269cfc3d61b6d3f1e6fdc55e80a

CandidateCDHash sha256=130a819ae012595a8a749c766a7233e6faa4cad5

Hash choices=sha1,sha256

Page size=none

CDHash=130a819ae012595a8a749c766a7233e6faa4cad5

Signature size=9059

Authority=Developer ID Application: Oracle America, Inc. (VB5E2TV963)

Authority=Developer ID Certification Authority

Authority=Apple Root CA

Peter de Vaal · Dec 23, 2019 11:19AM

If you have Mac OS Catalina then this is the expected behaviour.

Officially Apple distrusts any software not obtained via the AppStore since Catalina. This not only includes SQL developer but also Java. There is even a statement on the Java download page referring to this:

http://www.oracle.com/technetwork/java/javase/using-jdk-jre-macos-catalina-5781620.html

If I read it correctly then SQL Developer (and any Java app) will not run anymore on Catalina after January 2020 at all unless the supplier gets it notarized by Apple. This sounds quite absurd as I (and with me many others) would not be able to use hundreds of tools that we installed as developers anymore. If that really happens Apple will have a big problem.

Additionally, hopefully Oracle will deliver next release for Mac OS X as Apple Notarized (are there any plans in that direction @thatJeffSmith-Oracle ?)

JiF Brodeur · Dec 23, 2019 1:23PM

Thanks Peter, Jeff can you see if SQL Developer will get the required notarized certificate it seems to require by now or soon?

Thanks

Jean-François

thatJeffSmith-Oracle · Dec 23, 2019 1:57PM

I'm guessing Apple will blink first.

Peter de Vaal · Jan 2, 2020 2:20AM

On 2 January 2020 I installed SQLDev 19.4 on Mac OS X Catalina and it still works. On the first run you have to right-click the application and choose open from the menu to be able to start it and tell the OS it is trusted.

user10234477 · Jan 13, 2021 8:44PM

@thatJeffSmith-Oracle Apple didn't blink. I just upgraded to macOS Big Sur and Oracle Developer no longer runs. Below is the error I received. Let me know if there are any other options.

Screen Shot 2021-01-13 at 2.42.57 PM.png

Thanks - PS loved your sessions at the last Oracle conference I went to.

thatJeffSmith-Oracle · Jan 13, 2021 9:45PM

in applications, find sqldev, right-click, open

that should get you a security warning, that you can click through, then should be no problems going forward

thanks for the note regarding the session - hopefully we can do conferences again sometime soon!

user8974487 · Jan 14, 2021 8:14PM

When I click open as you suggest, Jeff, nothing happens at all.

user8974487 · Jan 14, 2021 8:19PM

Same result (i.e, nothing happens, not even an error message), when I use the command

open 'SQLDeveloper 4.app'

in the terminal

thatJeffSmith-Oracle · Jan 14, 2021 9:10PM

in the terminal, you could go into the app, and launch the sqldeveloper.sh script

user8974487 · Jan 14, 2021 9:22PM

That does work, thanks! However, there are two sqldeveloper.sh scripts in there, so you have to run the one in the

/Applications/SQLDeveloper 4.app/Contents/Resources/sqldeveloper

directory, NOT the one in

/Applications/SQLDeveloper 4.app/Contents/MacOS

thatJeffSmith-Oracle · Jan 14, 2021 9:39PM

you're not actually running version 4 of SQL Developer, are you?

user8974487 · Jan 14, 2021 9:51PM

It is Version 20.2.0.175 Build 175.1842. On the Mac sqldeveloper-20.2.0.175.1842-macosx.app.zip unzips as SQL Developer 4.

user10234477 · Jan 29, 2021 1:44PM

Hi again Jeff!

I'm still unable to run SQL Developer or Data Modeler on Big Sur. I'm sure you know but Apple switched from Bash to Zsh on Big Sur. The workaround is to run Data Modeler or SQL Developer in a VM, but that's a tad clunky.

I'm trying to get Data Modeler up and running today on a fresh new download (version 20.4.0.374.0801 - January 15, 2021). When looking at my path below, (and maybe the same issue user8974487 had above) you'll see OracleDataModeler-4.app. This is because I've downloaded it 4 times and OS X just adds a -N onto the end. I also have a OracleDataModeler-2.app and OracleDataModeler-3.app. They are all version 20.4.0.374.0801.

Trying to right click on it and select "Open" gives me this dialog box:

ODM.jpg

Clicking "Open" at this point does nothing. The application is not launched and is not running and there is nothing in activity monitor for it.

Navigating to .../OracleDataModeler-4.app/Contents/Resources/datamodeler and trying to run datamodeler.sh gives me this:

➜ datamodeler bash datamodeler.sh

Oracle SQL Developer Data Modeler

.../OracleDataModeler-4.app/Contents/Resources/datamodeler/datamodeler/bin/../../ide/bin/launcher.sh: line 897: /usr/lib/exec/java_home: No such file or directory

Error occurred during initialization of boot layer

java.lang.module.FindException: Module javafx.base not found

I have Java 11 installed:

➜ datamodeler java --version

java 11.0.8 2020-07-14 LTS

Java(TM) SE Runtime Environment 18.9 (build 11.0.8+10-LTS)

Java HotSpot(TM) 64-Bit Server VM 18.9 (build 11.0.8+10-LTS, mixed mode)

After re-installing JDK11 my JAVA_HOME is not set:

➜ ~ echo $JAVA_HOME

returns nothing...

However I do have JDK11 installed:

➜ ~ /usr/libexec/java_home -V

Matching Java Virtual Machines (4):

11.0.10 (x86_64) "Oracle Corporation" - "Java SE 11.0.10" /Library/Java/JavaVirtualMachines/jdk-11.0.10.jdk/Contents/Home

11.0.8 (x86_64) "Oracle Corporation" - "Java SE 11.0.8" /Library/Java/JavaVirtualMachines/jdk-11.0.8.jdk/Contents/Home

1.8.271.09 (x86_64) "Oracle Corporation" - "Java" /Library/Internet Plug-Ins/JavaAppletPlugin.plugin/Contents/Home

1.8.0_261 (x86_64) "Oracle Corporation" - "Java SE 8" /Library/Java/JavaVirtualMachines/jdk1.8.0_261.jdk/Contents/Home

/Library/Java/JavaVirtualMachines/jdk-11.0.10.jdk/Contents/Home

Attempting to set my JAVA_HOME manual didn't seem to work either:

➜ MacOS export JAVA_HOME=$(/usr/libexec/java_home)

➜ MacOS echo $JAVA_HOME

/Library/Java/JavaVirtualMachines/jdk-11.0.10.jdk/Contents/Home

Trying to run datamodeler form either the ../Resources directory, or the ../MacOS directory:

➜ datamodeler pwd

.../OracleDataModeler-4.app/Contents/Resources/datamodeler

➜ datamodeler bash datamodeler.sh

Oracle SQL Developer Data Modeler

Error occurred during initialization of boot layer

java.lang.module.FindException: Module javafx.base not found

➜ MacOS pwd

.../Downloads/OracleDataModeler-4.app/Contents/MacOS

➜ MacOS bash datamodeler.sh

/Library/Java/JavaVirtualMachines/jdk-11.0.10.jdk/Contents/Home

datamodeler.sh: line 9: cd: datamodeler.sh: Not a directory

➜ MacOS

I'm giving up for now. Let me know if you spot anything above that could be the issue and sincere thanks for helping troubleshoot this!

thatJeffSmith-Oracle · Jan 29, 2021 1:48PM

go into security and tell os x it's ok to run apps not downloaded from the apple store. I've been running sqldev 20.2 and 20.4 on Big Sur since the day Big Sur came out

for absolutely best support today, use oracle jdk 8 (i use 11, it's great, and i also use 14 for that matter, just needs a bit of extra config)

user10234477 · Jan 29, 2021 1:55PM

I did that long ago... I have my Security and Privacy setting set to Allow app from App Store and Identified Developers.

I'm confused.

thatJeffSmith-Oracle · Jan 29, 2021 1:57PM

I distilled everything into this

https://www.thatjeffsmith.com/archive/2014/12/java-mac-sqldev/

user10234477 · Jan 29, 2021 1:57PM

Thanks! I'll give that a try.

user10234477 · Feb 5, 2021 9:20PM

Hi again,

I'm still unable to get Data Modeler to launch. I downloaded SQL Developer, in the hopes of figuring it out and sure enough, SQL Developer had the same issue, but with the article you linked to above, I was able to get it working by changing the SetJavaHome path in the product.conf file.

SetJavaHome /Library/Java/JavaVirtualMachines/jdk-11.0.10.jdk/Contents/Home

I didn't see a hidden directory for Data Modeler at first but after downloading SQL Developer, I saw:

/Users/<username>/.oraclesqldeverloperdatamodeler. In hopes the same fix would work, I changed the SetJavaHome in:

Users/<username>/.oraclesqldeveloperdatamodeler/19.5.0/product.conf

also to

SetJavaHome /Library/Java/JavaVirtualMachines/jdk-11.0.10.jdk/Contents/Home

But that did not work. When I try to run it, I can see it pop up briefly in Force Quit Applications but it immediately disappears.

If I try to run it from the command line, I get this:

➜ MacOS bash datamodeler.sh

/Library/Internet Plug-Ins/JavaAppletPlugin.plugin/Contents/Home

datamodeler.sh: line 9: cd: datamodeler.sh: Not a directory

In System Preferences / Security & Privacy in the bottom panel under "Allow app from", I have "App Store and identified developers" checked.

I have Java installed:

➜ MacOS java -version

java version "11.0.10" 2021-01-19 LTS

Java(TM) SE Runtime Environment 18.9 (build 11.0.10+8-LTS-162)

Java HotSpot(TM) 64-Bit Server VM 18.9 (build 11.0.10+8-LTS-162, mixed mode)

➜ MacOS /usr/libexec/java_home

/Library/Java/JavaVirtualMachines/jdk-11.0.10.jdk/Contents/Home

Do you have any ideas? I see this same post in the Data Modeler forum but it is unanswered.

Many thanks!

user10234477 · Feb 17, 2021 10:06PM

For anyone having the same issue on Big sure, I Solved this by using JDK8 instead of JDK11

Modified product.conf:

/Users/<username>/.oraclesqldeveloperdatamodeler/19.5.0/product.conf

Uncommented and modified line 20 so it became this:

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

(use whatever version of JDK 8 you have installed).

Forum Stats

Howdy, Stranger!

Quick Links

Categories

SQL Developer for macOS does not seem to be properly signed

Best Answer

Answers

Data

Databases

Development

Development Tools

Open Source

Programs

Forum Stats

Howdy, Stranger!

Categories

SQL Developer for macOS does not seem to be properly signed

Best Answer

Answers