Oracle远程连接jndi报错The Network Adapter could not establish the connection。。。。Connection refused: connec

今天碰到，kettle，dbeaver连 Oracle 数据库时出现如下异常信息，java.sql.SQLRecoverableException: IO 错误: The Network Adapter could not establish the connection。

具体异常信息：

java.sql.SQLRecoverableException: IO 错误: The Network Adapter could not establish the connection

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:673)

at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:715)

at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:385)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:30)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:564)

at java.sql.DriverManager.getConnection(DriverManager.java:571)

at java.sql.DriverManager.getConnection(DriverManager.java:215)

at com.liuqianfei.metademo.OracleMetaDemo1.main(OracleMetaDemo1.java:25)

Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection

at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:445)

at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:464)

at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:594)

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:229)

at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1360)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:486)

... 7 more

Caused by: java.net.ConnectException: Connection refused: connect

at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)

at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)

at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)

at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)

at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)

at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)

at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)

at java.net.Socket.connect(Socket.java:579)

at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:162)

at oracle.net.nt.ConnOption.connect(ConnOption.java:133)

at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:411)

... 12 more

Caused by: java.net.ConnectException: Connection refused: connect.

关于这个问题我之前已经找过了，但没有一个和我遇到的问题一样的，因为我这个有两个任务都用到了jndi的连接方式，所以网上说的1、防火墙 2、tnsnames.ora 文件中查看详细配置信息 3、端口号被占用 4、服务器中允许的最大进程数 都没关系，操作没有一点作用。

而是，一切无门后和服务器那边厂家联系后，那边说做了安全策略，所以我这里一直无法访问上。等那边添加进去后就解决了

此外还有一种可能，就是对方暂时停用服务器了，所以短期内也连接报错，这个等对方恢复使用后再对数据进行恢复操作。