Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

In RDG installed databricks JDBC driver but when we create conenction in OAC getting below error.

Received Response
31
Views
6
Comments

In RDG(remote data gateway) installed databricks JDBC driver but when we create datasource conenction in OAC(dv) getting below error in RDG logs.Please someone advise what to do?

Error-

2025-02-08 00:46:19 ERROR datasource:pool-3-thread-1 - java.sql.SQLException [Databricks]JDBCDriver Communication
link failure. Failed to connect to server. Reason: javax.net.ssl.SSLException: Connection reset.
Cause - [Databricks]JDBCDriver Communication link failure. Failed to connect to server. Reason: javax.net.ssl.SSL
Exception: Connection reset.
com.databricks.client.hivecommon.api.HS2Client.handleTTransportException(Unknown Source)
com.databricks.client.spark.jdbc.DownloadableFetchClient.handleTTransportException(Unknown Source)
com.databricks.client.hivecommon.api.HS2Client.openSession(Unknown Source)
com.databricks.client.hivecommon.api.HS2Client.<init>(Unknown Source)
com.databricks.client.spark.jdbc.DownloadableFetchClient.<init>(Unknown Source)
com.databricks.client.spark.jdbc.DownloadableFetchClientFactory.createClient(Unknown Source)
com.databricks.client.hivecommon.core.HiveJDBCCommonConnection.connectToServer(Unknown Source)
com.databricks.client.spark.core.SparkJDBCConnection.connectToServer(Unknown Source)
com.databricks.client.hivecommon.core.HiveJDBCCommonConnection.establishConnection(Unknown Source)
com.databricks.client.spark.core.SparkJDBCConnection.establishConnection(Unknown Source)
com.databricks.client.jdbc.core.LoginTimeoutConnection$1.call(Unknown Source)
com.databricks.client.jdbc.core.LoginTimeoutConnection$1.call(Unknown Source)
java.util.concurrent.FutureTask.run(FutureTask.java:266)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
java.lang.Thread.run(Thread.java:750)

Tagged:

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 8 - Analytics Strategist

    @User_C3XPZ -

    Is the Data bricks and OAC URL accessible from the machine where data gateway is running? Kindly validate.

  • Test the connection with the steps detailed in this knowledge article.

    Legacy Support Portal
    Security Update For Oracle Analytics (Doc ID 3029871.1)

    New Support Portal
    Security Update For Oracle Analytics KB127925

  • Rank 1 - Community Starter

    Yes its accessble , we have 3 nodes rdg (in this 3 node is new machine with rhel9 openJDK13 is working),but old server(rhel7 openJDK7 not working)

  • Remote Data Gateway is not technically certified with RHEL 9, but it may work
    https://www.oracle.com/middleware/technologies/oac-downloads.html

    The issue could also be the JDK, use Oracle JDK 1.8.xx (not any OpenJDK versions), so check your echo$PATH and which java command in your shell.

  • Rank 1 - Community Starter

    Hi Steve,

    Thanks for checking on working server(RHEL9(openjdk version "11.0.25")). Non working server is RHEL7(openjdk version "1.8.0_442")

  • Rank 1 - Community Starter

    Below are the tests on non working server:

    [oracle@goblxdvo java]$ openssl s_client -connect aap-analytics-lab.cloud.databricks.com:443 -tls1_2
    CONNECTED(00000003)
    write:errno=104

    no peer certificate available

    No client certificate CA names sent

    SSL handshake has read 0 bytes and written 0 bytes

    New, (NONE), Cipher is (NONE)
    Secure Renegotiation IS NOT supported
    Compression: NONE
    Expansion: NONE
    No ALPN negotiated
    SSL-Session:
    Protocol : TLSv1.2
    Cipher : 0000
    Session-ID:
    Session-ID-ctx:
    Master-Key:
    Key-Arg : None
    Krb5 Principal: None
    PSK identity: None
    PSK identity hint: None
    Start Time: 1739328480
    Timeout : 7200 (sec)
    Verify return code: 0 (ok)

    [oracle@goblxdvoa java]$ openssl version
    OpenSSL 1.0.2k-fips 26 Jan 2017
    [oracle@goblxdvo java]$

    ====

    Below is the working server:


    [oracle@goblxdvoacconfig]$ openssl s_client -connect aap-analytics-lab.cloud.databricks.com:443 -brief -tls1_2
    Connecting to 172.27.152.242
    CONNECTION ESTABLISHED
    Protocol version: TLSv1.2
    Ciphersuite: ECDHE-RSA-AES256-GCM-SHA384
    Peer certificate: C=US, ST=California, L=San Francisco, O=Databricks Inc., CN=
    .cloud.databricks.com
    Hash used: SHA256
    Signature type: RSA-PSS
    Verification: OK
    Supported Elliptic Curve Point Formats: uncompressed
    Server Temp Key: ECDH, prime256v1, 256 bits
    [oracle@goblxdvconfig]$ openssl version
    OpenSSL 3.2.2 4 Jun 2024 (Library: OpenSSL 3.2.2 4 Jun 2024)

Welcome!

It looks like you're new here. Sign in or register to get started.