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的连接配置才能连接。