I'm trying to connect to an Oracle data source but get 'IO Error: The Network Adapter could not establish the connection'. What could be the reason for this message?
HI @DF214566,
I fully admit that I am not an Oracle guy at all. So, I will throw out some ideas since it doesn't seem to be an Oracle specific issue. The first couple things I would check is make sure that the Matillion instance can get to and has access to the Oracle data source. With firewalling and routing it's sometimes not clear if that connection is possible. You can test that Matillion has access to the Oracle data source by SSH'ing into the Matillion instance. Once on the console, try to ping the Oracle source server. If that is successful then you at least know that you can get to the data source. If you wanted to get real precise, you could install telnet on the Matillion instance and try connecting to the IP and port on the Oracle server that the database connection is supposed to be open.
Since the error is a Network IO error, I really don't suspect it to be a permissions issue. If you find that the Matillion instance should be able to connect to Oracle from a network perspective I would then concentrate on the connection string you are using. I hope this helps in some way.
Were you able to solve this problem ? If yes please share, I am experiencing the same problem and I am not sure how to resolve it.
Hi @IM050974 (Customer) , Have you found the solution to resolve this issue?
Yes, i was able to solve the problem. i had to build oracle connection string.
Hi,
Can you share the format of the connecting you've built?
Thanks,
Sri
i greyed out servername and db name
but that is the string you need if you are able to see database instance on cloud.
Thanks. That is exactly How I'm using it but still running into issues. Are you using Host name or Host IP in the connecting string?
Thanks,
Sri
host Ip works for me.
is this resolved? I am facing the same error now.
Not yet. Still working with Network engineers to troubleshoot the issue.
Try doing this- How To: Check connectivity to remote sources (matillion.com) to see if Matillion NetworkID/ Subnet mask is able to access your Oracle.
Thanks,
Sri
it is strange! I have created a new instance of matillion and the error is encountered; whereas it works smooth on the old instance.
also, the new instance is created by restoring the backup of the old one !!
When you meant New Instance, did you spin up a New VM?
If yes, then the IP will change. So, you've to work with Infra team to add the New IP to your Firewall setting if you have one.
Thanks,
Sri
We could finally resolve the issue.
There was a conflict between the packet size sent by our network firewall and that can be received by our Oracle DB. The firewall was sending more than the MTU (maximum transmission unit) and hence the oracle was rejecting the request.
Our network team made the necessary changes and is working fine now.
Thanks. I'll try that instead of Host name.
the bash script returns a success message. but the connection error still persists.