Hi
I was trying to connect to my oracle db using TCPS. but getting below error
IO Error: Received fatal alert: handshake_failure, connect lapse 68 ms., Authentication lapse 0 ms.
steps i did.
in connection, enabled SSl checkbox
1. in java 1.8/ cacerts - imported the corporate root certificates.[ this works for sqlDeveloper and connecting from java]
2. since it didnt worked adde the root certificates to truststore and keystore in /etc/apps/splunk_app_db_connect/certs
this also didnt worked.
3. added ojdbc8.jar into driver folder
But still it is giving me error, other TCP connections are working fine.
Kindly help
Hi Vijayakumarkb,
I wonder if you were able to resolve this because I cam getting the exact same error. things I did:
Running curl as in
curl --cacert /tmp/certname.pem -v https://hostname:portnumber
is successful however in DB connect under connection I am getting: "IO Error: Received fatal alert: handshake_failure, connect lapse 1 ms., Authentication lapse 0 m"
I am using DB Connect v 3.1.4 + Java v 1.8.0
Thanks
using version splunkdbx 3
Hi,
Based on https://docs.splunk.com/Documentation/DBX/3.3.0/DeployDBX/Installdatabasedrivers , you need to use correct JDBC driver, for example: For Oracle 12c - ojdbc7.jar driver is supported with JDK8
I use Oracle DB version 12.2 and OJDBC jar 8, tried with 7 also.
Try this troubleshooting steps https://docs.splunk.com/Documentation/DBX/3.2.0/DeployDBX/Troubleshooting#Cannot_connect_to_Oracle_S...
Thanks, i did that, but where can we see the ORA errors.
i don't see them in the logs