Problem is resolved as it look like a bracket issue. The strange thing I found during the troubleshoot is that jdbc string is taking service_name differently than Oracle_sid jdbc:oracle:thin:@gsdk1-vip:1521:gsdksrv ---Failed jdbc:oracle:thin:@gsdk1-vip:1521/gsdksrv ---Worked Thanks ----- Original Message ---- From: Roman Podshivalov <roman.podshivalov@xxxxxxxxx> To: smishra_97@xxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Sent: Wednesday, February 13, 2008 1:24:36 PM Subject: Re: RAC service with Websphere Hi, Did you check that service you are trying to use in the connection definition was registered with listener running on gsdk1-vip:1521 (hint: LOCAL_LISTENER in init.ora) ? Can you connect like that : sqlplus user/password@gsdk1-vip:1521/gsdkserv ? --romas On 2/13/08, Sanjay Mishra <smishra_97@xxxxxxxxx> wrote: 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. Looking for last minute shopping deals? Find them fast with Yahoo! Search. ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs