szymon_dybczak
Esteemed Contributor III

Hi @SatabrataMuduli ,

I'm quite sure this is networking issue. You didn't provide much detalis about your environment , so I'll give you general advise. You cannot reach on premise oracle database unless networking is explicitly configured or your database has public ip (which is never the case due to security) .

This is more related to cloud provider configuration than databricks itself. Let's take an Azure as an example.  If you Oracle database is ON-PREM then you need to configure one of the following:

  • Site-to-site VPN

  • Point-to-site VPN
  • ExpressRoute

With above configuration set then you would have to deploy your databricks workspace with VNET Injection setting

Deploy Azure Databricks in your Azure virtual network (VNet injection) - Azure Databricks | Microsof...

Only then you'd be able to connect to your database from databricks cluster. 
The connection from your PC works because probably you're using corporate VPN that has access to the network where your DB resides or you're inside network that has connectivty to it.

Of course another reason why you can't connect (assuming in your environment there's already implemented configuration described above) is that traffic is blocked by Firewall. In hub and spoke architecture there's a common pattern that all outbound traffic is redirected to central firewall. So traffic can be simply blocked by firewall (or NSG - that's also something worth to check)