I downloaded the latest SQLcl and tried to use it but its not using TNS as it supposed to. Here is the error am getting:
C:\>java -version
java version "1.8.0_171"
Java(TM) SE Runtime Environment (build 1.8.0_171-b11)
Java HotSpot(TM) 64-Bit Server VM (build 25.171-b11, mixed mode)
C:\>sql /nolog
SQLcl: Release 18.1.1 Production on Fri Apr 20 10:08:43 2018
Copyright (c) 1982, 2018, Oracle. All rights reserved.
SQL>
SQL> conn scott/tiger@testdb
USER = scott
URL = jdbc:oracle:oci8:@testdb
Error Message = Incompatible version of libocijdbc[Jdbc:122010, Jdbc-OCI:121020
USER = scott
URL = jdbc:oracle:thin:@testdb
Error Message = IO Error: Unknown host specified
USER = scott
URL = jdbc:oracle:thin:@testdb:1521/testdb
Error Message = IO Error: Unknown host specified
I am not sure why its using my tnsname as hostname in connection string. It should get the detailed connection string from tnsnames.ora file but its just using that alias as hostname and not going anywhere.
Please help me adopt this new [not really] cool tool.
Thanks