https://community.databricks.com/t5/data-engineering/connectivity-failure-to-on-prem-databases/m-p/100977#M40495 <P>Do you have any custom DNS in your set up? If yes, are you aware of any changes being performed on the same pointing to the databases?</P> Wed, 04 Dec 2024 21:37:07 GMT Walter_C 2024-12-04T21:37:07Z https://community.databricks.com/t5/data-engineering/connectivity-failure-to-on-prem-databases/m-p/100976#M40494 <P>Hi All,</P><P>We have more than 100 jobs right now in Databricks which connect to on-prem database like Oracle. Connection to oracle is made through notebooks using jdbc thin client and using&nbsp;<SPAN><STRONG>com.oracle.ojdbc:ojdbc10:19.3.0.0</STRONG> or&nbsp;</SPAN><STRONG>com.oracle.ojdbc:ojdbc8:19.3.0.0. </STRONG>The jobs were all running successfully since 2 months until yesterday, but suddenly we started getting error from today: <STRONG>The Network Adaptor could not establish the connection. On seeing the log, we get error: No route to host, socket&nbsp; connect lapse 17s. </STRONG>The issue is intermittent where some tasks are getting successful while others are getting failed. All tasks are connecting to same Oracle server and same database/schema. We have a hub and spoke vnet and hub is connected to on-prem databases via site-to-site VPN.</P><P><STRONG>What could be the possible reasons of this failure?</STRONG></P> Wed, 04 Dec 2024 21:33:34 GMT https://community.databricks.com/t5/data-engineering/connectivity-failure-to-on-prem-databases/m-p/100976#M40494 Andolina 2024-12-04T21:33:34Z https://community.databricks.com/t5/data-engineering/connectivity-failure-to-on-prem-databases/m-p/100977#M40495 <P>Do you have any custom DNS in your set up? If yes, are you aware of any changes being performed on the same pointing to the databases?</P> Wed, 04 Dec 2024 21:37:07 GMT https://community.databricks.com/t5/data-engineering/connectivity-failure-to-on-prem-databases/m-p/100977#M40495 Walter_C 2024-12-04T21:37:07Z