在WebSphere中配置配置Oracle RAC集群的数据源,假设Oracle RAC双击分别为 HOST1 与 HOST2 , 端口为1521 ,服务名为 orcldbservice,则配置的URL连接串为
jdbc:oracle:thin:@(description=(ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = HOST1)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = HOST2)(PORT = 1521)))(FAILOVER=yes)(LOAD_BALANCE=yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcldbservice)))
配置时,记得修改Oracle数据源的类路径。 创建数据源之后,需要重启nodeagent , 否则测试不会通过。