RE: RAC service with Websphere
- From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
- To: "smishra_97@xxxxxxxxx" <smishra_97@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 13 Feb 2008 20:38:42 +0100
Hi,
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.
regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
e-mail: freek.dhooge@xxxxxxxxx
tel. +32 (0)3 451 23 82
http://www.uptime.be
disclaimer
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
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=gsdk1-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=gsdk2-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=gsdk3-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=gsdk4-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=gsdk5-vip)(PORT=1521))(LOAD_BALANCE=yes))(CONNECT_DATA=(SERVICE_NAME=gsdkserv)))
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
working
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
DataSource.
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
