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

M1/M2 with ARM-based systems-on-a-chip? We have you covered!

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.

It’s a Java 11 distribution, and we make sure the FX libraries are there as well.

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.

Ta-da.
Author

I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

23 Comments

  1. Hello! DO you have any tutorials on creating a new connection? Thank you

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

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

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

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

  5. Chase Marler Reply

    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.

  6. Yayah Ghoal Reply

    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

    • Yayah Ghoal

      Hi Jeff,

      After I tried deleting the sqldeveloper configuration directory (~/.sqldeveloper), the problem I mentioned earlier was resolved.

      Best Regards,
      Yayah

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

    • Alexandre

      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.

Write A Comment