Webspere配备Oracle RAC集群数据源,Oracle双机的IP为10.10.10.121与10.10.10.122 ,范例名位别为orcl一与orcl二,服务名叫oracledbservice,采取联接串应为:
jdbc:oracle:thin:@(description=(ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.121)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.122)(PORT = 1521)))(FAILOVER=yes)(LOAD_BALANCE=yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = oracledbservice)))
测试的时分,有时候顺利,有时候失败,报如次错处:
java.sql.SQLException: Io 异常: The Network Adapter could not establish the connectionDSRA0010E: SQL 状态 = null,错误代码 = 17,002 而失败。
解决办法:
批改服务器的hosts资料,加入IP地址与服务器名对应关系,如次:
127.0.0.1 localhost
10.10.10.121 orcl一
10.10.10.122 orcl二
原稿http://diysnoopy.javaeye.com/blog/471054
Webspere配备Oracle RAC集群数据源的问题
Webspere配备Oracle RAC集群数据源,Oracle双机的IP为10.10.10.121与10.10.10.122 ,范例名位别为orcl一与orcl二,服务名叫oracledbservice,采取联接串应为:
jdbc:oracle:thin:@(description=(ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.121)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.122)(PORT = 1521)))(FAILOVER=yes)(LOAD_BALANCE=yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = oracledbservice)))
测试的时分,有时候顺利,有时候失败,报如次差错:
java.sql.SQLException: Io 异常: The Network Adapter could not establish the connectionDSRA0010E: SQL 状态 = null,错误代码 = 17,002 而失败。
解决办法:
批改服务器的hosts资料,加入IP地址与服务器名对应关系,如次:
127.0.0.1 localhost
10.10.10.121 orcl一
10.10.10.122 orcl二
本文来源:
我的异常网
Java Exception
Dotnet Exception
Oracle Exception
- 1310 - JS的open画面机制
- 1311 - ORA-00907: 缺失右括号
- 1312 - 虚拟主机名似乎已分配
- 1313 - An unhandled exception occurred during the execution of
- 1314 - Wrong password for user
- 1315 - ORA-01843: 无效的月份
- 1316 - ORA-00905: missing keyword
- 1317 - ORA-06553: PLS-306
- 1318 - ora-00911
- 1319 - ADO连接ORCALE出现连接错误
- 1320 - 存储过程错误
- 1321 - Oracle 10g宝典
- 1322 - Oracle Database 10g完全参考手册
- 1323 - ORACLE异常处理
- 1324 - 名称已由现有对象使用
- 1325 - Unable to read the list of homes from the inventory
- 1326 - oracle的多表分页存储过程调用出错
- 1327 - update错误
- 1328 - Examine the description of the EMPLOYEES table
- 1329 - error C2270