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_at_gsdk1-vip:1521/gsdkserv ?

--romas

On 2/13/08, Sanjay Mishra <smishra_97_at_yahoo.com> 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>
>

--
http://www.freelists.org/webpage/oracle-l