问题描述

java 连接 oracle数据库 抛 Io 异常 ... 求解啊！！

import java.sql.*;

public class TestJDBC {

public static void main(String[] args) throws Exception{
        Class.forName("oracle.jdbc.driver.OracleDriver");
        //new oracle.jdbc.driver.OracleDriver();
        Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.1:1521:SXT", "scott", "tiger");
}

}

 console：
Exception in thread "main" java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:189)
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:231)
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:345)
    at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:428)
    at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:515)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:345)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at TestJDBC.main(TestJDBC.java:8)

解决方案

参考：http://bbs.csdn.net/topics/110038738

解决方案二：

192.168.0.1这是你电脑的ip地址吗？如果是连自己电脑的数据库用localhost，如果是其他人的确保防火墙关闭了

解决方案三：

你们说的我都试过了，还是不行啊，崩溃啦..

解决方案四：

检查Net Manager配置，LISTENER和你写的是否一样