I downloaded SQLcl, unzipped it, sat the PATH system variable to point to its \bin, switched to command prompt (Windows 10), but then never managed to connect to my database (11g) with it. sql /nolog was as far as I could.
First, it said:
“Error Message = no ocijdbc21 in java.library.path: …”,
I searched and surprisingly found out it needs Oracle's "instant client" (Oracle says something along "just unzip and connect"). I download and install IC, run, and then another error message:
“Error Message = Incompatible version of libocijdbc[Jdbc:211200230906, Jdbc-OCI:2115000”
I tried another ver. of IC (ver. 19), but received “cannot find ..” or something, so I switched back to the "incompatible version" (21_15). I'm using SQLcl release 24.2.0.180.1721.
Can you please help me with this??
You have probably in enviroments variables ORACLE_HOME for old version of Oracle. Sqlcl does not need oracle client, but it tries to use it probably. Try to run from cmd and first set SET ORACLE_HOME="" and then run sql.exe.