Question

JDBC 连接Oracle 10g 异常Connection reset如何解决

oracle10g 的服务已启动代码好下:Class.forName(OpProperties.getValue("oracledriver"));conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","system","lwb");出现的异常:java.sql.SQLException: Io 异常: Connection reset at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:274) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:319) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:344) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:148) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.lwb.dao.daoutil.DBConnection.getConnecton(DBConnection.java:26) at com.lwb.dao.OpProduce.diplay(OpProduce.java:16) at com.lwb.dao.OpProduce.main(OpProduce.java:39)Exception in thread "main" java.lang.NullPointerException at com.lwb.dao.OpProduce.diplay(OpProduce.java:19) at com.lwb.dao.OpProduce.main(OpProduce.java:39)

Answer 1

做如下检查：
1 你在虚拟机上（下面称之为服务器）可否正常登录数据库并查询数据sqlplus
2 服务器上 用sqlplus user/pwd@orcl 的方式能否登录？
3 服务器的防火墙是否开着，是否没有为oracle调整过 -------------针对你的错误提示， 重点是这个
4 客户端用oracle sql developer 连接时，地址，端口，数据库实例名，用户名，密码，是否都正确？

Answer 2

少了个驱动包

Answer 3

服务器配置的问题吧