Windows 10, Oracle client 19.3 x64, Oracle database 19.5
Tnsnames.ora is absent, connections configured through LDAP (sqlnet.ora+ldap.ora):
=> sqlnet.ora
NAMES.DIRECTORY_PATH = (LDAP,TNSNAMES,EZCONNECT)
NAMES.DEFAULT_DOMAIN = WORLD
NAMES.LDAP_CONN_TIMEOUT = 3
=> ldap.ora
DIRECTORY_SERVERS = (myldap:389)
DIRECTORY_SERVER_TYPE = OID
DEFAULT_ADMIN_CONTEXT = "dc=world"
=> tnsping mydb
Used parameter files:
C:\193x64\cl\network\admin\sqlnet.ora
Used LDAP adapter to resolve the alias
Attempting to contact (description=(address=(protocol=tcp)(host=mydbhost)(port=1521))(connect_data=(service_name=mydb)))
OK (30 msec)
sqlcl 20.4 returns error:
=> sql usr/pwd@mydb
USER = usr
URL = jdbc:oracle:oci8:@mydb
Error Message = no ocijdbc21 in java.library.path: [C:\Program Files\Java\jdk-11.0.9\bin, C:\windows\Sun\Java\bin, C:\windows\system32, C:\windows, C:\193x64\cl\bin, C:\Program Files\Java\jdk-11.0.9\bin, C:\Program Files\Java\jdk-11.0.9\bin, .]
USER = usr
URL = jdbc:oracle:thin:@mydb
Error Message = /: The Network Adapter could not establish the connection (CONNECTION_ID=JI6dJ5JuRVaHgl54yfjVww==)
...
But sqlcl 20.4 connects successfully with direct ldap url (ezconnect?):
=> sql usr/pwd@ldap://myldap:389/mydb,cn=OracleContext,dc=world
SQLcl: Release 20.4 Production on пн янв. 25 14:43:56 2021
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Last Successful login time: Пн Янв 25 2021 14:43:57 +03:00
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.5.0.0.0
sqlcl 20.3 connects successfully via ldap alias and direct ldap url.
Does SQLcl 20.4 works with Oracle Client 21c only?