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)(PO > RT=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.<http://us.rd.yahoo.com/evt=51734/*http://tools.search.yahoo.com/newsearch/category.php?category=shopping> >