Oracle SQL Developer for the Mac (and Windows and Linux)
For many years we’ve offered a download for Windows users that included an Oracle JDK embedded in the software package.
Starting today, we’re now offering the same for both hardware chipsets offered by Apple
My friends with ARM architecture equipped Macs are telling me that SQLDev is easier 4x faster now that it’s using an ARM JDK.
No more complicated ‘How to’ guides for SQLDev and Macs
Here’s all you need to do now:
- download the appropriate APP
- in Finder, drag to Applications
- launch it
It will use the Java Home embedded in your SQLDeveloper app.
You can see this if you open up the Application properties.
My Mac Mini is from 2018, so it’s an ‘old Intel’ chip based piece of hardware. However, I’ve had several internal folks with fancy new M1’s tell me the ARM version of the download fires right up 🙂
For all OS updates, there’s a single bug fix as well
When creating/editing tables, if you tried to go into the advanced column properties, you’d get a nasty Java error. That’s fixed now.
23 Comments
Hello! DO you have any tutorials on creating a new connection? Thank you
Kinda.
Hi Jeff,
I have installed Oracle SQL developer with JDK on my MacBook Pro M1 chip. I just double-clicked on the zip file, and all I can see is SQLDeveloper (It’s working fine I created a database to test it), there are no files that are extracted from the zip file. Do I have to uninstall it and re-do the file extraction? or is it okay if I try to extract them now in a new folder? (If I have to uninstall it, please do let me know the process whether is it just removing the application or deleting the databases as well)
Regards
Flicky
JDK is not installed as well. So I’m not sure whether to reinstall it or extract the files
Inside the Zip is the App…drag that to applications, then you’re done.
Thank you, Jeff. I have done that but still, it says JDK is not installed. Should I extract the contents of the app into the applications as well?
No you shouldn’t have to do anything, just make sure you’re grabbing the right download, there’s one for Intel based chips and one for the M1/2/3’s.
Hola, uso un MacM1, tengo un error al crear una conexión. Tengo este error, no sé qué hacer. He buscado mucha información y todo indica que no se puede hacer una conexión. ¿puede ayudarme?
Estado: Fallo:Fallo de la prueba: Error de E/S: El adaptador de red no pudo establecer la conexión (CONNECTION_ID=QZDarxHuTi+HCv6Xyf+Qtg==)
Ese mensaje de error básicamente le dice que el programa no puede llegar al servidor en la red.
Vea si puede hacer ‘PING’ a la dirección ‘IP’ del servidor
Hello, I am on a MacBook Pro M1, I have an error when making a connection, how can I fix this.
Step 1: describe where your database is physically located
Step 2: share the error message you are getting (there is more than 1!!!)
Any chance you have pro tips on allowing File/Folder access for SQL Developer? Added the SQL Developer app to the Full Disk Access list as well as the Java inside sqldev’s java_home, but I’m unable to navigate anywhere on my computer outside my home directory using SQL Developer.
I’ve seen your other comments/suggestions floating around out in the wild https://community.oracle.com/tech/developers/discussion/4477224/sql-developer-cant-read-files-from-the-users-documents-folder-in-mac-os
Hi Jeff,
I’m on a Macbook M1 and have downloaded SQL Developer 22.2.1.234 Mac ARM64 with JDK11 included.
When running from the SQL Developer Launcher, it stops at the opening window with the status message Loading.
But I can run it via Terminal Command Line directly, with the command /Applications/SQLDeveloper.app/Contents/MacOS/sqldeveloper.sh
What do I need to do to get it to run through the launcher?
Best Regards,
Yayah
Hi Jeff,
After I tried deleting the sqldeveloper configuration directory (~/.sqldeveloper), the problem I mentioned earlier was resolved.
Best Regards,
Yayah
Great!
Hi Jeff,
just installed version 22.2.1.234 ( windows user here ), it seems that autocomplete for packages/procedures/functions is not working at all, at least for me. I installed(
On my last version 20.2 pck/proc/fnc autocomplete works fine
Is there any tweak for that? I checked options and everything in “Code Editor/Completion Insight” is set on, speed is 0,4 sec
Table/Column autocomplete works well ( faster than my last version )
Can you be more specific? And it might be easier to talk this one out on the forums.
Hi Jeff.
I’m facing a weird situation when trying to edit table definitions, maybe you can help me.
I open the table definitions, and after pressing the button “edit”, the dialog “Preparing editor for null” shows up, and it takes a long long time until I can actually navigate and modify table definition (more than 10 minutes).
I checked my session activity from another SQL client, and it seems to be stuck in this query:
SELECT /*OracleDictionaryQueries.ALL_COLUMN_ORACLE12c_QUERY*/
C.COLUMN_NAME, C.DATA_TYPE, C.DATA_TYPE_OWNER, C.DATA_LENGTH, C.DATA_PRECISION, C.DATA_SCALE, C.NULLABLE, C.DEFAULT_LENGTH, C.CHAR_LENGTH, C.DATA_DEFAULT,
( SELECT CMT.COMMENTS FROM SYS.DBA_COL_COMMENTS CMT
WHERE C.OWNER = CMT.OWNER AND C.TABLE_NAME = CMT.TABLE_NAME
AND C.COLUMN_NAME = CMT.COLUMN_NAME) COMMENTS decode(C.CHAR_USED, ‘B’, ‘BYTE’, ‘C’, ‘CHAR’,null)
, C.DATA_TYPE_MOD, C.VIRTUAL_COLUMN, C.IDENTITY_COLUMN, C.DEFAULT_ON_NULL
FROM SYS.DBA_TAB_COLS C
WHERE C.OWNER = :1 AND C.TABLE_NAME = :2 AND C.HIDDEN_COLUMN = ‘NO’
ORDER BY C.COLUMN_ID
OK, this query is doing exactly what it takes to allow editing the table, but for some reason it is slow, very slow.
Só I tried to run this statement removing the subselect which retrieve the comments, and it runs almost instantaneously.
Not sure if it started to happen after some upgrade on OSD or after our company database migration (it is currently on 19c).
Any clue?
Thanks in advance.
That query hasn’t changed in many, many years.
You can ask your DBA to check data dictionary stats or grant you access to DBA_ views, which will all be faster than ALL_ views.
Hello Jeff.
I still see Version 22.2.0.173.2018 when using https://www.oracle.com/database/sqldeveloper/technologies/download/ link, so should we wait a little bit or is there another way to access new version?
Best Regards.
Piotr
Try clearing your browser cache or use a different browser.
After using different browser (MS Edge) it worked.
Thank you.