Jdbc client side load balancing
Hi Experts,
I have a customer who has one single instance database and has configured listeners with port 1521, 1522, 1523, 1524 for a single instance.
Currently sometimes one listener is getting heavily loaded so he wants to load balance between listener 1521 & 1524 so that the connections should distribute.
I couldn't find any document on client side load-balancing guide for JDBC client. Could anyone help with the pointer?
Is the below client URL configuration correct ?
url="jdbc:oracle:thin:@(DESCRIPTION=
(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=1524))
(CONNECT_DATA=(SERVICE_NAME=TFL3)))"
If no, could you kindly help me with a connection string through which customer can balance the listener loads?
I have a customer who has one single instance database and has configured listeners with port 1521, 1522, 1523, 1524 for a single instance.
Currently sometimes one listener is getting heavily loaded so he wants to load balance between listener 1521 & 1524 so that the connections should distribute.
I couldn't find any document on client side load-balancing guide for JDBC client. Could anyone help with the pointer?
Is the below client URL configuration correct ?
url="jdbc:oracle:thin:@(DESCRIPTION=
(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=1524))
(CONNECT_DATA=(SERVICE_NAME=TFL3)))"
If no, could you kindly help me with a connection string through which customer can balance the listener loads?
0