今天碰到，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.Exception: The Network Adapter could not establish the connection
at .nt.ConnStrategy.execute(ConnStrategy.java:445)
at .resolver.AddrResolution.resolveAndExecute(AddrResolution.java:464)
at .ns.NSProtocol.establishConnection(NSProtocol.java:594)
at .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: .ConnectException: Connection refused: connect
at .DualStackPlainSocketImpl.waitForConnect(Native Method)
at .DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)
at .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at .PlainSocketImpl.connect(PlainSocketImpl.java:172)
at .SocksSocketImpl.connect(SocksSocketImpl.java:392)
at .Socket.connect(Socket.java:579)
at .nt.TcpNTAdapter.connect(TcpNTAdapter.java:162)
at .nt.ConnOption.connect(ConnOption.java:133)
at .nt.ConnStrategy.execute(ConnStrategy.java:411)
... 12 more
Caused by: .ConnectException: Connection refused: connect.
关于这个问题我之前已经找过了，但没有一个和我遇到的问题一样的，因为我这个有两个任务都用到了jndi的连接方式，所以网上说的1、防火墙 2、tnsnames.ora 文件中查看详细配置信息 3、端口号被占用 4、服务器中允许的最大进程数 都没关系，操作没有一点作用。
而是，一切无门后和服务器那边厂家联系后，那边说做了安全策略，所以我这里一直无法访问上。等那边添加进去后就解决了
此外还有一种可能，就是对方暂时停用服务器了，所以短期内也连接报错，这个等对方恢复使用后再对数据进行恢复操作。
如果觉得《Oracle远程连接jndi报错The Network Adapter could not establish the connection。。。。Connection refused: connec》对你有帮助，请点赞、收藏，并留下你的观点哦！
