Hi,
I am trying to use sqlCl with a ADWH database.
I simply cannot get connected.
Let met explain the case.
I can connect to my ADWH database with SQLPLUS
I can connect to a normal, on premise, database with SQLCL -OCI
But, I cannot achieve a SQLCL -OCI connection to my ADWH database.
Please see below the output of the commands
-- SQLPLUS ADWH
gilles$ sqlplus admin/******@adwgh01_high
SQL*Plus: Release 12.2.0.1.0 Production on Wed Aug 1 18:13:12 2018
Copyright (c) 1982, 2017, Oracle. All rights reserved.
Last Successful login time: Wed Aug 01 2018 17:30:00 +02:00
Connected to:
Oracle Database 18c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
-- SQLCL onprem DB
gilles$ sql -oci system/*******@ghdb
SQLcl: Release 18.2 Production on Wed Aug 01 18:15:37 2018
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Last Successful login time: Fri Jul 27 2018 18:16:45 +02:00
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
-- SQLCL ADWH
gilles$ sql -oci admin/*******@adwgh01_high
SQLcl: Release 18.2 Production on Wed Aug 01 18:16:42 2018
Copyright (c) 1982, 2018, Oracle. All rights reserved.
USER = admin
URL = jdbc:oracle:oci8:@adwgh01_high
Error Message = no ocijdbc12 in java.library.path: [/Users/gilles/Library/Java/Extensions, /Library/Java/Extensions, /Network/Library/Java/Extensions, /System/Library/Java/Extensions, /usr/lib/java, .]
USER = admin
URL = jdbc:oracle:thin:@(description= (address=(protocol=tcps)(port=1522)(host=adwc.eucom-central-1.oraclecloud.com))(connect_data=(service_name=pzzmghe0gke7fyg_adwgh01_high.adwc.oraclecloud.com))(security=(ssl_server_cert_dn= "CN=adwc.eucom-central-1.oraclecloud.com,OU=Oracle BMCS FRANKFURT,O=Oracle Corporation,L=Redwood City,ST=California,C=US")) )
Error Message = IO Error: General SSLEngine problem, connect lapse 87 ms., Authentication lapse 0 ms.
Username? (RETRYING) ('admin/*********@adwgh01_high'?)
I do not understand the error message.
How can ocijdb12 be not found when it is found with on-prem database ?
How can oci be failing when sqlplus (oci) works ?
Should anyone could bring its 2-cent, this would really be great.
Regards,
Gilles