Re: RAC service with Websphere

  • From: Sanjay Mishra <smishra_97@xxxxxxxxx>
  • To: Freek.DHooge@xxxxxxxxx, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 14 Feb 2008 10:55:23 -0800 (PST)

Thanks for the update but it works and all of my 3 WAS server using 5 Node RAC 
is now working with n extra change except the JDBC string.


----- Original Message ----
From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
To: "smishra_97@xxxxxxxxx" <smishra_97@xxxxxxxxx>; "oracle-l@xxxxxxxxxxxxx" 
Sent: Wednesday, February 13, 2008 2:38:42 PM
Subject: RE: RAC service with Websphere


In the websphere installation I manage, I had to define services that where 
bound to one specific rac node (with failover to the other node) because the 
websphere datasources where defined as XA datasources.
With XA all subtransactions must be send to the same rac node.
Also I had to enable DTP for these sessions by using the dbms_service package.

In the configuration we have, there are 2 websphere servers, so I asked the 
websphere administrator to configure the nodes to have each their dedicated 
oracle rac node.


Freek D'Hooge
Oracle Database Administrator
e-mail: freek.dhooge@xxxxxxxxx
tel. +32 (0)3 451 23 82

From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On Behalf 
Of Sanjay Mishra [smishra_97@xxxxxxxxx]
Sent: 13 February 2008 18:24
To: oracle-l@xxxxxxxxxxxxx
Subject: RAC service with Websphere

Can somebody share the RAC configuration with Websphere. This is 5 node RAC and 
using the following


If I try
jdbc:oracle:thin:@gsdk1-vip:1521:gsdkdb1  --> Which is Instance 1 running on 
gsdk1, it is working but I replace it with Service name gsdkserv, it is not 

Sqlplus, Toad or other client tools are working but the issue with websphere 
config. Anybody can chare the resourcex.xml config file

Error is coming like
DSRA8201W: DataSource Configuration: DSRA8040I: Failed to connect to the 
Encountered java.sql.SQLException: Io exception: NL Exception was 
generatedDSRA0010E: SQL State = nulljavascript:SpellCheckOnSend();
Send, Error Code = 17,002.

Looking for last minute shopping deals? Find them fast with Yahoo! Search.

Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ 

Other related posts: