RAC service with Websphere
Date: Wed, 13 Feb 2008 09:24:01 -0800 (PST)
Message-ID: <190957.12130.qm@web51307.mail.re2.yahoo.com>
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. http://tools.search.yahoo.com/newsearch/category.php?category=shopping
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 13 2008 - 11:24:01 CST