Both of these releases fall on the ‘minor’ side of the major update vs maintenance updates scale. There are some SIGNIFICANT bug fixes addressed, however.

Significant enough that I think everyone should go and grab this release today.

You can see the full list here, but I’ll cover the highlights –

Bug Fixes of Note

  • ERROR IN DATA GRID WITH ORACLE/INSTANT CLIENT
  • SQL DEVELOPER CONNECTION TO OCI DATABASE VIA SSH TUNNEL IS INTERMITTENTLY CLOSED
  • SSH CONNECTION GET LOST INTERMITTENTLY
  • SQLCL FAILS TO LAUNCH FROM CMD WINDOW IN WINDOWS DIST
  • BLOCKING UI THREAD ON DATABASE CALL
  • ERROR LINE NUMBER DOESN’T SHOW IN ERROR MESSAGE
  • MIGRATING SQL SERVER TO AUTONOMOUS DATABASE FAILS
  • EXPORT TO XLSX BREAKS WHEN ENCOUNTERING A CLOB COLUMN WITH MORE THAN 32K BYTES
  • DATE FORMAT IN EXCEL OUTPUT FROM SQLDEVELOPER DOES NOT MATCH NLS SETTINGS
  • JDK 15: ASSERTION ERROR BIND VARIABLE NOT FOUND
  • INSIGHT FOR COLUMNS DOESN’T POPULATE EDITOR IF TABLE HAS SCHEMA PREFIX

To summarize, if you were using an older Oracle client, the new JDBC driver was causing havoc on simple things like copy/paste from a grid, SSH connections were unreliable, Excel exports could be busted, and insight wasn’t working if you were using schema prefixes, and last but not least – the UI was getting hung because of some queries blocking the thread.

All bad, all hopefully fixed!

What’s not listed above is the improvements made to the OS X (Mac) distribution.

Better OS X Experience

No more of this, fixed!

The SQLDev app has now been properly signed and registered with Apple. No more warning about not being able to open a ‘malicious’ file.

So, you won’t need to go into your system preferences and make an exception for SQL Developer to open it anymore.

You wil still need to tell your Mac it’s ok to open an application you downloaded over the Internet.

And, you need to make sure you have Java 8 or Java 11 JDKs installed on your machine. If we can’t find it, we will prompt for it’s location.

Here’s how an ‘install’ and open for SQLDev on your Mac should look now.

Note, this is my 2018 Mac Mini with Big Sur running. I’ve cut out some of the time to make it tolerable to watch, but all told it took less than a 90 seconds to go through the first time, and it opens in less than 10 seconds afterwards.

Apologize for the Black Bars, Camtasia 2018 and I on the Mac are having a disagreement about ‘easy’ it is to use.
thatjeffsmith
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.

11 Comments

    • thatjeffsmith

      Yeah. I’m working up a 21.2.1 update to have that fixed. And I’m going to wait a few days to make sure nothing else pops up in the meantime we want to get fixed.

  1. Avatar
    Krzysztof Forys Reply

    Where are Snippets in 21.2?? Not in View menu any more…

  2. Avatar
    keith bines Reply

    So in the temporary absence of the 21c thick client we should use JDBC to connect?

    • thatjeffsmith

      If you need to use an older client, we recommend you download/use version 20.4.0, which has the 19c JDBC driver.

  3. Avatar

    Jeff – When I add a new domain using Domain Administration, the changes don’t reflect in the Logical diagram until I close the Logical diagram and open it again. Also, sometimes the changes I do in the Domain is lost after I close and open it again.

    • thatjeffsmith

      If you’d like to report a bug, please post to the Modeler forums or with My Oracle Support.

  4. Avatar
    Piotr Rzepecki Reply

    Hello Jeff.

    In the Release notes we have: “If using a OCI “Thick” connection type, a 21c Oracle Client will be required”
    and I have “Use OCI/Thick driver” selected to have Kerberos authentication working, however even
    I do have Oracle Instant Client 12.2 and during testing Oracle SQL Developer is complaining about that:

    Testing the Instant Client located at C:\Oracle\Instant Client
    Testing client directory … OK
    Testing loading Oracle JDBC driver … OK
    Testing checking Oracle JDBC driver version … Failed:
    Minimum driver version 21.0 required, specified driver version is 12.2.0.1.0

    but I am able to connect to Oracle 19 database and so far it works.

    Should we expect Oracle Instant Client 21 available for Windows in near future,
    so Oracle SQL Developer will not complain anymore?

    Thank you.
    Piotr

Write A Comment

RSS
Follow by Email
LinkedIn
Share