"Socket Closed" Can't Connect to Oracle DB from DBX Connection

[IMDT]

I want to create a LakeHouse Federation to query data to a remote oracle DB.  I did the test connection to an Oracle DB to create the foreign catalog but keep running into socket closed error using compute.  Which is best Compute or WH?

In Compute using DBX runtime 17.0, Scala 2.13, Spark 4.0

Node type used r6idn.12xlarge
Access mode standard

Note:  I was able to use the same Oracle DB credentials to connect to the Oracle DB successfully from SQL Developer.

[szymon_dybczak]

Hi @IMDT ,

Maybe some networking issue? What's you network setup? Do you see something in driver logs?