load balancing not working

1043708

Hi,

We're using jboss to connect to oracle RAC.

We have two nodes (ora1 and ora2 - both on oracle linux), but all the traffic goes to ora2. We'd like the traffic to go to both ora boxes.

It's not a network issue. I'm able to telnet from our application box to both oracle boxes.

Here is the string:

@(DESCRIPTION=

  (ADDRESS_LIST=

  (ADDRESS=

  (PROTOCOL=TCP)

  (HOST=10.23.1.125)

  (PORT=1522)

  )

  (ADDRESS=

  (PROTOCOL=TCP)

  (HOST=10.23.1.126)

  (PORT=1522)

  )

  )

  (LOAD_BALANCE = on)

  (CONNECT_DATA =

  (SERVER = DEDICATED)

  (SERVICE_NAME = dbstring)

  )

)

Thanks!   

1043708

I fixed the connection string:

(LOAD_BALANCE = on) was outside of the DESCRIPTION (). I moved it inside the DESCRIPTION part and added FAILOVER=on, and it started working.

Unknown

We're using jboss to connect to oracle RAC.
We have two nodes (ora1 and ora2 - both on oracle linux), but all the traffic goes to ora2. We'd like the traffic to go to both ora boxes.

Post your question in a JBOSS forum and ask how to configure JBOSS properly.

Jean De Lavarene-Oracle

You should make sure that your RAC listener is able to balance the load. Use remote listeners and SCAN if possible.

1043708

I fixed the connection string:

(LOAD_BALANCE = on) was outside of the DESCRIPTION (). I moved it inside the DESCRIPTION part and added FAILOVER=on, and it started working.