此问题的原因是"IO错误:网络适配器无法建立连接".在Sql Developer上? [英] What is the cause of this problem "IO Error: The Network Adapter could not establish the connection" on Sql Developer?
问题描述
我建立了一个连接到数据库服务器(另一台机器)的连接. 然后我发现执行请求的操作时遇到错误: IO错误:网络适配器无法建立连接 供应商代码17002".
I make a connection for connect to the Database Server (other machine). Then I found "An error was encountered performing the requested operation: IO Error: The Network Adapter could not establish the connection Vendor code 17002".
请在下面的URL中查看图片.
Please look the picture in URL below.
我尝试建立连接，但无法访问，但我的团队可以访问它. 我的朋友使用TNS连接类型，我做过类似他的事情，但是无法访问.我尝试使用JDBC Thin进行连接，但是也不能.
I tried to make a connection but can't access but my team can access it. My friend used TNS connection type and I did everthing similar him but can't access. I tried to use JDBC thin for connect but can't also.
我有可以连接的旧连接，但是为什么我不能连接新连接.
I had the old connection which I can connect but why I can't connect the new connection.
推荐答案
您正在尝试连接到SQL Developer无法访问的网络上的计算机.
You're trying to connect to a machine on a network that SQL Developer is unable to reach.
对于TNS连接， 查看适当的TNSNames条目(您将有一个tnsnames.ora)文件，并找到与您要建立的连接关联的IP地址或网络名称-
For a TNS connection, Look at the appropriate TNSNames entry (you will have a tnsnames.ora) file, and find the IP address or network name associated with the connection you're trying to establish -
然后开始尝试ping该资源.
And then start by trying to ping that resource.
在这种情况下，我尝试与我的计算机上位于端口1521上的数据库进行通讯.
In this case, i'm trying to talk to a database on MY machine, on port 1521. Yours should look quite different.
如果使用的是基本连接，则可以查看连接属性，并查看要与之通信的计算机/端口.
If you're using a basic connection, then you can look at the connection properties and see what machine/port you're trying to communicate with.
如果您无法通过计算机访问该计算机，则连接到该数据库的可能性为零.
If you can't reach that machine from your machine, there's zero chance you can connect to a database there.
因此，请始终从ping开始.
So, always start with a ping.
一旦看到可以访问该机器，如果仍然收到该消息，接下来要考虑的是被阻塞的端口，侦听器默认为端口1521，但是您会在TNS描述符中看到它.也一样
Once you see that you can get to that machine, if you're still getting that message, the next thing to think about is blocked ports, the listener defaults to port 1521, but you'll see that in the TNS descriptor as well.
这篇关于此问题的原因是"IO错误:网络适配器无法建立连接".在Sql Developer上?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
