topic Re: "Socket Closed" Can't Connect to Oracle DB from DBX Connection in Data Engineering

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

IMDT — Thu, 17 Jul 2025 20:22:05 GMT

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.

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

szymon_dybczak — Fri, 18 Jul 2025 11:47:10 GMT

Hi @IMDT ,

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

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

luketl2 — Wed, 28 Jan 2026 16:18:21 GMT

Would also like to know this as I am facing the same issue and there's really no troubleshooting I can do myself as a third-party owns the RDS instance. When testing the connection it just loads for a while and then says "socket closed". From my understanding, this implies that the TCP session establishes (networking is fine) but immediately is closed by Oracle DB for whatever reason. I've gone through all the possibilities: we are using NNE, we checked and server-side NNE is at "REQUESTED" level (should be higher than "ACCEPTED"), and we checked the service name. Not sure what else to do.