SQL Developer

Developer Tools & Services Xcode
Edgar_Alonso_Perez OP
Created Nov ’20
Replies 19
Boosts 0
Views 17k
Participants 22
I've been using Big sur 11.0.1 Beta (20B5022a) on a macbook pro (13-inch, 2019, Four Thunderbolt 3 ports, and when i need to use SQLDeveloper this does not working, and just show me a message saying "The application “SQLDeveloper.app” can’t be opened." Does someone has the same issue ?
Replies  19
Boosts  0
Views  17k
Participants  22
craigreilly OP
Nov ’20
Same here with Java sdk 11 and latest SQL Developer release today, using Big Sur release.
MGB10 OP
Nov ’20
Same here, tried with jdk 8 and 11 on Big Sur release, I don't even have any error message, it doesn't launch anything.
minajidas OP
Nov ’20
Same ! Sql Developer does not open, does anyone have a solution ?
White7561 OP
Nov ’20
Same here. Thank gosh I installed a fresh Big Sur on my external SSD before jumping all in!! Turns out SQL Developer ain't working at all... Waiting for update before moving to Big Sur....
AlvaroJimenez OP
Nov ’20
Install jdk 11 then edit your .product.conf (eg.: vi ~/.sqldeveloper/20.2.0/product.conf )
 

SetJavaHome /path/jdk

SetJavaHome /Library/Java/JavaVirtualMachines/jdk-11.0.9.jdk/Contents/Home
White7561 OP
Nov ’20
Ah so it works? Does it need java 11 or does even java 8 works like usual?
chale- OP
Nov ’20
I can't take credit for this as this was on an oracle forum. But when I ran

cd /Applications/SQLDeveloper.app/Contents/resources/sqldeveloper
zsh sqldeveloper.sh

From the terminal it opened up for me.
hetOrakel OP
Nov ’20
With java 8, most recent update, and the current version of SQLDeveloper (20.2.0.175.1842-macosx) it works. You will have to set "Allow apps downloaded from: App Store and identified developer" in the general tab of "Security & Privacy" .
emreozeren OP
Nov ’20
I've tried all the suggested solutions but none of them works except running "cd/Applications/SQLDeveloper.app/Contents/resources/sqldeveloper zsh sqldeveloper.sh" over console. It is not a fancy way but it works.
PonSankar OP
Nov ’20
I had the same issue. Here is one of the solutions to open sqldeveloper;

Open the following folder

  1. SQLDeveloper.app/Contents/Resources/sqldeveloper/sqldeveloper/bin

  2. Double click sqldeveloper unix executable file.
Ahmedsakr OP
Nov ’20
I got this from one of the developers here and it works
Open the following folder

  1. SQLDeveloper.app/Contents/Resources/sqldeveloper/sqldeveloper/bin

  2. Double click sqldeveloper unix executable file.
Jamal-Sale OP
Nov ’20
Its known issue, Sql Developer cant find javahome. So to fix this, put your javahome

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

in your product.conf file:

Code Block 
/Users/<username>/.sqldeveloper/product.conf

You can find your java home path, by 
Code Block 
ls -ls /Library/Java/JavaVirtualMachines/

Officially supported java 8,11, but also works fine with 14
satori2004 OP
Jan ’21

  1. ) Launch terminal app

  2. ) run the following command to list your Java Versions: /usr/libexec/java_home -V

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

  1. ) To remove, type in the following command: sudo rm -rf "/Library/Internet Plug-Ins/JavaAppletPlugin.plugin/"

  2. )This workflow worked for me. I am running sql developer 20.4 on Mac OS Big Sur
silcwb OP
Mar ’21
Hi everyone,

Just follow the steps below:

  1. Right click on SQL Developer in the dock and choose Options | Show in Finder

  2. Right click on SQLDeveloper.app and choose "Show Package Contents"

  3. Double click on Contents and then MacOS

  4. Go to Oracle's site and download JDK 1.8 JRE

  5. Unzip it and copy the directory into the MacOS directory

  6. Open sqldeveloper.sh in any text editor. I commented out everything in the file and pasted in the following:

export PATH=/Applications/SQLDeveloper.app/Contents/MacOS/jre1.8.0_251.jre/Contents/Home/bin:$PATH
export JAVA_HOME=/Applications/SQLDeveloper.app/Contents/MacOS/jre1.8.0_251.jre/Contents/Home

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

so now sqldeveloper.sh looks like this:

#!/bin/bash

TMP_PATH=/usr/libexec/java_home -F -v 1.8

if [ -z "$TMP_PATH" ] ; then

TMP_PATH=/usr/libexec/java_home -F -v 9

#TMP_PATH='/Applications/SQLDeveloper.app/Contents/MacOS/jre-9.0.4.jre/Contents/Home'

if [ -z "$TMP_PATH" ] ; then

osascript -e 'tell app "System Events" to display dialog "SQL Developer requires a minimum of Java 8. \nJava 8 can be downloaded from:\n ...

exit 1

fi

fi

# export JAVA_HOME=$TMP_PATH

# if [[ -f $HOME/.sqldeveloper/19.1.0/env.sh ]];

then

source "$HOME/.sqldeveloper/19.1.0/env.sh" >> /dev/null

elif [[ -f $HOME/.sqldeveloper/env.sh ]];

then

source "$HOME/.sqldeveloper/env.sh" >> /dev/null

fi

#

here="${0%/*}"

cd "${here}"

cd ../Resources/sqldeveloper/sqldeveloper/bin

bash ./sqldeveloper >>/dev/null



export PATH=/Applications/SQLDeveloper.app/Contents/MacOS/jre1.8.0_251.jre/Contents/Home/bin:$PATH
export JAVA_HOME=/Applications/SQLDeveloper.app/Contents/MacOS/jre1.8.0_251.jre/Contents/Home

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

7. Save sqldeveloper.sh

Now run it and you should get the splash screen.
litoombee OP
Apr ’21
Reading all the options at the end this was the one that worked

  1. ) Launch terminal app

  2. ) run the following command to list your Java Versions: /usr/libexec/java_home -V

  3. ) From the output, the one that is causing the issue is:

  4. "Oracle Corporation" - "Java" /Library/Internet Plug-Ins/JavaAppletPlugin.plugin/Contents/Home"; You'll need to remove this

  5. ) To remove, type in the following command: sudo rm -rf "/Library/Internet Plug-Ins/JavaAppletPlugin.plugin/"

  6. )This workflow worked for me. I am running sql developer 20.4 on Mac OS Big Sur
HarshMani OP
May ’21
Keep your App inside Application and fire "cd /Applications/SQLDeveloper.app/Contents/resources/sqldeveloper
zsh sqldeveloper.sh" this works for me, It has been mentioned in Oracle docs also.
clt25 OP
May ’21
I wanted to reply to this question as well. The solution that worked for me also was this one:

  1. Reading all the options at the end this was the one that worked

  2. Launch terminal app

  3. run the following command to list your Java Versions: /usr/libexec/java_home -V

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

  5. To remove, type in the following command: sudo rm -rf "/Library/Internet Plug-Ins/JavaAppletPlugin.plugin/"
PradeepYadav OP
Jul ’21

just open terminal app and run below command

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

now open sql developer app for sure this will work!!!
ragunathms OP
Jan ’22
  1. If you have a previous versions, first you delete the same and follow these steps. On Monterey(latest version) it is working for me even I had same problem.
  2. Download, https://www.oracle.com/tools/downloads/sqldev-downloads.html SQL Developer from this link
  3. Download Java 8 or 11 required for this version.
  4. link for java 8 *) https://www.oracle.com/java/technologies/downloads/#java8
  5. link for java 11 *) https://www.oracle.com/java/technologies/downloads/#java11
SQL Developer
First post date Last post date
 
 
Q