Forum Stats

  • 3,733,036 Users
  • 2,246,686 Discussions
  • 7,856,486 Comments

Discussions

SQL Developer for macOS does not seem to be properly signed

JiF Brodeur
JiF Brodeur Member Posts: 35 Blue Ribbon
edited February 2020 in SQL Developer

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

Tagged:
JiF Brodeur

Best Answer

  • thatJeffSmith-Oracle
    thatJeffSmith-Oracle Distinguished Product Manager Posts: 7,685 Employee
    edited December 2019 Accepted Answer

    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

Answers

  • thatJeffSmith-Oracle
    thatJeffSmith-Oracle Distinguished Product Manager Posts: 7,685 Employee
    edited December 2019 Accepted Answer

    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
    Peter de Vaal Member Posts: 174 Bronze Badge
    edited December 2019

    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 BrodeurJiF Brodeur
  • JiF Brodeur
    JiF Brodeur Member Posts: 35 Blue Ribbon
    edited December 2019

    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
    thatJeffSmith-Oracle Distinguished Product Manager Posts: 7,685 Employee
    edited December 2019

    I'm guessing Apple will blink first.

    JiF BrodeurJiF Brodeur
  • Peter de Vaal
    Peter de Vaal Member Posts: 174 Bronze Badge
    edited January 2020

    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.

    JiF BrodeurJiF Brodeur
  • user10234477
    user10234477 Member Posts: 8

    @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.

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

  • thatJeffSmith-Oracle
    thatJeffSmith-Oracle Distinguished Product Manager Posts: 7,685 Employee

    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
    user8974487 Member Posts: 6 Red Ribbon

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

  • user8974487
    user8974487 Member Posts: 6 Red Ribbon

    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
    thatJeffSmith-Oracle Distinguished Product Manager Posts: 7,685 Employee

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

  • user8974487
    user8974487 Member Posts: 6 Red Ribbon

    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
    thatJeffSmith-Oracle Distinguished Product Manager Posts: 7,685 Employee

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

  • user8974487
    user8974487 Member Posts: 6 Red Ribbon

    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
    user10234477 Member Posts: 8

    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:

    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

     Copyright (c) 2008, 2020, Oracle and/or its affiliates. All rights reserved.

    .../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

     Copyright (c) 2008, 2020, Oracle and/or its affiliates. All rights reserved.

    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
    thatJeffSmith-Oracle Distinguished Product Manager Posts: 7,685 Employee

    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
    user10234477 Member Posts: 8

    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
    thatJeffSmith-Oracle Distinguished Product Manager Posts: 7,685 Employee
  • user10234477
    user10234477 Member Posts: 8

    Thanks! I'll give that a try.

  • user10234477
    user10234477 Member Posts: 8

    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
    user10234477 Member Posts: 8

    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).

Sign In or Register to comment.