SQLcl

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Incompatible version of libocijdbc[Jdbc:211200230906, Jdbc-OCI:213000

Auke BergsmaAug 24 2024

I have installed Oracle DB 23ai Free and SQLcl: Release 24.2 (on Windows). When I connect (with a thick connection) I get the following:

sql sys@FREEPDB1 as sysdba

SQLcl: Release 24.2 Production on Sat Aug 24 23:36:10 2024

Password? (**********?) ********************
Connection failed
USER = sys
URL = jdbc:oracle:oci8:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ***)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = FREEPDB1) ) )
Error Message = Incompatible version of libocijdbc[Jdbc:211200230906, Jdbc-OCI:213000

I found 2 workarounds: (1) using a thin connection and (2) by copying an ojdbc11.jar from an existing Oracle 21 client to the sqlcl\lib folder. I am wondering if these workarounds are ok, or if there are better or more simpler solutions?

Workaround 1 as a reference:

sql -thin sys@FREEPDB1 as sysdba

SQLcl: Release 24.2 Production on Sat Aug 24 23:34:31 2024

Password? (**********?) ********************
Connected to:
Oracle Database 23ai Free Release 23.0.0.0.0 - Production
Version 23.4.0.24.05
SQL>

Added on Aug 24 2024

0 comments

78 views