My Oracle Support Banner

SQL Developer 22.x on MacOS Using OCI/Thick Client Connection Fails With Exception "java.io.IOException: Cannot run program" (Doc ID 2886087.1)

Last updated on JULY 27, 2022

Applies to:

Oracle SQL Developer - Version 22.2 and later
Information in this document applies to any platform.

Symptoms

On : SQL Developer 22.2 version
       MacOS 11.3.1 on Intel x86-64

Integrate Instant Client 19.8 per instructions in:
     Note: 2121278.1 How To Integrate the Oracle Client and OCI Thick Drivers with SQL Developer.

When try to test the Oracle Client configuration, get the following error:

  The target Oracle Client Test Results cannot be started because an exception was thrown:
  java.io.IOException: Cannot run program
  "/Applications/SQLDeveloper.app/Contents/Resources/sqldeveloper/jdk/bin/java" (in directory
  "/Applications/SQLDeveloper.app/Contents/Resources/sqldeveloper/sqldeveloper/bin"): error=2, No such file or directory

The Oracle Client does not work.

Steps to Reproduce:
1. Go to Oracle SQL Developer > Preferences > Database > Advanced.
2. Click Configure under "Use Oracle Client".
3. Set Client Type to "Instant Client" and Client Location to "/<path>/instantclient_19_8".
4. Click Test.

Result:
Error specified above.

The Oracle Client does not work. The sqldeveloper.oci.available property is false.

Expected result:
Test succeeds.

Workaround:
Use SQL Developer 21.4.3. The Oracle Client works with that version.

Changes

 Upgrade to SQL Developer 22.2.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.