jdbc连接oracle多个库负载均衡

oracle负载均衡

原文链接：https://blog.csdn.net/hyy_217/article/details/72782749

数据进行了分库，没有分表。

解决方案：

 datasource:
    driver-class-name: oracle.jdbc.OracleDriver
    url: jdbc:oracle:thin:@(DESCRIPTION =(FAILOVER=ON)(LOAD_BALANCE=ON)(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.4)(PORT = 3436))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.5)(PORT = 3436))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = ZXJY)( FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC))))
    username: xxx
    password: xxx

 

描述：oracle做了负载均衡，不能直接通过ip去连接，需要用listener.ora的连接配置才能连接。