- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-05-2023 10:03 PM
@Mahesh D :
If you have already whitelisted the Azure Databricks IP ranges on your AWS RDS security group and are still unable to connect, there may be some additional steps you can take.
First, ensure that you have configured the Oracle JDBC driver correctly in Azure Databricks.
Next, check if your RDS instance has publicly accessible enabled. If it is not, you may need to enable it to allow traffic from Azure Databricks to reach your RDS instance.
Also, ensure that the Oracle listener on your RDS instance is running and listening on the correct port. You can check the listener status and port number by connecting to the RDS instance using a tool like SQL*Plus or SQL Developer.
If you still cannot connect after trying these steps, you may want to check the network configuration of your VPC and subnets in AWS to ensure that there are no network security groups or ACLs that are blocking the traffic.
Lastly, you can enable VPC flow logs in your VPC to troubleshoot connectivity issues between your RDS instance and Azure Databricks. Flow logs can provide detailed information on the traffic flows and can help you identify any issues with the network configuration.