Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g85I8W519564 for ; Thu, 5 Sep 2002 14:08:32 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id JAA65785; Thu, 5 Sep 2002 09:04:26 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 004C8893; Thu, 05 Sep 2002 08:08:31 -0800 Message-ID: Date: Thu, 05 Sep 2002 08:08:31 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Yechiel Adar" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Yechiel Adar" Subject: Re: Fail Over Options Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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 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" 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. > > dwilliams@lifetouch.com > > > > > > -----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 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. > > > dwilliams@lifetouch.com > > > > > > > > > -----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 > > > pnbarne@regence.com > > > > > > __________________________________________________ > > > 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: regdba@yahoo.com > > > > > > 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: ListGuru@fatcity.com (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). > > > -- > > > Please see the official ORACLE-L FAQ: > > > http://www.orafaq.com > > > -- > > > Author: DENNIS WILLIAMS > > > INET: DWILLIAMS@LIFETOUCH.COM > > > > > > 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: ListGuru@fatcity.com (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). > > > > > > ===== > > Pete Barnett > > Lead Database Administrator > > The Regence Group > > pnbarne@regence.com > > > > __________________________________________________ > > 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: regdba@yahoo.com > > > > 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: ListGuru@fatcity.com (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 > > > === message truncated === > > > ===== > Pete Barnett > Lead Database Administrator > The Regence Group > pnbarne@regence.com > > __________________________________________________ > 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: regdba@yahoo.com > > 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: ListGuru@fatcity.com (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: adar76@inter.net.il 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: ListGuru@fatcity.com (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).