Skip to Main Content

SQLcl

Announcement

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

sqlcl 23.4 does not work with instant client 21c

Ned GhanemJan 30 2024

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 ]];

Comments
Post Details
Added on Jan 30 2024
1 comment
222 views