环境是WebSphere 6.0连接10g rac的时候连接出现负载均衡的问题。
原因:
当前WebSphere 6.0的JDBC驱动是9i的, 而且9.2.0.8以前的jdbc thin drive是不支持rac的负载均衡
JDBC Thin does not support redirection to another NET listener
解决方法当然是换成9.2.0.8或者10g的jdbc drive.
就是这样,简单记录一下:
下面是metalink的内容转载,供参考:
Subject: Cannot Connect When Using 9.2.0.1 Thin Driver And Loadbalancing
Doc ID: Note:371702.1 Type: PROBLEM
Last Revision Date: 14-MAY-2008 Status: PUBLISHED
In this Document
Symptoms
Cause
Solution
References
Applies to:
JDBC - Version: 9.2.0.1.0
This problem can occur on any platform.
Symptoms
Using 9.2.0.1 JDBC Thin driver to access a RAC cluster with the following connect string :
jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST =(LOAD_BALANCE=ON)(ADDRESS = (PROTO = TCP)(HOST =host2)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = host1)(PORT = 1521)))(CONNECT_DATA =(SERVER =DEDICATED)(SERVICE_NAME = DB102)))
At connection time, the following exception is occuring :
java.sql.SQLException: Io exception: Connection refused (DESCRIPTION=(ERR=1153)(VSNNUM=153093632)(ERROR_STACK=(ERROR=(CODE=1153)(EMFI=4)(ARGS='(ADDRESS=(PROTO =TCP)(HOST=hostname)(PORT=1521))'))(ERROR=(ODE=305)(EMFI=1)))).]
Cause
The cause of this problem has been identified and verified in an unpublished Bug 2427185.
It is caused by the fact that the JDBC Thin does not support redirection to another NET listener
Solution
Upgrade the JDBC driver version to the latest version, for example 9.2.0.8.
原因:
当前WebSphere 6.0的JDBC驱动是9i的, 而且9.2.0.8以前的jdbc thin drive是不支持rac的负载均衡
JDBC Thin does not support redirection to another NET listener
解决方法当然是换成9.2.0.8或者10g的jdbc drive.
就是这样,简单记录一下:
下面是metalink的内容转载,供参考:
Subject: Cannot Connect When Using 9.2.0.1 Thin Driver And Loadbalancing
Doc ID: Note:371702.1 Type: PROBLEM
Last Revision Date: 14-MAY-2008 Status: PUBLISHED
In this Document
Symptoms
Cause
Solution
References
Applies to:
JDBC - Version: 9.2.0.1.0
This problem can occur on any platform.
Symptoms
Using 9.2.0.1 JDBC Thin driver to access a RAC cluster with the following connect string :
jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST =(LOAD_BALANCE=ON)(ADDRESS = (PROTO = TCP)(HOST =host2)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = host1)(PORT = 1521)))(CONNECT_DATA =(SERVER =DEDICATED)(SERVICE_NAME = DB102)))
At connection time, the following exception is occuring :
java.sql.SQLException: Io exception: Connection refused (DESCRIPTION=(ERR=1153)(VSNNUM=153093632)(ERROR_STACK=(ERROR=(CODE=1153)(EMFI=4)(ARGS='(ADDRESS=(PROTO =TCP)(HOST=hostname)(PORT=1521))'))(ERROR=(ODE=305)(EMFI=1)))).]
Cause
The cause of this problem has been identified and verified in an unpublished Bug 2427185.
It is caused by the fact that the JDBC Thin does not support redirection to another NET listener
Solution
Upgrade the JDBC driver version to the latest version, for example 9.2.0.8.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12361284/viewspace-620293/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12361284/viewspace-620293/