Which instant client for sqldeveloper-21.4.0.346.2239-x64 ?

user12132262

I have to upgrade sqldeveloper to sqldeveloper-21.4.0.346.2239-x64. The last instant client I found is 21.3.0. If I use ocijdbc (thick connect) I get the following error:

java.lang.Error: Incompatible version of libocijdbc[Jdbc:214000, Jdbc-OCI:213000

at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:4484)

at java.security.AccessController.doPrivileged(Native Method)

at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:4479)

at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:504)

at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:1042)

at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:97)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:733)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:649)

...

Which client version does fit ? I did not found Oracle client 21.4.

thatJeffSmith-Oracle

I'm able to create thick connections with 19c Instant Client in 21.4, no problems.

cormaco

There is no connection between the two version numbers.

I was successful using the 19.3. client, you could try the 19.13 client that is available for download on the instant client page.

thatJeffSmith-Oracle

I just tested with Instant Client 19.11 and 21.3, no conflicts.

Testing the Instant Client located at C:\OracleInstantClient\instantclient_21_3

Testing client directory ... OK

Testing loading Oracle JDBC driver ... OK

Testing checking Oracle JDBC driver version ... OK

 Driver version: 21.3.0.0.0

Testing testing native OCI library load ... OK

Success! 

thatJeffSmith-Oracle

I'm able to create thick connections with 19c Instant Client in 21.4, no problems.

A Harder

I have a similar problem

On test of jdbc connection (Choose a connection, select 'Properties' and press the 'Test button') I get "Status : Failure -Test failed: Incompatible version of libocijdbc[Jdbc:214000, Jdbc-OCI:213000"

On test of the instant client I get:

"Testing the Instant Client located at C:\Oracle\Base\InstantClient_21_3

Testing client directory ... OK

Testing loading Oracle JDBC driver ... Failed:

 C:\Oracle\Base\InstantClient_21_3 is not a valid jar file"

C:\Oracle\Base\InstantClient_21_3 is the directory to which I have unzipped the 21.3 instant client (WINDOWS.X64_213000_client_home.zip as downloaded from Oracle).

This is for sqldeveloper 21.4.1.349.1822 sqldeveloper-21.4.1.349.1822-no-jre.zip. Got the same behaviour with sqldeveloper-21.4.0.346.2239-no-jre

Yevon

This issue is happening from instant client 19.x and still happens. I just installed latest available versions, instant client 21.3 and sqlcl 21.4 and it claims incompatible versions of liboci libraries. I also tried 21.3 instant client with 21.3 sqlcl with same results:

And when trying to connect without the jdbc string connection with just sqlcl /@CONNECTION_STRING, it just says "Invalid credentials". Sqlplus works without any issues, just sqlplus /@CONNECTION_STRING

Maybe is jsut a warning that should not occur.

xkozs01

I had an issue trying to connect to Oracle 19c using sqlcl 21.4 and instant client 21.3 + Oracle wallet

So the problem is in the incompatible versions of JDBC in SQLCl and JDBC in Instant client. I have downloaded JDBC version 21.13 from https://www.oracle.com/database/technologies/appdev/jdbc-ucp-21-3-downloads.html and placed it into SQLCl directory (replaced existing ojdbc8.jar) and now I am able to connect.

thatJeffSmith-Oracle

version 21.13 from https://www.oracle.com/database/technologies/appdev/jdbc-ucp-21-3-downloads.html and placed it into SQLCl directory (replaced existing ojdbc8.jar) and now I am able to connect.

This is bad, please don't do that. We expect a very specific version of the JDBC driver in our tools.

Yevon

https://community.oracle.com/tech/developers/discussion/comment/16822911#Comment_16822911

What is the correct way to proceed then if we want to use latest versions of sqlcl and instant client? We cannot use them without doing this kind of tricks. I remember using this trick in the past and worked for me once, but I wanted to avoid this as this should work right away.

thatJeffSmith-Oracle

Here's 21.4.2 SQLDev with Instant Client 19c (19.11)

Here's 21.4.2 with Oracle Client 21c

Now let's go into SQLcl.

This doesn't seem right, it should work. We have the same drivers/homes in both places. This smells like a bug to me, stay tuned.

Yevon

Any news about this one? Is it a bug?