Hi
23.1 was working on db server when setting ORACLE_HOME to instant client 21c.
sqlcl 23.4 is failing with this error:
Warning: Found incompatible $ORACLE_HOME for database version 19
Thick driver unavailable for use.
SQLcl: Release 23.4 Production on Tue Jan 30 15:21:04 2024
Copyright (c) 1982, 2024, Oracle. All rights reserved.
SQL> connect /@ORACL as sysdba
USER =
URL = jdbc:oracle:oci8:@ORACL
Error Message = no ocijdbc21 in java.library.path: /u01/app/oracle/product/19.0.0.0/dbhome_1/lib:/usr/java/packages/lib:/usr/lib64:/lib64:/lib:/usr/lib
USER =
URL = jdbc:oracle:thin:@ORACL
Error Message = IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=DeDZl43QQDCpEViYci4xOw==)
USER =
URL = jdbc:oracle:oci8:@ORACL
Error Message = no ocijdbc21 in java.library.path: /u01/app/oracle/product/19.0.0.0/dbhome_1/lib:/usr/java/packages/lib:/usr/lib64:/lib64:/lib:/usr/lib
USER =
URL = jdbc:oracle:thin:@ORACL
Error Message = IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=puyuecs3TTONg9ftUCMdcA==)
USER =
URL = jdbc:oracle:thin:@ORACL:1521/ORACL
Error Message = IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=zdQQcX0wTgWcmER2TgKzsg==)
looks like sql in 23.4 is looking for sqlplus under $ORALCE_HOME/bin but this is not in instant client
# Using the product version here so we can identify and compare $ORACLE_HOME support
local PRODUCT_VERSION=23.4.0.023.2321
local BASEVERSION=`echo $PRODUCT_VERSION|awk -F. {'print $1'}`
if [[ -n "$ORACLE_HOME" ]];
then
debug $LINENO "ORACLE_HOME found at $ORACLE_HOME"
if [[ -f $ORACLE_HOME/bin/sqlplus ]];