java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection解决方法

一。异常报错

java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:254)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:438)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:164)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:752)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:140)
        at test.T.main(T.java:29)

 

二。解决办法

1）排查连接数据库用户名和密码等参数是否正确；

2）orcle11版本url格式jdbc:oracle:thin:@ip:1521:SID

orcle10以下jdbc:oracle:thin:@IP:1521/SID

3）ping orcle数据库IP和端口

本次报错原因是orcle服务端口ping不通。