Oracle sql developer mac os big sur

Installation Notes

Windows Installation Notes

There are two downloads available for Windows users.

Windows 64-bit with JDK 8 Included

This archive includes both SQL Developer and an embedded copy of the Java 8 Development Kit (JDK). Simply extract the zip to a fresh directory and run the sqldeveloper.exe in the top directory. The EXE is configured to run the embedded JDK by default.

Note: the Windows EXE requires a MSVCR100.dll to run. Most computers will already have this file and in the Windows PATH. However, if the first copy of the file found by the EXE is a 32-bit copy of the DLL, then SQL Developer will fail to start. You can fix this by copying a 64-bit version of the DLL into the BIN directory or updating your OS PATH such that a 64 bit copy of the DLL is found first.

Windows 32-bit/64-bit

This archive. will work on a 32 or 64 bit Windows OS. The bit level of the JDK you install will determine if it runs as a 32 or 64 bit application. This download does not include the required Oracle Java JDK. You will need to install it if it’s not already on your machine. We officially support Oracle JDK 8 or 11.

If SQL Developer cannot find Java on your machine, it will prompt you for the path for a JDK home. This only occurs the first time you launch SQL Developer. A valid Java Home on Windows will be similar to

Mac OS X Installation Notes

This download does not include the Oracle JDK. SQL Developer supports either Oracle JDK 8 or 11.

To install and run

• Ensure you have a JDK installed, if not, download here

(For 64-bit Intel Macs, download Java for Mac OS X 10.5, Update 1.

For the latest version of Mac OS, use the Software Update feature)

Download the file for OS X on the Downloads page

Double-click the SQL Developer icon

RPM for Linux Installation Notes

This download does not include the JDK. SQL Developer supports either Oracle JDK 8 or 11.

Источник

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

4 Answers 4

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:

(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:

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:

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

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

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

You need to update JavaHome inside your product.conf file of SQL Developer and it will work.

File location: /Users/ /.sqldeveloper/19.2.1/product.conf

Update the line with a JDK less than 11. In my case, it is:

Building on sql-no’s answer, I removed the JavaAppletPlugin.plugin from my internet plugins directory and bypassed the macOS Gatekeeper to open the app.

1. Remove the plugin:
   sudo rm -rf «/Library/Internet Plug-Ins/JavaAppletPlugin.plugin/»
   Alternatively, If sudo rm -rf makes you as uncomfortable as it should you can also:
   «Go to the folder» with (Command + Shift = G) and move it to the trash.
   
2. Bypass the macOS Gatekeeper by forceing SQLDeveloper.app to open even though it was not downloaded from the App Store or on Apple’s pre-approved list. To do this, right-click (or Control+click) on SQLDeveloper.app, then choose Open from the contextual menu. (You may need to agree once to proceede with the open. I didn’t take a screenshot the first time through)

Источник

OS X Big Sur and SQL Developer won’t start? Here’s how to fix it!

14 July 2021 Update

If you’re stuck (for reasons) with an older version of SQL Developer, read on. But seriously, just upgrade.

If you have version 20.4.1 or older…

In this post I want to talk about this ugly warning:

Just Click ‘Ok’

‘Oracle … can’t be opened because Apple cannot check it for malicious software.’

You don’t really need to wait for an update from us, you can tell your Mac it’s OK to run right now! Read on, and you’ll be going in a minute or 3.

By the way, we have notarized the SQL Developer and SQL Developer Data Modeler apps for OS X. However, we ship 3rd party JARs, and those ALSO have to be notarized, else Big Sur gets cranky and you’ll see this message.

Anyways, after clicking ‘Ok’ – go to your System Preferences and navigate over the Security screen.

You’ll see that OS X has recognized it denied you access to an app that YOU installed.

Click ‘Open Anyway.’

If you don’t see this, it’s probably because you haven’t clicked ‘Ok’ to the first warning dialog yet.

Once you’ve done this, you’re going to be a bit closer.

Try to open the app again, and you’ll now see this –

Click ‘Open’ and Modeler or SQL Developer should open right up.

You’ll only have to do this nonsense once. And hopefully we can get those 3rd party library/jars signed later this year so it’s easier on everyone involved.

If you’re not seeing SQLDev show up even after all of this, go look at this article again and make sure your Java is sorted.

And hopefully now you’re here – ready to rock’n’roll again.

Speaking of Java, we’re talking about distributing the oracle JDK home WITH the app for OS X, just like we do for Windows. If you think that’s a good idea, feel free to leave a comment below.

And finally, these instructions are also spelled out in the OS X support pages here.

Источник

SQL Developer

Answers

Same here with Java sdk 11 and latest SQL Developer release today, using Big Sur release.

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.

I had the same issue. Here is one of the solutions to open sqldeveloper;

Open the following folder

Double click sqldeveloper unix executable file.

Double click sqldeveloper unix executable file.

Its known issue, Sql Developer cant find javahome. So to fix this, put your javahome

in your product.conf file:

You can find your java home path, by

Officially supported java 8,11, but also works fine with 14

This worked for me. Thank you.

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

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

)This workflow worked for me. I am running sql developer 20.4 on Mac OS Big Sur

it works perfectly !! THANKS A LOT !

Just follow the steps below:

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

Right click on SQLDeveloper.app and choose «Show Package Contents»

Double click on Contents and then MacOS

Go to Oracle’s site and download JDK 1.8 JRE

Unzip it and copy the directory into the MacOS directory

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

so now sqldeveloper.sh looks like this:

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

if [ -z «$TMP_PATH» ] ; then

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

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 .

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

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

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

source «$HOME/.sqldeveloper/env.sh» >> /dev/null

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

7. Save sqldeveloper.sh

Now run it and you should get the splash screen.

Источник

How can I Make SQL Developer Data Modeler Work on MacOS Big Sur?

My Oracle Data Modeler worked fine on my MacOS company laptop. Then the latest MacOS 11.1 (code name Big Sur) was installed and now Data Modeler won’t open. Will Oracle provide a fix for SQL Developer Data Modeler to work on the Big Sur OS? Is there any way I can retrieve all my models that were created before the OS update?

Answers

Did you check you still have the Java version installed that is expected by Data Modeler? It might be that a BigSur install removes Java. I cannot test unlucky enough, my MBP is just a few months too old to upgrade to BigSur.

No I did not check the previous Java. I’ll do that now. Thank you.. However, I did download the newest Data Modeler along with its specified Java. When I attempt to launch it, BigSur returns a message stating «‘Oracle Data Modeler’ can’t be opened because Apple cannot check it for malicious software.». That tells me that Data Modeler for MacOS has not yet been upgraded. I’m hoping there will be some way to save/retrieve my models in the future.

DataModeler runs as SQL developer on Java, so may have the same solutions. On the SQL Dev discussions several solutions have been mentioned, see e.g.: https://community.oracle.com/tech/developers/discussion/4477890/sql-developer-on-macos-big-sur#latest

I have the correct Java, have modified the conf files. got it running, created a very small 1 entity model and tried to save. Get an error saying the fold (/Users/[myname]). anythingunder that is not Accessible.

Datamodeler listed in «All folders» access. Perms onall dirs/folders have been opened up. My is owner etc. etc. (I’m a very experience UNIX etc . admin). Driving me crazy. also going nuts with the latest Windows version and the «Msvcr100.dll» file.

I have a fortune 150 client ready to look at this (and other Oracle products) for ETL/Data profiling, Meta data etc. I have until Monday (12/14) to get this working or they’ll be spending on ErWin or ErStudio.

PS 27″ iMac, latest Big Sur, 64 GB ram etc. etc

Windows is similar.. It shouldn’t be this difficult

Datamodeler listed in «All folders» access. Perms onall dirs\/folders have been opened up. My is owner etc. etc. (I’m a very experience UNIX etc . admin). Driving me crazy. also going nuts with the latest Windows version and the «Msvcr100.dll» file.

I have a fortune 150 client ready to look at this (and other Oracle products) for ETL\/Data profiling, Meta data etc. I have until Monday (12\/14) to get this working or they’ll be spending on ErWin or ErStudio.

PS 27″ iMac, latest Big Sur, 64 GB ram etc. etc

Windows is similar.. It shouldn’t be this difficult

For the problem with missing «Msvcr100.dll» file see this post:

Thank you for the quick response ‘ll try it later this afternoon . On the Mac Ios, I will just have to save everything under ‘public’ until the product is compatible with Big Sur. I shudder to think of the issues looming with Apple’s new chipset and compatibility. 😉

Did you get Data Modeler working? I posted on the SQL Developer form but will re-post here for convenience:

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 (@thatJeffSmith-Oracle posted it — I’ve not been around long enough to post links; great summary and fixed SQL Developer just not Data Modeler), I was able to get it working by changing the SetJavaHome path in the product.conf file.

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

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

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

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

Источник