About load balancing
I have a question related to RAC load balancing on Oracle Database 10g Enterprise Edition Release 10.2.0.4.0.
JDBC Connection string :
jdbc:Oracle:thin:@(DESCRIPTION=(FAILOVER=on)(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=10.83.43.103)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.83.43.107)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=TOE2P_PROD)))
Issue : Application team observes on node1= 0 and node2 =30 connections..
1) Is loadbalancing is working on not?
2) Whether it is client side or serverside or both load balancing?.
DB Node 1 | DB Node 2 |
14 | 16 |
23 | 7 |
38 | 6 |
0 | 30 |
srvctl config service -d TOE2P -s TOE2P_PROD -a
TOE2P_PROD PREF: TOE2P2 TOE2P1 AVAIL: TAF: none
Note : Here TAF=none
1