Hello folks.
So, I'm experimenting with SQLcl and it is working fairly well on my setup, but I'm having difficulties to make it work with the instant client. First I tried to simply use the -thick option to force the use of the client instead of jdbc.
Then I hit the problem with the client version. I'm running Oracle 19.27 on Oracle Linux and I'm trying with the latest SQLcl 26. Understandable, the ocijdbc driver shipped with it is not compatible with the default client 19 on the instance. According to my researches, SQLcl 26 expects the Oracle client 23.
So I tried to put an instant client on the machine (not replacing the original 19): I downloaded the OCI 23.26 and configured the session for SQLcl to use it, but it didn't work:
Error Message = Incompatible version of libocijdbc[Jdbc:23702501, Jdbc-OCI:2326200
So… The jdbc 23.7 shipped with SQLcl 26 is not compatible with the jdbc on the client 23.2? It's the same major version, but just the release is incompatible? Weird. OK, let me download the instant client 23.7 then… nope, it does not exist. The latest instant client is indeed the 23.2.
I happen to have a SQLcl 24 somewhere here, maybe its jdbc works with the client 23.2? I tried with it but then:
Error Message = no ocijdbc21 in java.library.path: /***********************
OK, SQLcl 24 seems to work exclusively with the client 21. So I downloaded the instant client 21 and tried it once more:
Error Message = Incompatible version of libocijdbc[Jdbc:211200230906, Jdbc-OCI:2122000
Back to square 1??? The jdbc 21.1 shipped with SQLcl 24 does does not accept the 21.2 from instant client. The jdbc version must perfect match on both SQLcl and the client? I must be doing something wrong?
Did anyone get to make SQLcl work with the oracle client? With the -thick option? Am I forgetting any variable or something else?