Oracle Io 异常: The Network Adapter could not establish the connection 解决

http://www.iteye.com/problems/47907 谢谢这位大哥-------------未解(win7下)

Exception;如下:

java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:404)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.xwl.oracle.db.util.OracleConnection.main(OracleConnection.java:25)

解决代码:

Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); 

String addrRAC = "(ADDRESS=(PROTOCOL=TCP)(HOST =10.0.5.62)(PORT =1521))(ADDRESS=(PROTOCOL=TCP)(HOST =10.0.5.60)(PORT =1521))"; 

String url = "jdbc:oracle:thin:@" + "(DESCRIPTION=" 
+ "(ADDRESS_LIST=" + addrRAC + ")" + "(CONNECT_DATA=" 
+ "(SERVER=DEDICATED)" + "(SERVICE_NAME=racdbs)" + ")" 
+ ")"; 

Connection oracn = DriverManager.getConnection(url, "system","qz123456"); 


我的正确代码:

String addrRAC = "(ADDRESS=(PROTOCOL=TCP)(HOST =192.168.1.100)(PORT =1521))(ADDRESS=(PROTOCOL=TCP)(HOST =192.168.1.100)(PORT =1521))"; 


String url = "jdbc:oracle:thin:@" + "(DESCRIPTION=" 
+ "(ADDRESS_LIST=" + addrRAC + ")" + "(CONNECT_DATA=" 
+ "(SERVER=DEDICATED)" + "(SERVICE_NAME=orcl_xwl)" + ")" 
+ ")";

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值