Veritas Cluster Server does this. I understand 9i RAC does this as well, but I do not have any hands on experience with it.
Pete --- Yechiel Adar <[EMAIL PROTECTED]> wrote: > I heard that there is a network switch or router > that does dynamic > translation > of IP addresses. So you can always connect to one > address and change the > translation in the switch/router in case of fail > over. > This should be transparent to your thin jdbc client. > > Yechiel Adar > Mehish > ----- Original Message ----- > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > Sent: Wednesday, August 28, 2002 11:18 PM > > > > Ricjard is correct. jdbc thin client does not > allow > > transparent fail over. The thick client reads a > > tnsnames.ora file which is where the fail over > > actually occurs. There are multiple server names > for > > the same service name. If the first server in the > > search is down, it falls through to the next > server. > > > > jdbc is a straight connection to a single > database. > > No read of tnsnames.ora. > > > > Pete > > > > --- "Ji, Richard" <[EMAIL PROTECTED]> > wrote: > > > Dennis, > > > > > > One thing you can't do with Thin driver is > > > Transparent Application Failover > > > which is what Peter wants to do I believe. > > > > > > Richard > > > > > > -----Original Message----- > > > Sent: Wednesday, August 28, 2002 1:00 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > Peter - A couple of issues come to mind: > > > > > > 1) So you are saying that connection failover is > > > your prime interest at this > > > stage? I was thinking database failover when I > saw > > > your question. > > > 2) So what is wrong with thin client? At my site > we > > > are tending to go with > > > thin so we don't have to install SQL*Net client > on > > > every app server. That > > > was what attracted us to Java in the first > place. > > > Everything I've seen says > > > that for some applications thin has better > > > performance and for others OCI is > > > better. Personally I like having options. > > > 3) How committed to Oracle is your site? If you > have > > > a heavy Oracle > > > commitment, you may be able to stick it to IBM's > > > attitude. Traditionally IBM > > > has had an attitude of "use all of our stuff". > This > > > goes back to when they > > > were the Microsoft of the computer industry. > Nobody > > > worries about IBM > > > monopolizing the industry today. Obviously they > are > > > learning to shed that > > > parochial attitude in order to succeed today. > I'll > > > bet if you complained up > > > the IBM management chain about this person's > > > attitude you might see a change > > > for the better. > > > > > > Dennis Williams > > > DBA > > > Lifetouch, Inc. > > > [EMAIL PROTECTED] > > > > > > > > > -----Original Message----- > > > Sent: Tuesday, August 27, 2002 5:49 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > Dennis, > > > > > > This is a auite of products. The prime offender > is > > > WebSphere, an IBM product. The IBM consultants > have > > > been particularly difficult to deal with. > According > > > to them, nothing Oracle ever produced works. > > > > > > The project specifications call for transparent > fail > > > over which is possible using Oracle's thick > client. > > > Unfortunately, WebSphere does not seem to be > able to > > > use anything but jdbc thin client. > > > > > > If we can't get this to work, we will likely go > to > > > something like Veritas Cluster Server. > Replication > > > provided a solution that had already paid for. > > > > > > > > > --- DENNIS WILLIAMS <[EMAIL PROTECTED]> > wrote: > > > > Peter - Have you looked at Oracle Standby > Server? > > > > Which App server are you > > > > using? Most of them claim to help you with > this. > > > > Dennis Williams > > > > DBA > > > > Lifetouch, Inc. > > > > [EMAIL PROTECTED] > > > > > > > > > > > > -----Original Message----- > > > > Sent: Tuesday, August 27, 2002 3:38 PM > > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > > > We are looking at fail over options for > databases > > > in > > > > a > > > > 7x24 e-commerce environment. > > > > > > > > Currently, we are using advanced replication. > It > > > > works but it is labor intensive. We have also > > > > discovered that the application can only use > jdbc > > > > rather than the Oracle thick client. In > essence, > > > > this > > > > replication is now manual fail over. > > > > > > > > Would someone who has made java and the thick > > > client > > > > work provide some pointers to getting it to > work? > > > > > > > > > > > > > > > Thanks, > > > > > > > > > > > > > > > > ===== > > > > Pete Barnett > > > > Lead Database Administrator > > > > The Regence Group > > > > [EMAIL PROTECTED] > > > > > > > > > __________________________________________________ > > > > Do You Yahoo!? > > > > Yahoo! Finance - Get real-time stock quotes > > > > http://finance.yahoo.com > > > > -- > > > > Please see the official ORACLE-L FAQ: > > > > http://www.orafaq.com > > > > -- > > > > Author: Peter Barnett > > > > INET: [EMAIL PROTECTED] > > > > > > > > Fat City Network Services -- (858) 538-5051 > > > FAX: > > > > (858) 538-5051 > > > > San Diego, California -- Public > Internet > > > > access / Mailing Lists > > > > > > > > > > -------------------------------------------------------------------- > > > > To REMOVE yourself from this mailing list, > send an > > > > E-Mail message > > > > to: [EMAIL PROTECTED] (note EXACT spelling > of > === message truncated === ===== Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __________________________________________________ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
