Forum Stats

  • 3,767,981 Users
  • 2,252,736 Discussions
  • 7,874,399 Comments

Discussions

Testing TAF via SQLCL - instant client jdbc issue

ThinusDBA
ThinusDBA Member Posts: 2 Green Ribbon
edited Nov 16, 2021 12:16PM in SQLcl

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

Tagged:

Answers