2 Replies Latest reply on May 12, 2010 2:22 PM by targit

JBoss / Oracle RAC load balancing not working as expected

maralcbr Apr 14, 2008 10:34 AM

Hi,

We are actually configuring our Oracle RAC with JBoss.

We did a big test last saturday, and we could notice from that that when a server in the oracle cluster fails, the connections are redirected to the other server.

But, when the other server is up again, the connections does not come back to this server.

My impressions are that until the JBoss pool requests new connections, the active connections will not migrate back to the other server - then - load balancing is not being done as expected.

Somebody have any idea on how to fix that? Does JBoss somehow integrates with Oracle ONS (Oracle Notification Services)? I thought it could solve the situation, but didnÂ´t find much information about integrating it on JBoss.

Thanks in advance.

Marcelo

1. Re: JBoss / Oracle RAC load balancing not working as expecte

vickyk Apr 15, 2008 2:05 AM (in response to maralcbr)

The Jboss JCA Pool just uses the settings from the connection-url and it is the oracle RAC which does take control of the loadbalancing/failover .
http://wiki.jboss.org/wiki/SetUpAOracleDatasource

However if you want the failover to be taken care by the Jboss JCA then you will have to configure ha datasource , this does not take care of loadbalancing yet .
http://wiki.jboss.org/wiki/JBossJCADatabaseFailover

I was not able to get any one interested in this so have kept this on hold
http://www.jboss.com/index.html?module=bb&op=viewtopic&t=125546

Does JBoss somehow integrates with Oracle ONS (Oracle Notification Services)?

I am not sure what do you mean by this , check if this can be configured through the datasource descriptor file .
Actions
2. Re: JBoss / Oracle RAC load balancing not working as expecte

targit May 12, 2010 2:22 PM (in response to vickyk)

In order to benefit from Oracle RAC features like fault tolerance and load balancing all you have to do is configuring the connection url with the list of Oracle hosts which belongs to the cluster.
In this example we are configuring our datasource to connect to a RAC made up of host1 and host2:

<connection-url>jdbc:oracle:thin:@(description=(address_list=(load_balance=on)(failover=on)(address=(protocol=tcp)(host=host1)(port=1521))(address=(protocol=tcp)(host=host2)(port=1521)))(connect_data=(service_name=xxxxsid)(failover_mode=(type=select)(method=basic))))
</connection-url>
Actions

Go to original post