ojdbc連接oracle報錯：IO 錯誤: The Network Adapter could not establish the connection

1、報錯日志內容

java.sql.SQLRecoverableException: IO 錯誤: The Network Adapter could not establish the connectionat oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458) ~[ojdbc6-11.2.0.3-11.2.0.3.jar:11.2.0.3.0]at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546) ~[ojdbc6-11.2.0.3-11.2.0.3.jar:11.2.0.3.0]at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236) ~[ojdbc6-11.2.0.3-11.2.0.3.jar:11.2.0.3.0]at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) ~[ojdbc6-11.2.0.3-11.2.0.3.jar:11.2.0.3.0]at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521) ~[ojdbc6-11.2.0.3-11.2.0.3.jar:11.2.0.3.0]at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1643) ~[druid-1.2.11.jar:1.2.11]at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1709) ~[druid-1.2.11.jar:1.2.11]at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2813) ~[druid-1.2.11.jar:1.2.11] Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connectionat oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:392) ~[ojdbc6-11.2.0.3-11.2.0.3.jar:11.2.0.3.0]at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:434) ~[ojdbc6-11.2.0.3-11.2.0.3.jar:11.2.0.3.0]at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:687) ~[ojdbc6-11.2.0.3-11.2.0.3.jar:11.2.0.3.0]at oracle.net.ns.NSProtocol.connect(NSProtocol.java:247) ~[ojdbc6-11.2.0.3-11.2.0.3.jar:11.2.0.3.0]at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102) ~[ojdbc6-11.2.0.3-11.2.0.3.jar:11.2.0.3.0]at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320) ~[ojdbc6-11.2.0.3-11.2.0.3.jar:11.2.0.3.0]... 7 common frames omitted Caused by: java.net.ConnectException: Connection refused: connectat java.net.DualStackPlainSocketImpl.waitForConnect(Native Method) ~[na:1.8.0_331]at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:81) ~[na:1.8.0_331]at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:476) ~[na:1.8.0_331]at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:218) ~[na:1.8.0_331]at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:200) ~[na:1.8.0_331]at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:162) ~[na:1.8.0_331]at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:394) ~[na:1.8.0_331]at java.net.Socket.connect(Socket.java:606) ~[na:1.8.0_331]at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:150) ~[ojdbc6-11.2.0.3-11.2.0.3.jar:11.2.0.3.0]at oracle.net.nt.ConnOption.connect(ConnOption.java:133) ~[ojdbc6-11.2.0.3-11.2.0.3.jar:11.2.0.3.0]at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:370) ~[ojdbc6-11.2.0.3-11.2.0.3.jar:11.2.0.3.0]... 12 common frames omitted

2、報錯原因

application.yml中datasource的url設置有問題。

3、我的解決方案

（1）控制臺獲取oracle數據庫IP地址和端口號

WIN+R 運行 cmd 打開命令行 ==》lsnrctl status ==》獲取oracle數據庫IP地址和端口號

（2）使用SQL Plus或PLSQL Developer獲取oracle數據庫名稱。

新建SQL語句并運行，運行的SQL語句為 SELECT name FROM v$database;

得到數據庫名稱為ORCL，orcl也可以，不區分大小寫。如果沒有修改過數據庫名稱，數據庫名稱默認就為ORCL/orcl。

（3）根據前兩步拼接新url替換application.yml中datasource的url設置。

url: jdbc:oracle:thin:@IP地址:端口號:數據庫名稱
例子：
url: jdbc:oracle:thin:@192.168.50.169:1521:orcl

博主一開始用的是@localhost，但實際上oracle默認的IP地址不是127.0.0.1，所以報錯了。希望這篇文章能幫到你。

總結

以上是生活随笔為你收集整理的ojdbc连接oracle报错：IO 错误: The Network Adapter could not establish the connection的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。