Skip to Main Content

SQLcl

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Testing TAF via SQLCL - instant client jdbc issue

ThinusDBANov 16 2021 — edited Nov 16 2021

SQLCL version 20.4 and Oracle Client 21.3 (64 Bit and 32 Bit) on my Windows 10 server

Contents of my .bat file to launch sqlcl:
set PATH=C:\Users\a13041p\Documents\instantclient\instantclient_21_3_64Bit;%PATH%
C:\Users\...\sqlcl-20.4.2.35.2359\sqlcl\bin\sql.exe
I submit the connect string as:
jdbc:oracle:oci:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost-scan)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=TAFTEST)(FAILOVER_MODE=(TYPE=select)(METHOD=basic))))

With PATH pointing to 64Bit Oracle Instant Client I get Error Message = C:\Users\a13041p\Documents\instantclient\instantclient_21_3_64Bit\ocijdbc21.dll: Can't load AMD 64-bit .dll on a IA 32-bit platform

With PATH pointing to 32Bit Oracle Instant Client Error Message = Incompatible version of libocijdbc[Jdbc:211000, Jdbc-OCI:213000

Comments
Post Details
Added on Nov 16 2021
3 comments
121 views